Crystal Report - Export to Excel / Page set up
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.
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.