Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-04-29 : 10:55:17
|
| Hi Guys,Lets say I am having two text boxes in my page header side by side something like this:first text box contains info - My First Reportsecond text box contains info - (contiued page )Now i want my report in such a way tht , in the first page i only want to display the first text box i.e. My First Reportand in the rest of the pages i want to display the two text boxes.any clues how to do it???i know tht there is a option page header/page footer - true/false where we can specify tht header or footer to be printed on first page or not...But here i want only part(only one text box) of the header to be printed on first page and both parts(both text boxes) to be printed on rest of the pages.Is there any option for this as well???Thanks,Raaj. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-29 : 13:34:58
|
| i think you can achieve this using a single textbox by writing an expression like=IIF(Globals.pagenumber=1,"info - My First Report","info - (continued page)") |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-04-29 : 22:16:26
|
| Hey Visakh,Thanks for ur code....i got with it but did some modifications to generate the continued page number automatically in this way...=IIF(Globals.pagenumber=1," My First Report","My First Report(continued page "& IIF(Globals!PageNumber<>1,Globals!PageNumber,nothing) & " )")thanks once again,Raaj.... |
|
|
|
|
|
|
how to skip part of page header from the first pg: