Post reply

Error in some report using SSRS Data Driven Subscription

  • July 19, 2012 at 5:06 am

    #264111

    Hi,

    I have created a report in SSRS 2008.I had called a Stored procedure for that report.

    Then I had subscribed that report using Data Driven Subcription.

    For that I had created a table in Sql for storing parameters,which contains 14 parameters for the same report.

    Then I had scheduled it at particular time.

    But Only 4 out of 14 files are generated in Shared Folder.

    and for others it getting error.

    I am unable to identify this issue.

    Please Help me regarding this issue.

    Thanks in advance.

  • July 19, 2012 at 5:50 am

    #1514769

    what is the error?

  • July 19, 2012 at 5:55 am

    #1514771

    I have not actually seen error,

    but following status is shown,

    Done: 13 processed of 13 total; 9 errors.

    For the 13 files,4 files are created successfully,and for 9 are with errors.

    If there is error then,for all files error should come.

    but few files are generated.

    this I am not able to understand.

  • July 19, 2012 at 6:00 am

    #1514775

    error in the parameters used to drive the report, error in the data, error running the report, error creating the file, permission errors?

    can you run the report manually for all possible paramater combinations ok?

    without a detailed error message it could be just about anything.

  • July 19, 2012 at 6:08 am

    #1514780

    Yes I spooled all the reports individually with all the 13 Parameters, I am able to do it without any errors.

    Thats why i am in big confusion.

    I have a doubt ,means wanted to know,

    how SSRS Processes the report,means whether for every parameter excution it goes to Sql Server for processing,

    or for 13 parameter execution as whole request is send to Sql Server for processing.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply