Chainging Dynamic connection at runtime

[rb2005]

Hi,

I have one query. All my reports are using Business View. I have created busies view using dynamic connection. Now when I published the report I have set the connectivity parameters. Most of the reports are scheduled reports and external user can view latest instance/history only. Let say for some reason the scheduled reports fails due to database, is there any way I can set the priority on dynamic connection ....if the reports fails to get data from source one then the report should pick source 2. In other words I want a conditional change of business view dynamic connection at runtime to run all reports.

I am using CE 10.

Thanks,
RB

 

[synapsevampire]

You might do this by writing code, but I don't think that there's anything built in to allow for this.

You could also schedule a second report to go against the other datasource so that there is a contingency.

-k