I am using CR 10.x.

My requirement is, i have to group the data based on region and states and display data based on dates. Dates are selected from the UI. I have used the cross tab, but the problem i am getting is, i am not able to show all the dates (dates in which data is not present). I want to display all the dates, if data is not there (for the selected dates.)

 

Region       State         Date1           Date2           Date3.... etc

 

If anyone is having idea, pls let me know.

 

Thanks

Sunny