How to Display Header information in SSRS Report

Description:-

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 

Output : 

From Date : 01\01\2017

To Date : 01\01\2017

Report Run Date : 01\01\012017 12:00:00 PM

Page 1 of 2 

Note: My recommendation please set Text alignment to Right so you will batter format in Preview.

Author : Umesh Patel

Related Posts