all groups > sql server reporting services > september 2007 >
You're in the

sql server reporting services

group:

ReportViewer control and multivalue parameter


ReportViewer control and multivalue parameter Gilgamesh
9/27/2007 7:00:57 PM
sql server reporting services:
I'm using the control on an asp.net page. The first parameter is a multi
value field which is populated by a query. How can I programaicattly select
the first value as a default? I don't see anything in ReportParameter class
that can do that.

Thanks,
Gilgamesh


Re: ReportViewer control and multivalue parameter Jeje
9/27/2007 10:48:28 PM
you can create a query which return the first value you want
and set this query result as the default value for the multivalue parameter.


[quoted text, click to view]
Re: ReportViewer control and multivalue parameter EMartinez
9/28/2007 2:45:00 AM
[quoted text, click to view]


You might need to create a second dataset (duplicate of the
multivalued parameter's dataset except for maybe the minimum/maximum
value) that is tied to the default value you want to use and then
select it as the default value in the Parameter settings. Hope this
helps.

Regards,

Enrique Martinez
Sr. Software Consultant
Re: ReportViewer control and multivalue parameter Gilgamesh
9/28/2007 2:18:14 PM
The problem is that this is thesecond parameter which depends on thevalue of
first parameter. The first parameter value is passed in through URL, and I
found out that the second parameter can not beinitialized when it depends on
another parameter.
-G


[quoted text, click to view]

AddThis Social Bookmark Button