So, the darndest thing. I’m trying to use an existing report as a template for a new one with different SQL. I have the template saved as an .repx file.
When I add in the new SQL and fields and run the report it will only display the FIRST group from the report. If I’m grouping by county, and I have ‘County 1’ and ‘County 2’, I will only get ‘County 1’ data in the group section. Data from both counties are showing up in the data tab when I run the report.
I can’t find any settings that are limiting the number of groups displayed to ‘1’. Are there?
If I use the Report Wizard to start from scratch and add in that same SQL, it groups out perfectly, both counties will display. If I can’t work around this, then I effectively can’t use templates.
Anyone know how to solve this?