value from subreport to be used in main

  • Thread starter Thread starter W
  • Start date Start date
W

W

Hi all,

I have a report with the following sections in the main report :

- detail
- CustomerFooter

In the detail section I have a field (UP) which contains the unit price
And the following subreports (based on subqueries):

- OT1
- OT3

The subreports are in the CustomerFooter section.

Subreport OT3 has a textbox which gives a value a1 (integer)

I want to be able to have in my CustomerFooter section the product of UP * a1.

This, however, gives the error : #Name?

I can have the value of UP, but the value of a1 seems to be unknown, even if
I use the syntax :
=[Reports]![OT3]![a1].

Anyone a clue ?

Many thanks in advance,

W
 
I had to use the following syntax :

[OT1].[Report]![a1]

That resolved the problem.

Thanks to everyone having spent time on my question.

W
 
Back
Top