It seems that Crystal can not do the sum() functionality for the field which is from subreport.

 

In the primary report, I have many rows with RSN number. For each RSN number, I got the a total fee for each RSN number. These total fee are showing on each row of main report. At the bottom of primary report, I need to get Grand Total fee from all RSN number. This grand total fee should be sum of the data obtaining from subreport.

 

However Crystal report only allows me to choose the field in the field list of Primary report. The subreport is not the field in the list, I can not add those fee value to show in the primary report.

 

Maybe I have to create database function to get the first fee for each row, then, get sum in primary report.

 

Any idea to get those done?

 

Jean

 

Hello;

 

Thanks for your help.

 

 

 

To make it simple, I tried to create a shared variable for passing data from subreport to main report

 

1. In subreport, create formula called subformula, the shared valiable = grand total

 

WhilePrintingRecords;
Shared CurrencyVar myTotal :=Sum ({Command.SUM(AB.FEEAMOUNT)})

 

2. In main report, created a formula called mainformula

WhilePrintingRecords;
Shared CurrencyVar myTotal;
myTotal

 

3. I put this mainformula on the main report underneath of subreport. I got the total fee from last row , not grand total fee.

 

What went wrong? Please help.

 

Jean