Solved
Shared Variable from Subreport to Main report
Posted on 2008-10-15
I have a report with about 5 details sections which are for the most part subreports. I have created a subreport which is retreiving survey information for incidents. The survey report displays the results of the survey in a summarized format as there are multiple questions. I created a shared variable in the subreport as follows:
WhilePrintingRecords;
Shared numberVar TotalYes1 := {@Sum Comment1}
I then created a formula in the main report with the following details
WhilePrintingRecords;
Shared NumberVar TotalYes1;
TotalYes1
I placed this formula in a details section that I added below the details section that has the subreport. The problem I am getting is that the shared variable (likely the first one evaluated) is appearing in the details section of the report however it is appearing for every detail record that appears even if there are no subreport results?
Any help is appreciated.