I have a report which contains 50+ columns. It's impossible to display all of them on the report in the normal way. The feature of this report is that there is only one record per day.
What I'd like to do is to list the titles of these 50+ column in the first column of the report (that is, instead of putting them on top of the report, place them at left of report) and display corresponding values at right of each column's title, as the second column, one page per day (or say, one record for one day per page).
For example, normal report should look like below:
date column1 column2 column3 column4 ........ column50
8/20/2012 c1-1 c2-1 c3-1 c4-1 ........ c50-1
8/21/2012 c1-2 c2-2 c3-2 c4-2 ........ c50-2
8/22/2012 c1-3 c2-3 c3-3 c4-3 ........ c50-3
What I need is:
on the 1st page of the report:
on the 2nd page of the report:
on the 3rd page of the report:
Anyone knows how can I do this in Crystal Report?
Thank you in advance for your help.