sql server reporting services: Including multivalued parameter in URL -- sql server reporting services

Including multivalued parameter in URL

isaksp00
6/5/2006 12:27:01 PM

sql server reporting services:

I know how to include a parameter in a URL, by appending it after & sign at
end of report URL - works fine.

I can not figure out the syntax (if it is in fact possible) of passing a
multiple selection for a multivalued parameter. I tried both these formats,
where the ... represents the entire URL of the base report, including the
render command:

1) ...&Comp_Inv_ID=C123, C345
2) ...&Comp_Inv_ID=C123%2c%20C345 (i.e., converting the comma and space to
the %hex format, where hex 2c is comma and hex 20 is space)
Note that ...&Comp_Inv_ID=C123 works, selecting the single item.
Is it possible I have to somehow include each value as its own

Re: Including multivalued parameter in URL

Potter
6/7/2006 7:55:38 AM

I know one way to do it, but it isn't real elegant.

rather than this:

&param=val1,val2,val3

you do this:

&param=val1&param=val2&param=val3

[quoted text, click to view]

Re: Including multivalued parameter in URL

isaksp00
6/7/2006 9:22:01 AM

Thanks! I had just figured that one out about an hour ago as well.
Decidedly inelegant.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.