Parameters in Reporting Services...

Is it possible to control a parameter type as being single vs. multi-valued
based on the value selected in the previous parameter?
Thank you
Ramdaskeep it multi - but only show one value to select if previous parameter
selection so indicates.
"Ram" wrote:
> Is it possible to control a parameter type as being single vs. multi-valued
> based on the value selected in the previous parameter?
> Thank you
> Ramdas|||Hi,
Thanks for the tip. How would i show only one value based on the previous
parameter selection.
Thank you
Ramdas
"Jimbo" wrote:
> keep it multi - but only show one value to select if previous parameter
> selection so indicates.
>
>
> "Ram" wrote:
> > Is it possible to control a parameter type as being single vs. multi-valued
> > based on the value selected in the previous parameter?
> >
> > Thank you
> > Ramdas|||use a stored procedure to populate your select list - one of the parameters
for this stored procedure would indicate whether the return list will be
multiple records or a single record
this parameter would be set by user selection before being passed to the
stored procedure
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:60367FB5-4886-40A2-85F8-A08AF9A938E2@.microsoft.com...
> Hi,
> Thanks for the tip. How would i show only one value based on the previous
> parameter selection.
> Thank you
> Ramdas
> "Jimbo" wrote:
>> keep it multi - but only show one value to select if previous parameter
>> selection so indicates.
>>
>>
>> "Ram" wrote:
>> > Is it possible to control a parameter type as being single vs.
>> > multi-valued
>> > based on the value selected in the previous parameter?
>> >
>> > Thank you
>> > Ramdas|||Is it possible to modify the XML code at runtime? I want to control the
report parameter properties multi-value setting of True/False during runtime
in the XML behind the RDL file. Set it to True if I want the parameters to be
multi-value or False for single-value. This is determined based on the value
selected in parameter one. Parameter one and two are City,State.
If City is selected in parameter one then I want Parameter two to be a
single-valued list, if State is chosen in Parameter One then I want the list
in Parameter two to be a multi-valued select list.
Any ideas or guidance would be appreciated.
"Jim" wrote:
> use a stored procedure to populate your select list - one of the parameters
> for this stored procedure would indicate whether the return list will be
> multiple records or a single record
> this parameter would be set by user selection before being passed to the
> stored procedure
>
>
>
>
> "Ram" <Ram@.discussions.microsoft.com> wrote in message
> news:60367FB5-4886-40A2-85F8-A08AF9A938E2@.microsoft.com...
> > Hi,
> > Thanks for the tip. How would i show only one value based on the previous
> > parameter selection.
> >
> > Thank you
> > Ramdas
> >
> > "Jimbo" wrote:
> >
> >> keep it multi - but only show one value to select if previous parameter
> >> selection so indicates.
> >>
> >>
> >>
> >>
> >> "Ram" wrote:
> >>
> >> > Is it possible to control a parameter type as being single vs.
> >> > multi-valued
> >> > based on the value selected in the previous parameter?
> >> >
> >> > Thank you
> >> > Ramdas
>
>

parameterizing multi valued parameter in data set

Hi,

I am creating a data set for a ROLAP report which executes a dynamic SQL using EXEC. I am finding problems parameterizing multi-valued report parameters in the SQL being executed through EXEC.

To consider a sample code:

EXEC('select * from country where country_key in ('+@.country+')')

where @.country is a multi-valued report parameter.

Regards,

Emil

google is a wonderful thing
http://groups.google.co.uk/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/9d9739713fe89f5f/11b4fc22ce2e9e0b?lnk=st&q=multi+value+parameter+%22reporting+services%22&rnum=3#11b4fc22ce2e9e0b|||

Hi,

i am facing similar problem. I was trying dynamic SQL for the performance of the report.

But got stuck on multivalued parameter......

For me

Declare @.sql varchar(4000), @.rcc varchar(4000)

set @.rcc='a'; -- now if more than one value will be passed to it, this query will fail, it will execute but return nothing.

select @.sql='SELECT * FROM abc '

select @.sql=@.sql + 'where abc_column in (''' + @.rcc + N''')'

Exec( @.sql)

I am not sure creating a function and using it to split the parameter values finally result as a plus or minus to the performance.

If any one has any other way of doing this, Pls help.

|||and did you bother reading the link?|||

Try this

create another parameter new_param_country which is single valued

make it hidden

give value as

="'" & Join(Parameters!country.Label, "', '") & "'"

Give the same expression for default value too

For eg:- if the countries selected are FRANCE, INDONESIA and ICELAND, the value of the new parameter will be 'FRANCE', 'INDONESIA', 'ICELAND' which is a string

Use this parameter in the dataset instead of the multivalued parameter.

Regards,

Meenu

|||

Thanks a lot Meenu. :-)

Works fine for me. Just did a little change to the expression

=Join(Parameters!country.Value, ", ")

as I needed only value.

Regards,

Emil

|||

This is exactly what I've been looking for to put all if the multi-value parameter values in the page header.

Thanks!

-Marianne

parameterizing multi valued parameter in data set

Hi,

I am creating a data set for a ROLAP report which executes a dynamic SQL using EXEC. I am finding problems parameterizing multi-valued report parameters in the SQL being executed through EXEC.

To consider a sample code:

EXEC('select * from country where country_key in ('+@.country+')')

where @.country is a multi-valued report parameter.

Regards,

Emil

google is a wonderful thing
http://groups.google.co.uk/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/9d9739713fe89f5f/11b4fc22ce2e9e0b?lnk=st&q=multi+value+parameter+%22reporting+services%22&rnum=3#11b4fc22ce2e9e0b|||

Hi,

i am facing similar problem. I was trying dynamic SQL for the performance of the report.

But got stuck on multivalued parameter......

For me

Declare @.sql varchar(4000), @.rcc varchar(4000)

set @.rcc='a'; -- now if more than one value will be passed to it, this query will fail, it will execute but return nothing.

select @.sql='SELECT * FROM abc '

select @.sql=@.sql + 'where abc_column in (''' + @.rcc + N''')'

Exec( @.sql)

I am not sure creating a function and using it to split the parameter values finally result as a plus or minus to the performance.

If any one has any other way of doing this, Pls help.

|||and did you bother reading the link?|||

Try this

create another parameter new_param_country which is single valued

make it hidden

give value as

="'" & Join(Parameters!country.Label, "', '") & "'"

Give the same expression for default value too

For eg:- if the countries selected are FRANCE, INDONESIA and ICELAND, the value of the new parameter will be 'FRANCE', 'INDONESIA', 'ICELAND' which is a string

Use this parameter in the dataset instead of the multivalued parameter.

Regards,

Meenu

|||

Thanks a lot Meenu. :-)

Works fine for me. Just did a little change to the expression

=Join(Parameters!country.Value, ", ")

as I needed only value.

Regards,

Emil

|||

This is exactly what I've been looking for to put all if the multi-value parameter values in the page header.

Thanks!

-Marianne