Conditional DataSet Processing
Can we conditionally process dataset ? I have different data regions in a report. For example, I have dataregion1 and dataregion2 which depends on dataset1 and dataset2. User wants a parameter which can be used to see only dataregion1 or dataregion2 or both. I can use the visibility option to do that. But performance degrades, as it needs to process both of the datasets even when the user doesnt want to see both of the dataregions. Is there any way I can specify that when a parameter is set, only a certain dataset will process and not the both ? I am using 2008R2. Any suggestion would be highly appreciated. Thanks,
October 19th, 2010 11:56pm

there is no direct way to do this however you can manipulate your datasets to execute a less intensive query in a number of ways one of which is to convert your queries into an expression and then use an iff statement so a control parameter can decide if a "fast" or "slow" query is used: =iif(parameters!control.value = true, *do fast query*, *do slow query*)
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 12:20am

Hi ramrosql, For the report processing performance, i would recommand you enable the "Go to report" Action. On the main report, there will be 2 links and their visiblities can be determined by the report parameter. If the users want to see the result, they need to click one link. This is best practice if considering report processing performance in your case. thanks, Jerry
October 21st, 2010 8:45am

Thanks!! I have multivalued parameters in all of the reports. If I pass the parameters to the drill through reports then I cannot change the parameter values in there, so in that case user again need to open the main report and select the parameters if they need to change the parameters from the drill through reports.
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 7:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics