Exporting Cross Tabs to Excel - Data Only

[Former Member]

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!

[former_member260594 · Accepted solution]

Hello Athalia,

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)

[Former Member · Accepted solution]

Hi Graham,

Well the crosstab columns for every crosstab are every hour of the day so 00-23.

First crostab has about 52 rows.

The secong crosstab has about 72 rows.

The third crostab should have about 12 rows and I am doing sums of three separate criteria as the summaries. When I try to export without previewing it first it will only display one column, the 23:00 hour and then the vertical total and one row with the horizontal total. The counts and summaries for that hour that displays are also wrong.

Thank you for your help.

[former_member260594 · Accepted solution]

Athalia,

I tried to recreate the issue using the Xtreme sample database with 3 crosstabs in RFa,b,c with hours of the day as columns. First crosstab has rows for Region, second uses City, and third uses Country.

All 3 are summarizing Customer Credit ID and the 3rd has the sum of Last Years Sales and count of Address1.

When I export this I get the correct result whether the report is previewed or not. I am using the exporting options, Maintain Relative Object position, Maintain Column Alignment, and Simplify Page Header

I would suggest;

a) Ensure that the 3 crosstabs are left aligned and that the column widths of all 3 are the same

b) If there are any other sections in the report that are visible try suppressing all but the 3 sections with the crosstabs in them, will it export now?

c) Try recreating the 3rd crosstab adding just 1 summarized field at a time until it fails and then any formatting that you had done until it fails to try and narrow down what is causing the truncation

d) Try creating a similar report using the Xtreme sample database to see if you can recreate the issue and if so then document the steps so that I can recreate it.

[Former Member · Accepted solution]

Thanks for your help. Originally I had the third crosstab in the report footer section of the subreport. I was able to solve the problem by moving that third crosstab to the report header of the subreport. I am not quite sure what the difference is but it now works.

Thanks again!