Subreport data multiplying when exported to excel

[pdankert]

In CR 8.5 I have a subreport in the report footer that displays data and totals. Those same total values are also passed back to main report to be used in a grand total calculation. Data calculates and displays properly in Crystal. When exported to Excel the Subreport totals have trippled, and the Grand totals have increased by double the correct subreport subtotal amount.

This might make it a little clearer:


Detail data
Report Footer a: detail data totals
Report Footer b: Subreport data and subreport data totals displayed (trippled during export)
Report footer c: Grand total of detail data and subreport data (increased by 2x the correct subtotal amt during export)


Any ideas?

-Pete

 

[synapsevampire]

Hmm, that does sound odd.

Try applying the service pack:

http://support.businessobjects.com/downloads/updates/service_packs/crystal_reports.asp

-k

 

[pdankert]

I tried the service pack and that didn't work. Any other suggestions?

 

[pdankert]

I have some additional info that could help. This same problem does not occur when exported to a pdf document. It does occur with all versions of excel and even when I send it to a word document from Crystal. Any thoughts?

 

[synapsevampire]

Sounds like an export DLL concern to me.

Here's a reference that might help:

http://support.businessobjects.com/library/kbase/articles/c2012924.asp

-k

 

[pdankert]

That sounds exactly like my problem, thanks a lot.