In my one of project I required like below information in header Fromdate, Todate, Report run date and Page no out of total pages.
Copy paste below code and change your fields and Changes in Textbox Properties like HTML formatting.
For that Select your Textbox inside Expression and right click on it and go to Textbox property ON General Tab There are to Radio button one for Text and another for HTML Content Select HTML text. After that run your report and you will get.
="From Date : " & Format(Fields!FromDate.Value, "dd/MM/yyyy") & "<br>" &
"To Date : " & Format(Fields!ToDate.Value, "dd/MM/yyyy") & "<br>" &
"Report Run Date : " & FORMAT(Now(),"dd/MM/yyyy hh:mm:ss tt") & "<br>" &
"Page "&Globals!PageNumber &" of "&Globals!TotalPages
No comments:
Post a Comment