Referring data fields from sub report in main report

[Former Member]

Friends,

I'm facing a situation here wherein i have to refer data fields from Sub report to main report. Below is the detailed scenario

Main Report :

Currency 1        Subreport_A. Calc_Amount ( summary field from A subreport)

Currency 1        Subreport_B. Calc_Amount ( summary field from A subreport)

                        Difference ( A-B )

Currency 2        Subreport_A. Calc_Amount ( summary field from A subreport)

Currency 2        Subreport_B. Calc_Amount ( summary field from A subreport)

                        Difference ( A-B )

Currency 3        Subreport_A. Calc_Amount ( summary field from A subreport)

Currency 3        Subreport_B. Calc_Amount ( summary field from A subreport)

                        Difference ( A-B )

Subreport A:

Currency 1          Calc Amount   

Currency 2          Calc Amount

Currency 3          Calc Amount

Subreport B:

Currency 1          Calc Amount   

Currency 2          Calc Amount

Currency 3          Calc Amount

Please let me know how can i make this work?

I tried using shared variables , but they ended up carrying only one single value ( Not the whole data field).

Thanks in Advance,

Bharath

[abhilash_kumar]

Hi Bharath,

Shared variables can carry only value at at time - not the entire column values.

Could you please provide more details on the design of the report and what you're trying to achieve?

-Abhilash

[Former Member]

Abhilash,

Above is the detailed design of the report. Can be briefed as below.

Section 1 :

               Main page

Section 2:

               Sub report A

Section 3:

               Sub report B

Main page will be displaying the summary , then the sub reports will display details.

[abhilash_kumar]

Do you have a screenshot of the Design page of the report please?

-Abhilash

[Former Member]

Nope Abhilash,

Just got a requirement. Apart from the main page ( referring sub report's data ) , its quite basic.

[former_member197449]

Hi, Did you try Opendocument() function ? This should help you. Can better suggest if you can provide a screen shot/mock of the report Regards, Venu.K