Skip to Content
0
Former Member
Aug 29, 2012 at 02:21 PM

How to handle too many columns in the reports

283 Views

Hello,

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:

8/20/2012

column1 c1-1

column2 c2-1

column3 c3-1

column4 c4-1

........

column50 c50-1

on the 2nd page of the report:

8/21/2012

column1 c1-2

column2 c2-2

column3 c3-2

column4 c4-2

........

column50 c50-2

on the 3rd page of the report:

8/22/2012

column1 c1-3

column2 c2-3

column3 c3-3

column4 c4-3

........

column50 c50-3

Anyone knows how can I do this in Crystal Report?

Thank you in advance for your help.