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 Variables with groups

Status
Not open for further replies.

steder

Technical User
Feb 16, 2003
6
US
Hi
I have a subreport called vendors. this report is grouped by City.
I need to share the total number of devices per group (city)
to my main report.
Here's what I have:
In my subreport:

@ShareCountOfDevicesPerCity
shared numbervar countdevice := Count ({table.Vendor}, {table.CITY})

In Main report:
@SharedDeviceCity
shared numbervar countdevice;
Problem:
When I place the 1st formula of my subreport in the City group it totals correctly, but my main report formula shows ZERO.

When I place the 1st formula of my subreport in the Page Header, it passes the first groups total to the main report,
only.

I have grouped my city in my main report and need to use the shared variable, but as it changes with each group from the sub.
Any Ideas?

Mike



 
preface both formulas with the statement "WhilePrintingRecords;" Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
the formula has no errors, but doesn't seem to do anything.

In sub
@ShareCountOfDevicesPerCity
WhilePrintingRecords; shared numbervar countdevice := Count ({table.Vendor}, {table.CITY})


In Main report:
@SharedDeviceCity
WhilePrintingRecords; shared numbervar countdevicemarket;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top