Dynamic Subscription - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Dynamic Subscription

Author

Topic

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-09-10 : 23:36:52

Hi,

I have an RDL report that run every 3
minutes, the output is formatted in word file.
This file is used for my Dashboard which display in 8 LCD monitor. Right now i created 8 different subscription
with different filename but the result is the same. upon searching
from the web i notice that my existing requirements can be done in dynamics subscription.

my requirements is to create 8 reports with different filename(same result/data)

My question is how could i achieve this in dynamics subscription. Your reply is very much appreciated. Thanks.

Btw, the folder that i'm stored the file is a common folder no username/password required.

--Step-1 

--Description: My Dashboard Subscription
 
--Specify how recipients are notified: Window File Share
 
--Specify for this subscription only
 

--Step-2
 
--Use as Windows credentials when connecting to the data source
 
--Step-3
 
--Specify a command or query that returns a list of recipients and optionally
 
-- returns fields used to vary delivery settings and report parameter values for each recipient:
 
-- What should i do in this portion
 
--This is the SSRS report file name as file source of my Dashboard(Powerpoint)
 
Daily Shipment-1 --for Monitor display 1 
Daily Shipment-2 --for Monitor display 2
Daily Shipment-3 --for Monitor display 3
Daily Shipment-4 --for Monitor display 4
Daily Shipment-5 --for Monitor display 5
Daily Shipment-6 --for Monitor display 6
Daily Shipment-7 --for Monitor display 7
Daily Shipment-8 --for Monitor display 8
 
--This is the path that i would like to store/save the file name
 

\\abcdfp701\OPD
 
-PublicData\Common Folder\Monitor DASHBOARD

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-09-11 : 23:33:51

I have an SSRS report with 6 parameter with default value namely
Fromdate, todate, fromtime, totime, ordermonth, workctrid and timezonoffset.
out of the 7 parameter 2 has no default value with it display.

Why these 2 parameter has no default value?
upon checking from the step 5 of dynamics subscription
the Todate and ordermonth has no default value while the other has a value.
Kindly please help me what is the problem with my parameter.Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-09-12 : 16:35:39

can you post how you have set default values for those fields? do you've table field from which they get the values?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-09-12 : 20:39:53

THanks Visakh for your reply. It's already working.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources