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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dynamic Subscription
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

478 Posts

Posted - 09/10/2013 :  23:36:52  Show Profile  Reply with Quote

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.


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

--Use as Windows credentials when connecting to the data source
--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

-PublicData\Common Folder\Monitor DASHBOARD

Constraint Violating Yak Guru

478 Posts

Posted - 09/11/2013 :  23:33:51  Show Profile  Reply with Quote
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.
Go to Top of Page

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 09/12/2013 :  16:35:39  Show Profile  Reply with Quote
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
Go to Top of Page

Constraint Violating Yak Guru

478 Posts

Posted - 09/12/2013 :  20:39:53  Show Profile  Reply with Quote
THanks Visakh for your reply. It's already working.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000