Subreport in Details and in Group Footer

[Cores]

CRXI
There is a subreport in the report. The subreport contains two fields - project_id as a link to the main report and allocate_amt in Details section. But I am using Group Footer to display the last record of the report always with the summaries. So I need to put another subreport with the same data. The performance of the report is very bad (more than 50 minutes). Please give me idea how to avoid at least the second subreport.

Thank very much.

 

[lbass]

Assuming you are looking for a sum of the sub's allocate_amt, you can set up a shared variable in the subreport like this and place it in the sub's detail section:

whileprintingrecords;
shared numbervar amt := {table.allocate_amt};

Then follow the steps in thread767-1662227.

-LB

 

[Cores]

Thank you lbass.