Show dates without data in crosstab

1 Answer 29 Views
CrossTab Grouping Report Designer (standalone)
TK
Top achievements
Rank 1
TK asked on 22 Jul 2021, 08:22 AM

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

Sort by
1
Accepted
Todor
Telerik team
answered on 27 Jul 2021, 12:45 PM

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

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
CrossTab Grouping Report Designer (standalone)
Asked by
TK
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or