Report header and expression help.
If the last section in my report goes to the next page i need the header to repeat how do i do that and i also get an error on the last page. See below for the expression.
="Printed On " & FormatDateTime(Globals!ExecutionTime, DateFormat.ShortDate) & " " & WeekDayName(ReportItems!Textbox74.Value) & " " &
Right(Globals!ExecutionTime, 11)
In the report viewer my report comes out to 6 pages.. when i export it to PDF file i get an extra page 7. And on page page i get "Erro" in my Printed on textbox of my report footer.
Please help.FM
February 14th, 2011 3:39pm
Hi,
if you want to repeat Table Header on each page then select table right click go to properties and check the text box repeat header in all the pages.
For the error you have to check the expression whether it is returning the value or not
Please check this in a seperate text box (WeekDayName(ReportItems!Textbox74.Value)) whether it is returning any value or not
Solution:- I think you have to convert first this expression into datetime then you can you can use weekdayName function for finding name
Thanks,
Shobhit
Please mark as answer if this post helps
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 10:46pm
Hi,
if you want to repeat Table Header on each page then select table right click go to properties and check the text box repeat header in all the pages.
For the error you have to check the expression whether it is returning the value or not
Please check this in a seperate text box (WeekDayName(ReportItems!Textbox74.Value)) whether it is returning any value or not
Solution:- I think you have to convert first this expression into datetime then you can you can use weekdayName function for finding name
Thanks,
Shobhit
Please mark as answer if this post helps
February 18th, 2011 10:46pm