Hi gurus…
I have a specific req which is a cross tab…
i have a date field, product dimension and the count of the product
the layout should be some thing like this
jan feb mar apr jun july..... dec
p1 2 3 4 5 1
p2 1 8 4 5 1
Do a custom sort to get the months to sort the way you want.
You are finding gaps in the months where there was no activity. You need a 2nd data provider that returns all the months. Use the month from the 2nd data provider in the crosstab. If your report uses sections, then this won’t work.