I'm creating a report using the standalone report designer where I'm using a crosstab (column group) to aggregate data by date over a certain range of dates which is given as a parameter to the report. I would like to display all the dates in the given range in the crosstab, even if some of those dates have no data. I have been banging my head against a wall trying to achieve this for a while, are you able to suggest a solution? I figured I could manipulate my SQL query to ensure that each date has at least one row by doing an outer join with a calendar table but I was wondering if some more convenient solution existed without me having to modify the query itself.
1 Answer, 1 is accepted
Hello TK,
Our Reporting tool is data-driven and for that reason, when there is no data for a particular expected group, the group won't be generated. I confirm that the workaround with the query that returns data for all groups is the recommended one. It will require a one-time rewriting of the query.
The other workarounds we may be able to suggest would probably require greater efforts both for creating and maintenance. The reason is that in order to generate groups that are not present in the data it may be necessary to hard-code all the group columns as static groups. That said, for each data range change you will have to edit the report.
Regards,
Todor
Progress Telerik