weird PROBLEM in EXPORT to EXCEL

[trichie]

Hi! I encountered a very weird problem while exporting to excel. I'm using CR 8.5 and I'm designing my report in VB 6.0.

My report has 1 subreport, which of course can be displayed a number of times depending on the number of entries retrieved from the database. In the subreport, I have a couple of summaries (sums), of the total number amount ordered and the total price. What I needed to do was get the grand total from these summaries in the subreports and show them in the main screen, so I used shared variables. This works great. When I preview the report, I get the correct grand totals.

My problem is when I export to excel, I get the wrong totals. To be more specific, I get a value that is double the correct value (although the totals for each subreport remains the same).

I already installed the fixes available (my excel export DLL is dated 8/8/03).

Would you know what's causing this?

Thanks!

 

[debunky]

I have this same problem, did you get any answers yet????

 

[mbarron]

Exporting of shared varibsble to Excel in 8.5 is according to the Crystal Decisions site is a "...supported feature with certain conditional limitations" I couldn't find what the limitations were though.

go here to see limitations for exports in 8.5:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr85_exportlimitations.zip.asp

Mike