Monday, March 12, 2012

How to add parameter for file name for subscription

Hi,
I working on Report Delivery by "Report Server File Share".
I like to add parameters into the name.
for example,
report name is "order". there are paremeter name "startdate" and "endate".
I'd like to change the filename "order_startdate_12_1_06_enddate_12_2_06"
something like that.
Is there any way to attach parameters to FileName?
Thanks
KenHi Ken,
I am not sure if you can add a parameter to change the file name at
runtime after you have created the subscription.
I can suggest Data driven subscriptions where you can execute a query
which will return all these parameters to you from the data base. You
can specify a name for the report based on your requirements and this
column can be mapped to the FileName in the subscription which will
create a file witht that name.
If you dont know what a data driven subscription is this will get you
started.
http://msdn2.microsoft.com/en-us/library/ms156012.aspx
Hope this helps,
Virat
Ken wrote:
> Hi,
> I working on Report Delivery by "Report Server File Share".
> I like to add parameters into the name.
> for example,
> report name is "order". there are paremeter name "startdate" and "endate".
> I'd like to change the filename "order_startdate_12_1_06_enddate_12_2_06"
> something like that.
> Is there any way to attach parameters to FileName?
> Thanks
> Ken

No comments:

Post a Comment