pass value from sub to main report's page footer

building reports crystal reports
1

Hi All,
Scenario:
using crystal report 2008
I have a sub report that pushes its contents to the next page if records are more than 3. I have placed that sub report in the main report’s Group Header 1c.
I have a part of the report that I want to be able to display on the first page of the report even if the records are more than 3 and the sub report is pushing contents to the next page. I have accomplished this by placing that part of the report in the Main Report’s Page Footer.

Issue:
Now, i want to pass value from sub report to main report for which I m using shared variable in the sub report, but when i use the same shared variable in the main report’s Page Footer, i m not getting the value. (Note: I want to use the shared variable value in Main Report’s Page Footer because that is where I have the part of the report which I want to display on the first page of the report).

Let’s say i move the part of the report (which i want to display on the first page) to the Main report’s Group Footer and use the shared variable here, i get the value, but the Main Report’s Group Footer is pushed to the next page if records are more than 3 and I want this part of the report to stay on the first page and not go to the next page :hb:

please let me know if you have any suggestions

Thank you.

bobjprogenergy (BOB member since 2012-05-30)

2

I did not understand the problem correctly but as per my assumption the placement of your shared variable may be wrong.

One important point: When you are trying to get one value from subreport to main report using shared variable, The shared variable which you will use in the main report should be placed in any sections but next to your subreport section.

Ex: Your sub report is placed in Group Header1 in main report, your shared variable will not get data if it is placed in RH,PH and Details. Why because after your subreport is processed only your shared variable gets data. So in this case, your shared variable processes first and then sub report.

You have to place your shared variable in any section after Group Header1 to make it work. Plan accordingly.

Hope this helps.

anil.ganga1 :us: (BOB member since 2007-07-04)