Posts: 119
Joined: Fri Oct 03, 2014 1:03 am
Location: USA
Contact: Website

Query Succeeds Report Fails

Tue Feb 27, 2018 8:34 pm

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.

J. F. Florey

Return to “GpsGate Server - How to setup and use”