How to select all items in reportparameter?

[Roel]

Hi,

How can I select all items in a reportparameter when loading the report in the reportviewer?

I know I can set the value as follows:

 

Dim rep As New webreports.reportname
rep.ReportParameters("Period").Value = "aaa"

But I want to select all items when the reports loads for the first time, after that the user can drop any selected items.

I tried:
rep.ReportParameters("Period").Value = "aaa; bbb"
but that doesn't work.

Any suggestions?

Cheers
Roel

[Steve]

Hello Roel,

Please review the following blog post that elaborates on the matter: Reporting: How to set default value for a multivalue parameter.

Kind regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Roel]

Thanks!

Roel

[Rene]

Hi Steve,

I found this topic in my search for a solution like this. I have used it and it works fine. However, the data in my dataset has duplicate values in the rows of the table. The data in the <value_member> is not unique. The effect of this is that those rows which has a duplicate value are not as default in the reportt parameter. They are in the mulitivalue list but are not select and therefor not displayed in the report.

Is there a solution for this?

Thanks and regards

Rene

[Steve]

Hello Rene,

The built-in report parameters are meant for filtering the report data and that is why the value of the parameters should be distinct. Since your values are not distinct, we assume that you're not using them for filtering and you can implement your own UI or logic for handling such case.

Kind regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.