Drilldown reports

I want to show a list of accounts and when a user clicks on one show
account's details.
What is a best way of approaching that?
ThanksIf you generate a dataset with all the accounts' details you could then use a
table control with grouping by account. You would hide the detail line by
default but allow this to be toggled from a textbox on the group
header/footer.
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> I want to show a list of accounts and when a user clicks on one show
> account's details.
> What is a best way of approaching that?
> Thanks
>
>|||But since I have a detailed report already how can I create report with
links to the detailed report?
"magendo_man" <sql@.kappa.co.uk.(donotspam)> wrote in message
news:FEE2EC61-3596-4C90-92FE-C1A1EDF5DF6E@.microsoft.com...
> If you generate a dataset with all the accounts' details you could then
> use a
> table control with grouping by account. You would hide the detail line by
> default but allow this to be toggled from a textbox on the group
> header/footer.
> HTH
> --
> Magendo_man
> Freelance SQL Reporting Services developer
> Stirling, Scotland
>
> "Mark Goldin" wrote:
>> I want to show a list of accounts and when a user clicks on one show
>> account's details.
>> What is a best way of approaching that?
>> Thanks
>>|||Most of your detailed report is not visible because the detail line is
hidden. You will only see a list of account numbers. If you click the +
toggle, which you would probably have beside the account number, you would
then see all the detail for that account.
Your other option is a separate drilldown report. To do this you would need
to define an "action" linked to the account number textbox which opened
another report. One of the parameters you would pass to the drilldown report
is the account number.
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> But since I have a detailed report already how can I create report with
> links to the detailed report?
> "magendo_man" <sql@.kappa.co.uk.(donotspam)> wrote in message
> news:FEE2EC61-3596-4C90-92FE-C1A1EDF5DF6E@.microsoft.com...
> > If you generate a dataset with all the accounts' details you could then
> > use a
> > table control with grouping by account. You would hide the detail line by
> > default but allow this to be toggled from a textbox on the group
> > header/footer.
> >
> > HTH
> >
> > --
> > Magendo_man
> >
> > Freelance SQL Reporting Services developer
> > Stirling, Scotland
> >
> >
> > "Mark Goldin" wrote:
> >
> >> I want to show a list of accounts and when a user clicks on one show
> >> account's details.
> >> What is a best way of approaching that?
> >>
> >> Thanks
> >>
> >>
> >>
>
>