Reference main report on a subreport

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gitche Gumee - 13 May 2008 02:54 GMT

I've read everything here that I think might apply, but still can't make this
work.

I have a subreport in a section footer. In the subreport I have a text box
that I want to set to the value of a control in the section header on the
main report. Using Control Source "=Reports!MainReport.textbox" gives me a
#Name? error. Using Control Source "=textbox" gives me a value but it repeats
the same value for every record in the subreport instead of the actual value
of the textbox in the main report header.

What do I have to do?

Reply to this Message

NetworkTrade - 13 May 2008 15:24 GMT

try
=Reports!MainReport.Report!textbox

Signature

NTC

> I've read everything here that I think might apply, but still can't make this
> work.
[quoted text clipped - 7 lines]
>
> What do I have to do?

Reply to this Message

Gitche Gumee - 13 May 2008 23:00 GMT

Perhaps I'm referencing correctly but I'm not getting the data I want.

The setup is:

Dept Header
Project Header
Detail
Project Footer
Dept Footer

I want a summary in the Dept Footer that will list all the projects in the
dept and show a specific counter from the detail section of each project.

So the summary should be:
Project A Counter A
Project B Counter B
Project C Counter C

What I'm getting is:
Project A Counter C
Project B Counter C
Project C Counter C

I've tried putting this counter in the Project header as well. I get the
same incorrect results.

> try
> =Reports!MainReport.Report!textbox
[quoted text clipped - 10 lines]
> >
> > What do I have to do?

Reply to this Message

Rate this thread: