Conditional Cascading Parameters

Hi,
I am looking for some help with builing parameters in a report. A have a
report that displays sales persons. What I need to do is either allow entry
of the sales person number directly OR use a set of cascading parameters that
start at country, then region, then state, followed by office. The office
parameter/query would display all salespersons for that office.
Is there any way that when the salesperson number is entered directly to
disable all other parameters and render the report? On the flip side, if the
salesperson number is not entered, then allow all other parameters.
Thank you,
BobI am not aware of a way to do this, although I have messed with it a
little... It would be a nice feature to have, but right now I think you'd
have to do this in HTML in front of the report
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob" <Bob@.discussions.microsoft.com> wrote in message
news:DFACCE39-01A3-495F-BBD1-0013A6CA1D62@.microsoft.com...
> Hi,
> I am looking for some help with builing parameters in a report. A have a
> report that displays sales persons. What I need to do is either allow
> entry
> of the sales person number directly OR use a set of cascading parameters
> that
> start at country, then region, then state, followed by office. The office
> parameter/query would display all salespersons for that office.
> Is there any way that when the salesperson number is entered directly to
> disable all other parameters and render the report? On the flip side, if
> the
> salesperson number is not entered, then allow all other parameters.
> Thank you,
> Bob|||I thought I may need to put a front end on the report. Thank you for
comfirming this.
Bob
"Wayne Snyder" wrote:
> I am not aware of a way to do this, although I have messed with it a
> little... It would be a nice feature to have, but right now I think you'd
> have to do this in HTML in front of the report
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Bob" <Bob@.discussions.microsoft.com> wrote in message
> news:DFACCE39-01A3-495F-BBD1-0013A6CA1D62@.microsoft.com...
> > Hi,
> >
> > I am looking for some help with builing parameters in a report. A have a
> > report that displays sales persons. What I need to do is either allow
> > entry
> > of the sales person number directly OR use a set of cascading parameters
> > that
> > start at country, then region, then state, followed by office. The office
> > parameter/query would display all salespersons for that office.
> >
> > Is there any way that when the salesperson number is entered directly to
> > disable all other parameters and render the report? On the flip side, if
> > the
> > salesperson number is not entered, then allow all other parameters.
> >
> > Thank you,
> >
> > Bob
>
>