Problems passing data from subreport

[PQTIII]

I have the subreport in the group header on the main. It runs find, but will not pass the results back. It is the total of working shifts for a certain group.

In the sub report, I have the following (in report footer:

WhilePrintingRecords;
Shared NumberVar Totalshifts := DistinctCount ({930_OEE.eqmt})

In the main report ( in details):

WhilePrintingRecords;
Shared NumberVar TotalShifts

I want to use this passed number for a calc in details, but it comes back a 0 and the sub report says 28.

Any suggestions??

Thanks Paul

 

[lbass]

Are you sure that you have placed the shared variable formula in the subreport report footer or are you displaying the inserted distinctcount? If the formula is not placed on the subreport, it will not be shared.

-LB

 

[scottostanek]

You are experiencing some form of corruption in the subreport call. Export the subreport (save to file). Delete it from the mainreport, save and run, then reimport it again.

The code you show here worked fine for me in entirety.

Scotto the Unwise

 

[Madawc]

Values returned from a subreport are only available in the next section. Have you allowed for this?

Madawc Williams (East Anglia, UK)