Removing Parameter Dependencies

I was wondering if anyone knows of a way to remove parameter dependencies.
I'm making a lot of reports for my company, but for some reason the Reports
Server is setting up a bunch of parameter dependencies, and it's causing
parameter entry to be extremely tedious (when you change a parameter that
another is dependent on, it'll reset the dependent parameter to its default
value).
So far the only way I've found is to manually edit the field in the report
server database - but I can't do that for all of the reports or ensure that
it'll stay updated in the future. Is there a way to edit parameter
dependencies?Any parameter which is used in a SQL statement will be re-evaluated often...
You can tell Reporting Services that it is NOT used in SQL by changing the
RDL...In SQL 2005 this will be an attribute in the dialog box...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Kyle" <Kyle@.discussions.microsoft.com> wrote in message
news:B619A389-EB95-4DE8-AE05-5E46BB1A4208@.microsoft.com...
>I was wondering if anyone knows of a way to remove parameter dependencies.
> I'm making a lot of reports for my company, but for some reason the
> Reports
> Server is setting up a bunch of parameter dependencies, and it's causing
> parameter entry to be extremely tedious (when you change a parameter that
> another is dependent on, it'll reset the dependent parameter to its
> default
> value).
> So far the only way I've found is to manually edit the field in the report
> server database - but I can't do that for all of the reports or ensure
> that
> it'll stay updated in the future. Is there a way to edit parameter
> dependencies?|||All of the parameters are used in the SQL, and we're not using 2005 (and
won't be in the near future).
I've noticed that the report server doesn't automatically set up parameter
dependencies when no default value is given for the parameter. However, as
we would like to have default values for our parameters, this doesn't help me
much.
Kyle
"Wayne Snyder" wrote:
> Any parameter which is used in a SQL statement will be re-evaluated often...
> You can tell Reporting Services that it is NOT used in SQL by changing the
> RDL...In SQL 2005 this will be an attribute in the dialog box...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Kyle" <Kyle@.discussions.microsoft.com> wrote in message
> news:B619A389-EB95-4DE8-AE05-5E46BB1A4208@.microsoft.com...
> >I was wondering if anyone knows of a way to remove parameter dependencies.
> > I'm making a lot of reports for my company, but for some reason the
> > Reports
> > Server is setting up a bunch of parameter dependencies, and it's causing
> > parameter entry to be extremely tedious (when you change a parameter that
> > another is dependent on, it'll reset the dependent parameter to its
> > default
> > value).
> >
> > So far the only way I've found is to manually edit the field in the report
> > server database - but I can't do that for all of the reports or ensure
> > that
> > it'll stay updated in the future. Is there a way to edit parameter
> > dependencies?
>
>|||Kyle,
I'm not sure what sort of defaults you are setting up, or if any of them are
dependant upon other parameters, but I ran into a similar situation, and here
is how I fixed it.
We have many reports where we wanted to display defalut dates (such as Date
From and Date To parameters being set to the first and last day of the
current month). If you set the parameter default using VB code as a
Non-Queried default value, it will assume that the parameter may be dependant
upon another parameter, and reevaluate the default whenever you edit
parameters before it. So, we created a dataset called DateParameters, and
used SQL to return two columns (BeginningOfMonth and EndOfMonth). For the
parameters, we set the default to "From Query" and used the columns of the
DateParameters data set to set the defaults. This prevented the parameters
as being labeled as dependant, and kept our reports from refreshing. If you
actually have defaults that are dependant upon other parameter values, you
can still use a dataset to do the computations, but your page will refresh
these parameters if their dependant values change.
Sorry this was so long-winded, but I hope it helps you.
David
"Kyle" wrote:
> All of the parameters are used in the SQL, and we're not using 2005 (and
> won't be in the near future).
> I've noticed that the report server doesn't automatically set up parameter
> dependencies when no default value is given for the parameter. However, as
> we would like to have default values for our parameters, this doesn't help me
> much.
> Kyle
> "Wayne Snyder" wrote:
> > Any parameter which is used in a SQL statement will be re-evaluated often...
> > You can tell Reporting Services that it is NOT used in SQL by changing the
> > RDL...In SQL 2005 this will be an attribute in the dialog box...
> >
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > (Please respond only to the newsgroup.)
> >
> > I support the Professional Association for SQL Server ( PASS) and it's
> > community of SQL Professionals.
> > "Kyle" <Kyle@.discussions.microsoft.com> wrote in message
> > news:B619A389-EB95-4DE8-AE05-5E46BB1A4208@.microsoft.com...
> > >I was wondering if anyone knows of a way to remove parameter dependencies.
> > > I'm making a lot of reports for my company, but for some reason the
> > > Reports
> > > Server is setting up a bunch of parameter dependencies, and it's causing
> > > parameter entry to be extremely tedious (when you change a parameter that
> > > another is dependent on, it'll reset the dependent parameter to its
> > > default
> > > value).
> > >
> > > So far the only way I've found is to manually edit the field in the report
> > > server database - but I can't do that for all of the reports or ensure
> > > that
> > > it'll stay updated in the future. Is there a way to edit parameter
> > > dependencies?
> >
> >
> >|||Thank you very much!
That solved almost every single problem I was having with parameters. Now
if I can just figure out how to get tooltips to display for the parameter
form boxes...
Thanks again!
Kyle
"David Siebert" wrote:
> Kyle,
> I'm not sure what sort of defaults you are setting up, or if any of them are
> dependant upon other parameters, but I ran into a similar situation, and here
> is how I fixed it.
> We have many reports where we wanted to display defalut dates (such as Date
> From and Date To parameters being set to the first and last day of the
> current month). If you set the parameter default using VB code as a
> Non-Queried default value, it will assume that the parameter may be dependant
> upon another parameter, and reevaluate the default whenever you edit
> parameters before it. So, we created a dataset called DateParameters, and
> used SQL to return two columns (BeginningOfMonth and EndOfMonth). For the
> parameters, we set the default to "From Query" and used the columns of the
> DateParameters data set to set the defaults. This prevented the parameters
> as being labeled as dependant, and kept our reports from refreshing. If you
> actually have defaults that are dependant upon other parameter values, you
> can still use a dataset to do the computations, but your page will refresh
> these parameters if their dependant values change.
> Sorry this was so long-winded, but I hope it helps you.
> David
> "Kyle" wrote:
> > All of the parameters are used in the SQL, and we're not using 2005 (and
> > won't be in the near future).
> >
> > I've noticed that the report server doesn't automatically set up parameter
> > dependencies when no default value is given for the parameter. However, as
> > we would like to have default values for our parameters, this doesn't help me
> > much.
> >
> > Kyle
> >
> > "Wayne Snyder" wrote:
> >
> > > Any parameter which is used in a SQL statement will be re-evaluated often...
> > > You can tell Reporting Services that it is NOT used in SQL by changing the
> > > RDL...In SQL 2005 this will be an attribute in the dialog box...
> > >
> > > --
> > > Wayne Snyder MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > > (Please respond only to the newsgroup.)
> > >
> > > I support the Professional Association for SQL Server ( PASS) and it's
> > > community of SQL Professionals.
> > > "Kyle" <Kyle@.discussions.microsoft.com> wrote in message
> > > news:B619A389-EB95-4DE8-AE05-5E46BB1A4208@.microsoft.com...
> > > >I was wondering if anyone knows of a way to remove parameter dependencies.
> > > > I'm making a lot of reports for my company, but for some reason the
> > > > Reports
> > > > Server is setting up a bunch of parameter dependencies, and it's causing
> > > > parameter entry to be extremely tedious (when you change a parameter that
> > > > another is dependent on, it'll reset the dependent parameter to its
> > > > default
> > > > value).
> > > >
> > > > So far the only way I've found is to manually edit the field in the report
> > > > server database - but I can't do that for all of the reports or ensure
> > > > that
> > > > it'll stay updated in the future. Is there a way to edit parameter
> > > > dependencies?
> > >
> > >
> > >