Shared variable?

[ekta22]

Hi,

I created a shared variable on my subreport whose value I want to pass on my main report. I have groupings on Region, Sector and Area on my subreport. The shared variable would store the values of all the areas found in a particular region and sector and display it on the main report. I want to display these areas on the report as column headings. Right now if there are 3 areas under a region and sector it displays only the first area.

Here is the formula for my shared variable on my subreport -

WhilePrintingRecords;
Shared StringVar strArea;
strArea := {Sub.AREA}

The formula on my main report is as follows -

WhilePrintingRecords;
Shared StringVar strArea;
"Area: " + strArea + " "

Thanks

 

[kskid]

Where is the subreport located on the main report? It must be located in a section PRIOR to where the shared variable is used in the main report.

If your column headings are in Group 1 header, then you have to insert another section 1. Place the subreport in group header 1A and then display the shared variable in group header 1B

-lw

 

[ekta22]

Subreport is in the page header and the formula for shared variable is in the sector group. I do see the area but it shows me only the first area. FOr example there 3 areas in a particular region and sector - Area1, Area2, Area3. I want these to be display in the Sector group header as follows

Area: Area1 Area2 Area3

But right now it shows me only the first area
Area: Area1.

How should I concatenate the other 2 area to this first one?