Exporting

[elf1]

I am exporting a report to an excel file, and two of the values within the report are accessed via a subreport. Only one of the subreport values is exported to excel. Anyone have an idea on how to resolve this issue?

 

[synapsevampire]

Please post the version of your software.

Try applying the latest service pack:

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

-k

 

[elf1]

We are using Crystal 8.5, and it has the most current service pack (3).

 

[synapsevampire]

You might just return the subreport value to the main report using a shared variable, however 2 subreports seem to work ok here when exporting to Excel.

In the subreport create a shared variable:

whileprintingrecords;
shared numbervar MyValue:= {table.field}

Then after the subreport fires you can use the value in the main report by creating another formula:

whileprintingrecords;
shared numbervar MyValue

-k

 

[elf1]

Thanks for your help so far, this is what I have now as my formula and it is giving me an error:

shared numbervar Hours := Sum of PR_22PerpetChkHistoryHeader.TotalEarningsHours;

 

[synapsevampire]

Then post the error.

The formula looks wrong to me, I think it would be more like:

shared numbervar Hours :=
Sum({PR_22PerpetChkHistoryHeader.TotalEarningsHours});

-k