I have implemented in SSRS 2005 a main report and some drill-down report created as a separate rdl. These reports have a parameter set in order to execute them. I need to organize a schedule stratey. I think to create a table to contain these parameters,
with each record for each valid parameter set. This table could have more one record and so it has to be possible to execute the reports more times. I think to create a schedule for the main report, and one schedule for each drill-down reports. If I have f.e.
ten records in the parameter table, the main and the drill-down report should be executed ten times, isn't it? After the entire elaboration, I think to cancel the parameters record in the parameter table.
Moreover, if any records isn't present in the parameter table any executions shouldn't start and any errors shouldn't be generated.
Any helps to me to organize the right strategy in order to solve this issue, please? Many thanks.
View Complete Post