I want to show up Todays date
as report generated date
on SSRS report.
How can i do that ?
should I use any variable ?
please help me I'm newbie to SSRS.
For example refer this image:
This question is related to
sql
ssrs-2008
reporting-services
Try this:
=FORMAT(Cdate(today), "dd-MM-yyyy")
or
=FORMAT(Cdate(today), "MM-dd-yyyy")
or
=FORMAT(Cdate(today), "yyyy-MM-dd")
or
=Report Generation Date: " & FORMAT(Cdate(today), "dd-MM-yyyy")
You should format the date in the same format your customer (internal or external) wants to see the date. For example In one of my servers it is running on American date format (MM-dd-yyyy) and on my reports I must ensure the dates displayed are European (yyyy-MM-dd).
You can place a text-box to the report and add an expression with the following value in it:
="Report generation date: " & Format(Globals!ExecutionTime,"dd/MM/yyyy h:mm:ss tt" )
You can also drag and drop "Execution Time" item from Built-in Fields list.
Just simple use
=Format(today(), "dd/MM/yyyy")
will solve your problem.
In the text box that contains the header, you can use an expression to get the date. Try something like
="Report Generation Date: " & Today()
right click in the text box in the layout view. At the bottom of the list you'll see the expression option. There you will be able to enter the code. This option will allow you to avoid adding a second textbox.
to display date and time, try this:
=Format(Now(), "dd/MM/yyyy hh:mm tt")
Source: Stackoverflow.com