Hi
I've got several reports where i'm using parameters that are dependant on
each other, to create them i used the two data set approach where i used the
parameter from the first dataset in the second data set, so i have for
example a Regional unit data set and a Business Unit data set that takes the
regional unit as a parameter. this works fine for normal reporting how ever
when i try and set a subscription schedule for these reports i go to set the
parameters using report manager and it doesn't give me the business unit
parameter drop down, it's as if it's not running the dataset query that
generates this, is there anyway to get it to work. Some times it does refresh
after i have selected the regional unit it then populates the business unit
drop down but there are several other dependant parameters on these reports
and they will not propigate, it only allows one refresh, this is kind of
annoying as i want to be able to subscribe to these reports with various
different parameter combinations so that i can get the reports i want emailed
to me. Can anyone help.
Regards
James R