You need to create a new formula to reset the value of the variable and place it in the group header:

I have been struggling to bring the correct value via shared variable in my main report and would appreciate some help.

The main report has no data but one sub report.

The sub report has 3 groups: county, supervisor, Part
Part is the 3rd group.
Part has value of 1,2 and 3.

I need to pass the part.value to the main report's page footer (since sub report has no page footer.)
There is a different page footer for each part.

I created a formula and placed in on detail section of subreport:

WhilePrintingRecords;
shared numbervar v_footer;
v_footer := {SP_CF17_CPS_UNIT.PART}

I created another formula and placed on Group4_Footer section

WhilePrintingRecords;
shared numbervar v_footer;

When I display the sub report itself, there is correct value displaying in its footer section but when placed in main report, not getting correct part value in main report - page footer.

Placed sub report in main report's Report_Footer section (also tried in detail section since the value is needed to the page footer).
A formula placed on page footer-A section:
WhilePrintingRecords;
shared numbervar v_footer;

I am resetting value to zero of this variable in page_header section (tried in report header section also):
shared numbervar v_footer := 0;

problem is: getting value 0 when needs to be 1, getting 1 where needs to be 2....

Any help would be greatly appreciated.
I probably didn't do good job explaining...please ask for any clarification..
thanks for any help.






Edited by guptaa - 14 Mar 2013 at 2:40pm

my apologies...newbie here.
Please find my question posted.
Your help would be greatly appreciated.

thanks