Subreport calculation issue (1 Viewer)

Pauly D

New member
Local time
Today, 07:09
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
Staff member
Local time
Today, 06:09
Joined
Oct 29, 2018
Messages
21,357
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
Local time
Today, 07:09
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
Staff member
Local time
Today, 06:09
Joined
Oct 29, 2018
Messages
21,357
=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

Top Bottom