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