Subreport calculation issue (1 Viewer)

Pauly D

New member
Joined
Nov 25, 2019
Messages
3
I have a report with a sub report that used the following calculation:

=Round([Reports]![SetOC]![UpStartFreq]+[Spacing]+[CalcBW]+0.499,0)

This works as advertised, but I need to insert that report as a sub report for another report. Calculation no longer works and gives me a #Name? error. I'm sure this is simple, most of the issues that I spend hours on end up being simple.
 

theDBguy

I’m here to help
Joined
Oct 29, 2018
Messages
7,749
Hi Pauly,


Assuming the name of your report is "SetOC" and you're putting it in a report called "MainReport" as a subform, then this part of the expression:


[Reports]![SetOC]![UpStartFreq]


might become like this:


[Reports]![MainReport].[SetOC].Report![UpStartFreq]


Hope it helps...
 

Pauly D

New member
Joined
Nov 25, 2019
Messages
3
=Round([Reports]![MissionOC].[SetOC].[Report]![UpStartFreq]+[Spacing]+[CalcBW]+0.499,0)

That did it, once I pulled my head out and realized that I had to fix the [CalcBW] cell as well. Thank you.
 

theDBguy

I’m here to help
Joined
Oct 29, 2018
Messages
7,749
=Round([Reports]![MissionOC].[SetOC].[Report]![UpStartFreq]+[Spacing]+[CalcBW]+0.499,0)

That did it, once I pulled my head out and realized that I had to fix the [CalcBW] cell as well. Thank you.
Hi. You're welcome. Glad to hear you got it sorted out. Good luck with your project.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom