Page 1 of 1

Query Succeeds Report Fails

Posted: Tue Feb 27, 2018 8:34 pm
by JayFF
Hi All,

I am creating a new report that required me to create a new Report Query. I have tested the aggregate query exhaustively and it returns one record which is the expected result. I pointed the new report to the new query. It is a very simple report. It groups by Vehicle and contains no functions just a few columns. When I run the report, no result rows are included, just the PeriodStart and PeriodEnd values. I can add the report to the application and run it, but I get the same result, no entries. I would greatly appreciate any guidance on how to figure out why the query returns rows, but they don't display in the report.

Thanks,
Jay