If I have my header row set to "repeat on new page", is there a way to add
the text "continued" to the header if the data has spilled over to the next
page? I want to distinguish between the first time a group of data appears
and when it is continuing on the next page.
ie. Page 1: January 1, 2004
Page 2: January 1, 2004 continued
January 2, 2004
Page 3: January 2, 2004 continued
Thanks,
MelissaThere's no way to do this given the current architecture of the system.
Content of the report body is calculated first, then pagination is applied
after the fact. So there's no way to have the content of the report body
depend on pagination.
The closest you can get is putting the "continued" part in the page header:
1. Put a hidden column in your table with an expression something like
this:
=iif(Fields!Date.Value=Previous(Fields!Date.Value),Nothing,"X")
2. Put a texbox in the page header with an expression something like this:
=First(ReportItems!DateTextbox.Value) &
iif(First(ReportItems.MarkerTextbox.Value)="X"," continued","")
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Melissa" <a@.a.com> wrote in message
news:eBi9yKZeEHA.3928@.TK2MSFTNGP11.phx.gbl...
> If I have my header row set to "repeat on new page", is there a way to add
> the text "continued" to the header if the data has spilled over to the
next
> page? I want to distinguish between the first time a group of data
appears
> and when it is continuing on the next page.
> ie. Page 1: January 1, 2004
> Page 2: January 1, 2004 continued
> January 2, 2004
> Page 3: January 2, 2004 continued
> Thanks,
> Melissa
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment