Crystal Report - Export to Excel / Page set up

[Former Member]

1.Table having column more then 20

In Crystal report when we tried with a Table having 6 columns, then the alignment and formating of the table in the report was fine. When we added few more columns, we needed to adjust the page set up to display all the column data without overlapping. We have a report with a table containing more than 20 columns, is there a chance to wrap the table columns without overlapping with other columns in crystal reports default page set up (A4). Please suggest.

Also, we need to provide provisions to Export to Excel, Export to Pdf, Print etc. We would like to know the possible solutions and the limitations with respect to this requirement.

Another Question

2.Exporting to Excel in Crystal Reports

During the crystal report design, the text fields are arranged one after the another with proper line spacing. when we export to Excel format,the alignment in the Excel is having the line spacing that was given in Desing as an Empty Row each with different heights.How to make the report more professional by proper line spacing between each sections in the crystal report.Please recommend the possible ways to avoid this formatting issue in Excel.

[DellSC]

There are several things you can do to get a "clean"export to Excel and other file types.

1.  Make sure that you line up column headings with column data - everything in a column should be left aligned and the exact same width.

2.  When you put a second column on the report, start it exactly where the previous column ends.  I usually put a guide marker on the ruler, aligned to the right side of the first column and then align the left side of the second column with the guide.  Do this same sort of thing with all of the columns to line each up with the previous.

3.  Make all of your column headers the same height - preferably just one row.

4.  Try to line up the items in the header and footer with the column boundaries in the data.  You can span multiple columns, but line them up with one column on the left and the same or a different column on the right.

Following these steps prevents having your data in merged columns or having blank columns between data columns.

For the page, go to the File menu and select Page Settings.  Turn on "No Printer (optimize for screen display)" and "Dissociate Formatting Page Size from Printer Paper Size".  Set the page orientation to Landscape.  Make the page wide enough to display all of your columns.

-Dell

[Former Member]

Hi Mohan,

Select all the fields in the Details section--> right click on that fields --> select 'Format Fields' -->Select 'common' tab --> Select ' Can Grow' option for those filed's.

Then those filed's will not wrap and display to bottom line in that field.

2) for Exporting to Excel  You need to align the  filed values properly.

For applying proper alignment between Text objects,use rulers and Grid lines. This will help to avoid the spaces between Text objects.

Hope this information will help you.

--Naga.