Cross tab formatting issues
Can you please suggest me on can grow functionality w.r.t cross tab. For example, if the data in one cell is large, then it gets trimmed off instead of wrapping it and enlarging of cell.
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?
While exporting to excel, I select Following steps to export crystal report cross tab to excel:
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?
While exporting to excel, I select Following steps to export crystal report cross tab to excel:
- Export Report
- Microsoft-Excel (97-2003)
- In Excel Format Option I select "Show Gridlines" field
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thank you for your explanation. It helped in better understanding.
Thank you for your explanation. It helped in better understanding.
ASKER
In report I have kept extra space for each cell of cross tab so that if data is large then it should be properly displayed in that defined cell.
That's the reason the excel export is looking fine.
In my cross tab, the width of Serial number is 0.5 cm, but when I export the cross tab to the excel, then the width of the serial number is not the same. Extra unwanted width is displayed on the excel export.