How to display Report Generating user name at the SSRS Report Footer

Displaying Report Generating the Date time and user name without Domain or System name:


1- Go to Design mode and Create footer in SSRS report
2- From The toolbox add one text Box in footer


3-Right click on text box and select expression


select expression

4- In Expression add below syntax to display Date time and user name who generating the report and click on OK

="Report Generated at "& now() &   " By " & User!UserID.Substring(User!UserID.LastIndexOf("\")+1)

5- Save the report and validate preview , it would show the Date time when report get generated and username who is generating the report in footer like below

Leave a Reply

Your email address will not be published. Required fields are marked *