Is there limit on number of columns in Crystal Report 1

[Mruna]

Hi,

I was trying to design a crystal report in 7. I was using stored procedure and I need to display about 30 columns, whatever the page size I select, it only allows me around 7 to 10 columns. Size of the columns - anywhere from 2 char to 60 char.

Is there way I can add all my 30 columns to the report. I would like to store the final result to excel for user manipulation.

I appreciate your input and any work arounds.

Thanks and have a nice day!
Mruna.

 

[princessinthetower]

The columns can overlap. In Preview you won't be able to read it but it will export to Excel just fine. Make all the fields the same width regardless of the content and overlap them with a small offset so that they fit across the page. Use guidelines for exact placement.

 

[chelseatech]

Also, to give yourself a bit more room across the page, select a printer that supports a large page size like A3 landscape.

Even if the printer doesnt' exist, create one on a fictitious port. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Mruna]

Thanks for the replies. Yes, I did the same way to make the columns very small. To fit properly, I used Auto-Arrange Report format and which took care of putting all the columns nicely. The only drawback, users can't see the report output on the screen properly until they export it to excel. Hey, it worked out okay in this requirement as the users wanted it in excel.

Cheers!
Mruna

 

[synapsevampire]

As Clelsea mentioned, use a different printer driver (I use the standard Windows HP Design Jet 3500CP driver which allows for 96" in Landscape mode).

That way it can display properly in Crystal, and export well.

-k

 

[paulosinuk]

Guy's,

You've just saved me going blind, trying to work with 90 columns on an A3 page.

54" X 76" pages! Very, very useful when your only exporting to Excel.

Cheers

Paulos

 

[paulosinuk]

Guy's,

You've just saved me going blind, trying to work with 90 columns on an A3 page.

54" X 76" pages! Very, very useful when your only exporting to Excel.

Cheers

Paulos