Geek Answers Handbook

SSRS Report Subscription Options (Date Values)

I want to set up a report subscription in SSRS 2008 R2, where the client user can set the date parameter no matter what the user wants. I read some tips on using the = Today () parameter in parameters, but this syntax does not work for me. Does anyone know if it is possible to set a date from a date to "Today -30 days" and mine today is "today"? What is the syntax used in the subscription options?

Settings: enter image description here

Mistake: enter image description here

+8
date parameters reporting-services subscription
source share
1 answer

As described in the above link provided by praveen, the solution turned into creating two parameters in the report containing integer values ​​with a label that describes the periods that I would like to use in my subscription. These options can be easily set to Hidden, so they are not displayed when you want to run the report manually. I also decided to set the default value for both parameters to 1, which is my value for Today (). This means that my report will start with the date being selected today in both visible date options.

In the two date parameters that are shown in the report, you can set a default value for the switch of values ​​that you can select in the hidden date parameters. Now you can set up a subscription that will work, and looks like this:

enter image description here

+7
source share

More articles:


All Articles