How to select all data when no selection is made for XtraReports multi value parameter

Andrew Lim

created 9 years ago

Hi,

I am currently having trouble passing "all" multi value parameter to my report

Below is my VB code and i am also attaching my report configuration

param1.Name = "parSvcType"
        param1.Type = GetType(System.String)
        param1.MultiValue = True
        param1.Value = New String() {""}
        param1.Visible = False
        report.Parameters.Add(param1)
        report.RequestParameters = False
        ASPxDocumentViewer1.Report = report
        ASPxDocumentViewer1.ReportTypeName = "rep_bycategory"

If user did not select any category i would like it to show all the data in the database. How can I achieve this ?

Thanks again for the assistance.

Rgds,
Andrew

screen.zip

Answers approved by DevExpress Support

Magne Roald

created 8 years ago (modified 8 years ago)

More clear way not to filter by multivalue parameter if nothing is selected this will be to:

crate a custom function that receives the multivalue parameter and returns it's length (it will just cast it's parameter to array and return Length property)
create a calculated field that uses this function with expression (CustomLenFunction([MultivalueParameter]) <= 0) OR ([FieldToFilterOn] In ([MultivalueParameter]))
check for this calculated field to = true in format string

DevExpress Support Team

created 9 years ago (modified 8 years ago)

Hi Andrew,

Currently, there is no default "Select All" item in multi-value Parameters. You need to implement this manually. An optimal solution is to customize the XtraReport's FilterString property in the XtraReport.DataSourceDemanded or XtraReport.BeforePrint event handler (or script handler) based on the current Parameter value. For example, if there are no elements in the Parameter.Value property, exclude the corresponding condition from FilterString. Otherwise, add it.

See also:
Optional Parameters for reports

Show previous comments (3)

Andrew Lim 9 years ago

Hi Ingvar,
I tried looking at the link but i still couldn't implement the codes in my source.
When i try implementing the below codes it says "Event BeforePrint cannot be found".
   Dim report As New XtraReport()
   Private Sub report_BeforePrint(sender As Object, e As Drawing.Printing.PrintEventArgs) Handles MyBase.BeforePrint
       report.FilterString = "[strSvcType] In (?parSvcType)"
   End Sub
Do you have a sample vb source that implements beforeprint with filterstring ?
Thanks again for the help.
Rgds,
Andrew

Vasily (DevExpress Support) 9 years ago

Hi Andrew,

I have created a sample project that illustrates how you can accomplish this task as per Ingvar's suggestion. You can find it in the attachment. In this sample project, you can find code that illustrates how to handle the report's events correctly:

Visual Basic
Partial Public Class ProductsReport  
    Inherits DevExpress.XtraReports.UI.XtraReport  
    ...  
    Private Sub ProductsReport_BeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs) Handles MyBase.BeforePrint  
        Dim selectedCategories As Integer() = DirectCast(Categories.Value, Integer())  
        If selectedCategories Is Nothing OrElse selectedCategories.Length = 0 Then  
            Me.FilterString = String.Empty  
        Else  
            Me.FilterString = "[CategoryID] In (?Categories)"  
        End If  
    End Sub  

End Class

I would also like to add that while creating a sample project for you, I found that the ASPxDocumentViewer control does not allow submitting empty values for multi-value parameters. I have created a separate thread for this issue and forwarded it to our developers for further research: ASPxDocumentViewer - Empty value cannot be submitted to the multi-value parameter.

T288742.zip

Andrew Lim 9 years ago

hi Vasily,
Many thanks for the sample codes. It really helps a lot and have resolve my issue.
rgds,
Andrew

Vasily (DevExpress Support) 9 years ago

You are always welcome, Andrew! I am happy to hear that our support was helpful.

Andre Steffens 2 9 years ago

In my case the Value property of the StaticListLookUpSettings turned out to be List(Of Object)
So my code to extract the selected values for the parameter was:

Visual Basic
Dim selectedSections As IEnumerable(Of String) = CType(Me.SectionFilter.Value, IEnumerable(Of Object)).Cast(Of String)

Vasily (DevExpress Support) 9 years ago

Thank you for sharing your solution, Andre!

Created: September 11, 2015 6:31 AM

Modified: April 6, 2017 9:51 AM

Platform: Reporting ASP.NET Web Forms

Product: Reporting for Web Forms

Build: 15.1.6

IDE: Microsoft Visual Studio 2012

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

How to select all data when no selection is made for XtraReports multi value parameter

Answers approved by DevExpress Support

Recently viewed tickets