Thursday, September 7, 2017

How to Display Header information in SSRS Report

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

D365 Extensions: Extend the validateField Method on a Table

In this post I will going to show you, how to extend the validateField method on a table. As example I used the SalesLine, where I will ...