How to control page breaks in a Cross Tab?

[Former Member]

Hi,

I have a Crystal Report, which is made into a Cross Tab. This Cross Tab has 3 levels.

But when i exported the report to Microsoft Excel(97-2000), it is page breaking somewhere in the middle and the headers are repeated in the next page. Is there a way, i can overcome this issue? Please advise.

Edited by: SAMER ATIYA on Apr 26, 2011 3:48 PM

[Former Member]

Thank you! I did set a very big page now and it works now!

[Former Member]

No, the crosstab is exporting exactly as it is in the report.

Debi

[Former Member]

Is there a way to switch off the page breaks? Afterall, i'm exporting to Excel and wouldn't require any page breaks..

Please advise.

[Former Member]

Set printer options to No Printer, and then try setting your page very large.

[Former Member]

Doesn't work.. How do i upload my report? I don't see an option here..

Please suggest..

[Former Member]

Did you set your page size to be big enough to display the entire cross tab without page breaks?

If that does not work, then you are stuck. The crosstab will export exactly as displayed in your report. Crosstabs are great for a quickly designed report but they do not export well .

I personally never export crosstabs to excel as my people usually want to be able to manipulate the data and crosstabs do not export cleanly. Instead I will create a manual crosstab and export that instead. It takes more work but it gives a clean export.

Debi