Passing Multi Value Parameters to a SSRS Report

TheMSsForum.com: The Microsoft Software Forum

Hi,

I'm trying to figure out the best way to pass multi value parameters
to an SSRS report. I've got WSS 3.0 set up with SSRS Integration. I
was using the built in Report Viewer Web Part, and having users select
parameter values in the parameter pane, but this seems to load
somewhat slowly, and the drop down used to select the values doesn't
provide enough screen space for the user to see the full text values
of their selections. As a result, I'm looking at trying to build a
web part to pass these parameters to the report. In testing, I've
played around with the RegionFilterWebPart example that Microsoft
provides on the MSDN site, but am having trouble getting that to
actually work (plus, according to what I've read, I can't pass multi
value parameters out of that web part). Does anyone have any ideas
for how I can do this?

Thanks!
Top

Re: Passing Multi Value Parameters to a SSRS Report by Mike

Mike
Mon Aug 25 13:06:23 CDT 2008

I recommend the SharePoint - Business Intelligence *forum* which mostly
concentrates on SSRS questions for this one.

http://forums.technet.microsoft.com/en-US/sharepointbi/threads/


Mike Walsh
WSS FAQ http://www.wssfaq.com / http://wss.collutions.com
no questions by e-mail please



Dave wrote:
> Hi,
>
> I'm trying to figure out the best way to pass multi value parameters
> to an SSRS report. I've got WSS 3.0 set up with SSRS Integration. I
> was using the built in Report Viewer Web Part, and having users select
> parameter values in the parameter pane, but this seems to load
> somewhat slowly, and the drop down used to select the values doesn't
> provide enough screen space for the user to see the full text values
> of their selections. As a result, I'm looking at trying to build a
> web part to pass these parameters to the report. In testing, I've
> played around with the RegionFilterWebPart example that Microsoft
> provides on the MSDN site, but am having trouble getting that to
> actually work (plus, according to what I've read, I can't pass multi
> value parameters out of that web part). Does anyone have any ideas
> for how I can do this?
>
> Thanks!
Top

Re: Passing Multi Value Parameters to a SSRS Report by Dave

Dave
Mon Aug 25 13:25:41 CDT 2008

Thanks Mike! I'll move the question over.

On Aug 25, 11:06=A0am, Mike Walsh <englantilai...@hotmail.com> wrote:
> I recommend the SharePoint - Business Intelligence *forum* which mostly
> concentrates on SSRS questions for this one.
>
> http://forums.technet.microsoft.com/en-US/sharepointbi/threads/
>
> Mike Walsh
> WSS FAQhttp://www.wssfaq.com/http://wss.collutions.com
> no questions by e-mail please
>
>
>
> Dave wrote:
> > Hi,
>
> > I'm trying to figure out the best way to pass multi value parameters
> > to an SSRS report. =A0I've got WSS 3.0 set up with SSRS Integration. =
=A0I
> > was using the built in Report Viewer Web Part, and having users select
> > parameter values in the parameter pane, but this seems to load
> > somewhat slowly, and the drop down used to select the values doesn't
> > provide enough screen space for the user to see the full text values
> > of their selections. =A0As a result, I'm looking at trying to build a
> > web part to pass these parameters to the report. =A0In testing, I've
> > played around with the RegionFilterWebPart example that Microsoft
> > provides on the MSDN site, but am having trouble getting that to
> > actually work (plus, according to what I've read, I can't pass multi
> > value parameters out of that web part). =A0Does anyone have any ideas
> > for how I can do this?
>
> > Thanks!- Hide quoted text -
>
> - Show quoted text -

Top