"Norman Yuan" wrote:

> Just a though for you to try:
>
> Do not use either report header, nor page header.
>
> Add a list, place a text box inside the list at top as title text, place a
> subreport inside the list, directly below the title text box. rigth-click
> the list and then select "Properties", make sure "Insert a page break after
> this list" is checked. You do this with all subreports except for the last
> one. You can also set the title text box' Visibility "Hidden" to true if the
> dataset of the subreport has count=0.
>
>
>
> "Natasha" <Natasha@discussions.microsoft.com> wrote in message
> news:D80C5DE3-EBDB-4A0B-BA89-A577C7BAF7B7@microsoft.com...
> >I have a problem with setting titles in the REPORT (not Page) header of the
> > MRS report.
> > The report is to be used/exported in Excel.
> > For that reason, the ONLY way I found to be able to get titles to repeat
> > on
> > every page is if I make them part of the REPORT header.
> >
> > (This report will be used in Excel, and when printing it supposed to show
> > titles on every page (as one section-supreport can be on 50pages…so it
> > should
> > say on every page what it is – show title))
> >
> > Using page header doesnt work, or setting titles on each subreport does
> > not
> > work either.
> >
> > Here is my problem:
> > I have a main report, containing 3 subreports. On the main report I want
> > to
> > add report header containing title, which supposed to be dynamic, i.e.
> > title
> > will change depending on the subreport.
> > E.g.
> > Main report contains these subreports
> > - subreport1 supposed to have title ‘ Summary’
> > - subreport2 supposed to have title ‘ Details’
> > - subreports supposed to have title ‘ Conclusion’
> >
> > Each of the subreport can have one to many pages, as this report is to be
> > run monthly and depending on the amount of data, it can take 1 to many
> > pages.
> > So, how can I control what the title should be….As I mentioned before, due
> > to NOT knowing how many pages each of these subreport take, I cannot just
> > hardcode something like this:
> > IIF (Globals!PageNumber >=1 AND Globals!PageNumber <= 3),
> > “Summary”,
> > IIF (Globals!PageNumber >3 AND Globals!PageNumber < 5),
> > “Details”, “Conclusion”)
> >
> > Please help!
> > Thank you in advance!
>