Trying to use formula field in subreport to be displayed in Main Report

[Former Member]

Hi All,

I am trying to use a formula field in a subreport to be displayed in the Main Report so that the calculation that the subreport is doing doesn't disturb the main report. I just want the subreport field data to appear in the main report. Is this possible?

Thank you in advance.

[Former Member · Accepted solution]

Search the notes (kbase) for: c2007600

The title of the notes is: How to Share Subreport Data with Main Report

Use it and keep in mind that you can only use that value in a section AFTER the section in which the subreport is located.

[Former Member · Accepted solution]

So if I place the subreport in the report header, and then the variable in the group footer, that should replicate the group footers from the subreport to main?

[Former Member · Accepted solution]

If you place the subreport in the REPORT header it will only send the shared variable info ONE time (one value) to the main report. Meaning that is the same value that, if used in the group footers, will appear in each.

[Former Member]

So in my subreport I have this formula:

whileprintingrecords;

shared numbervar durtot;

durtot:={@Dead Aux}+durtot;

When I add this formula in my sybreport Group Footer I get data.

In my Main report, I have created a formula with the following:

shared numbervar durtot;

When I add this formula in my Main Group Footer, I get zero's.

[Former Member]

Ensure that the subreport is physically placed in a section which gets processed before the section in which you are placing the formula(in the main report).

Typically the sequence for processing of groups is GH#1,GH#2,GH#3 ....and GF#1,GF#2,GF#3 ...

Thanks

[Former Member]

Hi It is possible by using a shared variable and calling that shared variable in the main report.

Regards,

Vinay