"Bruce L-C [MVP]" wrote:

> A couple of things. First, instead of suser_sname you could be using the
> global variable User!UserID. The advantage of this is it allows you to not
> be tying what account is being used to retrieve data. For instance, for
> performance you are better off to have a single read only user that you use
> to get data. This allows connection pooling to kick in. Also, you don't have
> to be perpetually managing users in the database.
>
> Anyway, that was an aside. When you say drilldown are you talking drill down
> or drill through? Drill down means that you click on a + and get additional
> data. Drill through means you are using jump to.
>
> Instead of jump to you can use jump to URL. This can be an expression that
> uses a different URL (i.e. pulling up a different report) depending on
> whatever value you want.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Deano" <Deano@discussions.microsoft.com> wrote in message
> news:718C7AF1-4C94-4B21-845E-3067E166A19F@microsoft.com...
> > Based on a User's SUSER_SNAME(), I perform a query within our company's
> > Sale
> > Org to determine which
> > Branches and Sales Reps are displayed in Parent Report's Table.
> >
> > Then, when the user clicks on a Sales Rep, a secondary Report gets
> > "DrilledDown" to (not a sub-report) for the Rep's details... So far, so
> > good.
> >
> > If however, the User is simply a Sale Rep, I want the Parent report to
> > automatically Drilldown to second Report, passing of course, the known
> > necessary UserID info as the parameter.
> > Ideally, the Rep wouldn't even see the initial Parent Report.
> >
> > So I guess my question is...
> > If a Report Parameter has a specific value, can a Drilldown Report get
> > "launched" automatically,
> > e.g. without the user needing to "click" on the object which Drilldowns to
> > the second report with the appropriate parameter ?
> >
> > Many thanks in advance,
> >
> >
> > Dean Cavill
>
>