dropdown box ?

Is there anyway i can have a dropdown box on the report ? -
not on the parameters list - but on the report.
ThanksNope. You can do drill down (and maybe immitate one).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:16B29C30-C9E3-4F7A-8189-1620DCEFA15B@.microsoft.com...
> Is there anyway i can have a dropdown box on the report ? -
> not on the parameters list - but on the report.
> Thanks|||But how do i take the selected value ?
EX: if i have to select a country
i create a table with drill down
+Country
-Country
China
USA
UK
Australia
If the user clicks USA - how do i get the value ' i need to use that
value in other calulations.
Thanks
"Bruce L-C [MVP]" wrote:
> Nope. You can do drill down (and maybe immitate one).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:16B29C30-C9E3-4F7A-8189-1620DCEFA15B@.microsoft.com...
> > Is there anyway i can have a dropdown box on the report ? -
> > not on the parameters list - but on the report.
> >
> > Thanks
>
>|||You cann't do what you want. Remember, RS is a reporting solution that
renders in a variety of formats, of which HTML is just one of them. There is
some interactivity (drill down, drill through and in 2005 dynamic sorting)
but it is not a web application environment. In the end it is a report.
Now, if you want to jump to something once they click on that you can do
that, but you cann't detect elsewhere in the report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:5A9923A8-AED0-4EDE-998C-E6BCFD84257A@.microsoft.com...
> But how do i take the selected value ?
> EX: if i have to select a country
> i create a table with drill down
> +Country
> -Country
> China
> USA
> UK
> Australia
> If the user clicks USA - how do i get the value ' i need to use that
> value in other calulations.
> Thanks
> "Bruce L-C [MVP]" wrote:
>> Nope. You can do drill down (and maybe immitate one).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RP" <RP@.discussions.microsoft.com> wrote in message
>> news:16B29C30-C9E3-4F7A-8189-1620DCEFA15B@.microsoft.com...
>> > Is there anyway i can have a dropdown box on the report ? -
>> > not on the parameters list - but on the report.
>> >
>> > Thanks
>>|||There are serveral solutions I think. Let say your report is named "report1"
The first is to create a parameter in your report f.e. "SelectedValue" (you
hide it from the user).
You make sure the rport loads with a default value for this parameter (f.e.
blank).
And then you create an action on your country values, that action will call
the same report "Report1" but now with the parameter "SelectedValue"
containing the name of your country.
I use this technique f.e. to highlight a matrix row that a user has selected
and at the same time show a sub-report with details of the selected row.
Another possibility, that I haven't tried yet. Is to make an action that
opens a very small report, in a small window (fe with the window.open
function you can size the window ref.
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/methods/open_0.asp ).
The small report will only contain a few textboxes (arranged as a drop down
menu), you can even use parameters to fill them. You can than add actions to
these textboxes.
The only problem with this solution is that a selected action in the
"drop-down-menu" will have to open in another window (I thin there probably
is a solution for that to, but I haven't found it yet).
Hope this helps
"Bruce L-C [MVP]" wrote:
> You cann't do what you want. Remember, RS is a reporting solution that
> renders in a variety of formats, of which HTML is just one of them. There is
> some interactivity (drill down, drill through and in 2005 dynamic sorting)
> but it is not a web application environment. In the end it is a report.
> Now, if you want to jump to something once they click on that you can do
> that, but you cann't detect elsewhere in the report.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:5A9923A8-AED0-4EDE-998C-E6BCFD84257A@.microsoft.com...
> > But how do i take the selected value ?
> > EX: if i have to select a country
> > i create a table with drill down
> >
> > +Country
> >
> > -Country
> > China
> > USA
> > UK
> > Australia
> >
> > If the user clicks USA - how do i get the value ' i need to use that
> > value in other calulations.
> >
> > Thanks
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Nope. You can do drill down (and maybe immitate one).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "RP" <RP@.discussions.microsoft.com> wrote in message
> >> news:16B29C30-C9E3-4F7A-8189-1620DCEFA15B@.microsoft.com...
> >> > Is there anyway i can have a dropdown box on the report ? -
> >> > not on the parameters list - but on the report.
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>