Get Report Page Title from its subreport

O

OceansideDJ

My report displays any one of five different subreports on each page. How can
I get a value from the subreport to display as the page title in the main
report's Page Header?

Thanks,
Mike
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the main report's page header section put a TextBox control with a
ControlSource property like this (for a TextBox TitleControl):

=SubReportControlName!TitleControl

If the TitleControl on the subreport is a Label then use this syntax:

=SubReportControlName!TitleControl.Caption

Of course, substitute your control names for my examples.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBbaqYechKqOuFEgEQJx0ACfRtJiFErQFf2VwEqmtnm/zpVVZ0EAoKJ8
NoikvQ4lIJf0+D8bwMUTbXKa
=kBmd
-----END PGP SIGNATURE-----
 
O

OceansideDJ

Tried that. My problem is that I do not know which of my five subreports is
displayed on the current page, so the subreport name needs to vary. The page
title will be different for each sub.

Can I get the subreport's title value pushed upwards into the main report's
page header, rather than have the main pull the sub's value?

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top