Post reply

SSRS Data Driven Subscription

  • October 11, 2016 at 8:53 am

    #331205

    Hi all,

    I have a SSRS Data Driven Subscription which sends out email in MHTML (web archive) format.

    When I schedule the report on a shared schedule, I am getting just the Table header of the report with no data in the email, when I check the query it is returning data.

    But, when I schedule the report to run in next 10 minutes it sends out email with data. Is there something wrong with the shared schedule?

    Did anyone come across this issue?

    Can someone help regarding this issue?

    Thank You,

    Naveen

  • October 12, 2016 at 12:32 am

    #1906033

    Is report have any default parameter ?

  • October 12, 2016 at 1:06 pm

    #1906185

    Yes, Report has default parameters which I am getting from from a query. Please check the image.

    https://drive.google.com/a/pscnow.com/file/d/0B1Q0SOyhD8EZMXNqNlN1dkg3REU/view?usp=sharing

  • October 13, 2016 at 6:11 am

    #1906296

    I guess somethink write query parameters to report and after check it

    your subscription report.

    Are they true?

  • October 14, 2016 at 8:42 am

    #1906586

    I am passing parameters from the data drive subscription to the report.

  • October 14, 2016 at 11:40 am

    #1906644

    Is there anything in the Visibility settings for the report's detail rows? Maybe the report is just not showing the detail rows. Another thing to check is the Data Source in the report - make sure it isn't looking at the wrong data.

  • October 14, 2016 at 11:51 am

    #1906647

    There is no change in the visibility setting, i can see the report data in report builder, also email shows data when I manually push the subscription, instead of subscription.

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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