November 10, 2009 at 1:43 pm
This is probably a really easy question.
I'm a DBA creating a functional report for our DBA Team and I need to create a subscription that will pass value to the report and have it delivered to our team every Wednesday morning.
The Parameters that need to be passed to my report are:
Implementer
Status
Start Date
End Date
Implementer and Status are static values, only the dates that are going to change on weekly basis.
I wish I could pass GETDATE() to the date parameters but I can't find a way of doing it.
Should I create a regular subscription or a data driven subscription?
Can you guys help?
November 10, 2009 at 2:07 pm
In BIDS - when designing the report, setup the parameters with default values. The default values you will use would be something like:
=DateAdd(DateInterval.Day, -1, Today())
Figure out what defaults you want for each parameter - and set them up. Once this has been done, you then publish the report to the report server. Now, when you try to create a subscription you will have the option for each parameter to use the default value.
The other option is to figure out the default value in the code. Then, you allow null values for the parameters and check to see if the parameter is null. If it is null, then you use your default value.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply