none
Dynamic Subscription

    Question

  • 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.



    --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 




    • Edited by Lenoj Wednesday, September 11, 2013 2:09 AM edit
    Wednesday, September 11, 2013 2:03 AM

Answers

All replies

  • Upon checking the subscription, i got this message "9/11/2013 2:22 PM Process:0 Processed of 8 Total;0 Errors.

    Kindly please help me to identify why my subscription did not work. thanks.

    Btw, herewith the screen shot of my subscription (steps)

    Wednesday, September 11, 2013 6:28 AM
  • Can you maybe get a more detailed error message from SQL Server Agent job that runs the data driven subscription?

    Regards, Dean Savović

    Wednesday, September 11, 2013 8:28 AM
  • Thank for the reply.

    actually there is no error message display. this is the message i got from this report. "9/11/2013 2:22 PM Process:0 Processed of 8. i have 6 parameter declare in my report but the 2 parameter  default value does not display. how come this parameter has no value which in my report upon running the parameter has a value. 

    Just try a report without parameter and it's working. the 8 report filename that i made was successfully save to folder that i've setup.

    Btw, do i need to inlude in my query these parameters

    The report takes the following
    parameters:
    FromDate, ToDate, FromTime, ToTime,
    OrderMonth, WrkCtrId, timezoneOffset

    This is my query in Step 3

    Select processby as Reportfilename from temptable where processbby<>'NULL'

    Reportfilename

    -------------------

    Dashboard-1

    Dashboard-2 up to 8


    • Edited by Lenoj Thursday, September 12, 2013 1:25 AM add image
    Thursday, September 12, 2013 12:24 AM
  • Your parameters are just returning 0 records for data drive subscription result set.

    If you are not sure what your data drive subscription query is try catching it with SQL Profiler trace and then debug.


    Regards, Dean Savović

    Thursday, September 12, 2013 9:15 AM
  • Thanks for your reply.  it's working already.
    Friday, September 13, 2013 12:47 AM