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