I have a report with three cross tabs embedded in three report footers (RFa, RFb, RFc). The third cross tab in RFc, is actually in a subreport. When I preview the report and then export to excel in Excel Data Only there is no problem. Howeever, when I export the report (with the same export settings as before) without previewing it first, it truncates the data found in the first and third crosstabs. Anybody have any ideas on what could be causing this? I have played with the settings in the export options and have gotten it to export the first and second crosstabs without previewing but the third crosstab is still a problem.
I thought that Crystal reports would export exactly what is in the report and I do not know why previewing should matter or not?
Thank you for your help!
I am unable to recreate this on my end. Which data in the crosstab gets truncated, the summaries?
What kind of summary is used?
What type of field is summarized? numeric, string, currency...
How many rows and columns are in these crosstab?
What happens if you place the PageNofM special field in the Page Footer? (This causes the whole report to process rather than just the first page though I am not sure if this will have an affect as the export should be processing the whole report)