SS

  • Please help!

    I have an SSRS report with multiple shared data sources pointing to web services. If all the web services are up, then the report works fine. However, if just one of the web services is down, then the report fails with a connection error. Is there any way around this so that if one of the services (data sources) is down, then the report will still run, showing data from the available datasources.

    Thanks.

  • I've not tried this but maybe you could. If you made each dataset its own report then had a master report that had these reports as subreports, then those that can run will run.

    Not sure how the ones that can't might manifest though.

    Thanks,

    Simon



    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • Thanks for the reply Simon.

    That was my origional thought, but we have now set the report so that it is made up of individual reports, relating to the individiual data sources, but this still seems to fail should one of the datasources be unavailable.

  • Thanks for the reply. We've managed to solve the problem now by creating subreports with "embedded" datasets, on the main report (which i think is where you were coming from). Orighionally I believe we tried using shared datasources.

    This then allowed the available report details to be displayed and just show an error for the unavailble reports/sources.

    Many thanks for your help.

  • No worries, glad you got it sorted.



    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

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

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