Accessing Information From Sub-Reports

[Former Member]

I have a report with the following layout:

Details a Field from SQL Command

Details b Field from SQL Command

Details c Field from SQL Command

Details d Field from SQL Command

Details e SubReport A

Report Footer b SubReport B

How do I add the total number of items in SubReport B + the total number of records displayed in Details a-d and display that value in the Page Footer?

[Former Member]

Hi Ray

Create a formula field to calculate total number of records in the details sections. Store this value in a shared variable.

Now in subreport B, create a formula field with same name and declare the variable with same name.

Place this formula field in the subreport section.

For more help please refer to crystal reports help.

Hope this helps!!!

Regards

Sourashree