CODEWITHSUNDEEP
sql-serverreporting-servicesreportreportbuilder3.0report-builder2.0
Radu N.
Radu N.

Reputation: 23

How to generate an automatic/dynamic name for a report in SQL Server Report Builder?

I'm relatively new to SQL Server Report Builder and I'm curious if there is any way I can generate a dynamic/automatic name for a report.

For example my report name is "Order Status" and I want it to be like "Order Status 08.03.2015" where "08.03.2016" is the dynamic part. Since this report will be generated everyday I'm wondering if there is a way I can insert some sort of parameter to get me the date + the report name.

Thank you!

Upvotes: 1

Views: 1663

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

Yes, you can do that.

Create a textbox in your report and set the following expression:

="Order Status " & Format(Today(),"dd.MM.yyyy")

Today() function returns the date when report runs. If you run the report today it will show the today date.

It will show:

Order Status 08.03.2016

Let me know if this helps.

Upvotes: 1

Related Questions