My sub report is grouped on “Supervisor_id” and then “Part”.

There are 3 different parts. Each part has a different page footer to display. Page Footer isn’t displayed in sub report.

I need to pass the part number to the main report in order to display the footer conditionally in main report.

I placed a formula on detail section of sub report:

shared numbervar v_footer1;

shared numbervar v_footer2;

shared numbervar v_footer3;

 

if {SP_CF17_CPS_UNIT.PART} = 1

then v_footer1 := 1

else if {SP_CF17_CPS_UNIT.PART} = 2

     then v_footer2 := 2

     else if {SP_CF17_CPS_UNIT.PART} = 3

          then v_footer3 := 3

 

Also placed formula on Group4_footer:

WhilePrintingRecords;

shared numbervar v_footer;

 

I suppressed report footer and any other section following Group4_footer.

 

In main report:

Where should I place the sub report so that v_footer value is available for each part to page footer section of main report. Also where to place reset formula to reset v_footer if needed.

 

Would very much appreciate any help, any clue.

Thanks

 

Main report is not connected to any data set. It only contains the sub report and displays the footer.

I needed main report because to bind variables in sub report.

Thanks. Any help would be greatly appreciated. I am just stuck in this report.