On Apr 19, 12:06 pm, "nkg" <x...@yahoo.com> wrote:
> Is it possible to configure combo box with values depending on another
> combobox selection in Reporting Parameters
> e.g.
> Input1: a combobox with country
> Input2: should dynamically display states in the selected country, which
> user can select.
> appreciate any pointers . thx

"EMartinez" <emartinez.pr1@gmail.com> wrote in message
news:1177009678.611966.300310@b58g2000hsg.googlegroups.com...
> On Apr 19, 12:06 pm, "nkg" <x...@yahoo.com> wrote:
>> Is it possible to configure combo box with values depending on another
>> combobox selection in Reporting Parameters
>> e.g.
>> Input1: a combobox with country
>> Input2: should dynamically display states in the selected country, which
>> user can select.
>> appreciate any pointers . thx
>
>
> Sure. What you want to do is create a dataset to use for the second
> report parameter (in the Data tab, select the <New Dataset...> option
> from the drop-down list to the right of Dataset) and include the usual
> query as well as the place holder parameter (i.e., select States from
> StateTable where Country = @Country). Then select the 'Edit Selected
> Dataset' button [...] and on the Parameters tab enter in the Name of
> the parameter (in this case, @Country) [it is case sensitive by the
> way] and select the Parameter that @Country should be dependent on
> (most likely, something like: Parameters!Country.Value). hope this
> helps.
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant
>

On Apr 20, 2:45 pm, "nkg" <x...@yahoo.com> wrote:
> thx. a lot that worked."EMartinez" <emartinez....@gmail.com> wrote in message
>
> news:1177009678.611966.300310@b58g2000hsg.googlegroups.com...
>
> > On Apr 19, 12:06 pm, "nkg" <x...@yahoo.com> wrote:
> >> Is it possible to configure combo box with values depending on another
> >> combobox selection in Reporting Parameters
> >> e.g.
> >> Input1: a combobox with country
> >> Input2: should dynamically display states in the selected country, which
> >> user can select.
> >> appreciate any pointers . thx
>
> > Sure. What you want to do is create a dataset to use for the second
> > report parameter (in the Data tab, select the <New Dataset...> option
> > from the drop-down list to the right of Dataset) and include the usual
> > query as well as the place holder parameter (i.e., select States from
> > StateTable where Country = @Country). Then select the 'Edit Selected
> > Dataset' button [...] and on the Parameters tab enter in the Name of
> > the parameter (in this case, @Country) [it is case sensitive by the
> > way] and select the Parameter that @Country should be dependent on
> > (most likely, something like: Parameters!Country.Value). hope this
> > helps.
>
> > Regards,
>
> > Enrique Martinez
> > Sr. Software Consultant