How to switch data sources based on user input.

Hi

Is it possible to switch data sources based on user input?
I have a grid where each element has a drill-though to a different
sub-report. Let's say one of these elements has a drill-through to
~/path/full/myreport.rptdesign as default. I like to let user have
an option of using the default or switch to ~/path/short/myreport.rptdesign
by selecting short from a dropdown list (containing full and short options
using forms). The full and short reports are identical except one has
less rows. All reports use .csv data. I need this to work both in the
designer and the web.

BTW, I tried to use report parameters to select full/short reports but
"Enter Parameters" pop-up seem to only work from the designer. It will
not come up (ignored) when using the web applications - is this normal?

How can I achieve this and where should the code go?

Thanks in advance for any solution - aesfandi

Find more posts tagged with

Comments

johnw

It depends if the parameter is set to required or not. Also, make sure there is not a rptconfig file caching the parameter values.