Referencing between Sub-reports.

[michaelh93]

Hi,

In my report I have been able to add the values of the main report with the equivalent values of a subreport (if present) into a combined total using



=Sum([NAMEPLATE kW])+IIf([FEEDER subreport].Report.HasData,Nz([FEEDER subreport].Report.NPkWSUM,0),0)

This works exactly as I want, however in the footer of my report I have another subreport that acts as a summary showing only the combined sum of the values of the components (the calculation shown above) for each STATION and not the entire component list. I had been using =Sum([NAMEPLATE kW]) in the STATION footer of the sub-report and this returns the correct sum of all the values in the list of components (from the main report), but I want it to add the relevant values from the feeder subreport aswell (If applicable).

If I try to directly refence the Textbox contained within the main report (=Reports![Equipment Demand]![Text58]) that computes the above calculation it returns the same value for every STATION in the subreport instead of the value of Text58 for each specific STATION, which is obviously wrong. (The value that is returned is the last isntance of the calculation performed in the main report.

I tried to reference the textbox in the other subreport using =Sum([NAMEPLATE kW])+IIf(Reports![Equipment Demand]![FEEDER subreport].Report.HasData,Nz(Reports![Equipment Demand]![FEEDER subreport].Report.NPkWSUM,0),0) but no luck. It returns the =Sum() correctly but the second term seemingly has no effect. (It turns out hasdata is returning a 0).

Can anyone suggest how I can fix my referencing?

[June7]

Do you want to provide db for analysis? Follow instructions at bottom of my post.

BTW, I deleted thread that duplicated this topic.

[michaelh93]

Do you want to provide db for analysis? Follow instructions at bottom of my post.

BTW, I deleted thread that duplicated this topic.

Hi June, thanks for the reply.

I was going to try one last thing before i sent it off and it worked!

The subreport I was trying to reference has to be in the detail of the report and not the footer. Not sure why but it worked.