report layout

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

phani (BOB member since 2003-11-24)

And which problem are you encountering?


Andreas :de: (BOB member since 2002-06-20)

You have 1 of 2 problems.

  1. Do a custom sort to get the months to sort the way you want.

  2. 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.


Steve Krandel :us: (BOB member since 2002-06-25)