May 28, 2013 at 8:34 am
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.
May 28, 2013 at 8:43 am
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
May 28, 2013 at 8:55 am
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.
May 31, 2013 at 7:31 am
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.
May 31, 2013 at 8:20 am
No worries, glad you got it sorted.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply