Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shared variable?

Status
Not open for further replies.

ekta22

IS-IT--Management
May 3, 2004
359
US
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
 
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
 
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?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top