I have created a crosstab, and it works fine.
It shows months in each column, and sales per month. The problem is when a month doesn't have sales, this month will be hidden in the crosstab. I want the crosstab to show this month with zero values! is there a setting to avoid this tab-behaviour?
I'm using telerik 2012 Q1
It shows months in each column, and sales per month. The problem is when a month doesn't have sales, this month will be hidden in the crosstab. I want the crosstab to show this month with zero values! is there a setting to avoid this tab-behaviour?
I'm using telerik 2012 Q1
1 Answer, 1 is accepted
0
Hi Peter,
Elian
the Telerik team
The CrossTab only shows the input data, it cannot change it or complete it. In your case some months are missing. A workaround could be to load the data manually and plug zero records for the months that are missing. This way all months will have at least one value and will be displayed.
Regards,Elian
the Telerik team
NEW in Q1'12: Telerik Report Designer (Beta) for ad-hoc report creation. Download as part of Telerik Reporting Q1 2012. For questions and feedback, use the new Telerik Report Designer Forum.