Filter in Report Designer .trdx

[Rubens]

Good evening, I managed to create a report in Report Designer and present data using a SQL Server wiht connectionString, but I'm having a little difficulty passing filter and display only the filtered data. What is missing in the code below so that the filter would start working.

private void Window_Loaded_1 (object sender, RoutedEventArgs e)
         {
             Telerik.Reporting.UriReportSource Telerik.Reporting.UriReportSource ur = new ();
             ur.Uri = System.IO.Path.Combine (Environment.CurrentDirectory "Report1.trdx");
             myReport.ReportSource = ur;
         / / Need to filter
             / *
             Telerik.Reporting.Filter filter1 Telerik.Reporting.Filter = new ();
             filter1.Expression = "Fields.Pro_codigo =";
             filter1.Operator = Telerik.Reporting.FilterOperator.Equal;
             filter1.Value = "= 00002";
             * /
         }

graciously
André

[Nasko]

Hello Rubens,

In order to change the report definition of the .trdx report you will need to deserialize the .trdx file. Following is an example code of this process:

var settings = new System.Xml.XmlReaderSettings();
settings.IgnoreWhitespace = true;

using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create("Report1.trdx", settings))
{
    var xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

    var report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);

    //applying filtering
    Telerik.Reporting.Filter filter1 = new Telerik.Reporting.Filter();
    filter1.Expression = "Fields.Pro_codigo";
    filter1.Operator = Telerik.Reporting.FilterOperator.Equal;
    filter1.Value = "= 00002";

    report.Filters.Add(filter1);

    this.reportViewer1.ReportSource = new InstanceReportSource
    {
        ReportDocument = report,
    };
}

However, you can apply filtering during design time using the Report Designer, which is easier and doesn't require any custom code. For more information please follow the How to: Add filtering to Report help article.

If your goal is to filter the data at runtime based on a user input you can use report parameters. This approach is described in the Using Parameters with the SqlDataSource component help article.

Regards,
Nasko
Telerik

[Vishnu]

i am using the same thing in vb.net. But the xmlReader object is returning Nothing. So no report is loading

Dim settings As New XmlReaderSettings()
        settings.IgnoreWhitespace = True
        Dim myReportBook As Telerik.Reporting.ReportBook = New Telerik.Reporting.ReportBook

        Using xmlReader As System.Xml.XmlReader = System.Xml.XmlReader.Create(Server.MapPath(strFilePath), settings)
            Dim xmlSerializer As New Telerik.Reporting.XmlSerialization.ReportXmlSerializer()
            Dim reportWMS As Telerik.Reporting.Report = DirectCast(xmlSerializer.Deserialize(xmlReader), Telerik.Reporting.Report)

            With reportWMS
                .DocumentMapText = ""
                .ReportParameters("projectNo").Value = _projectNo
                .ReportParameters("dnHeaderNo").Value = _value
                .ReportParameters("transferType").Value = _TransferType
                ReportViewer1.DocumentMapVisible = False
                ReportViewer1.ShowDocumentMapButton = False
            End With

            myReportBook.Reports.Add(reportWMS)
        End Using

        Dim reportSource = New Telerik.Reporting.InstanceReportSource
        reportSource.ReportDocument = myReportBook
        ReportViewer1.ReportSource = reportSource
        ReportViewer1.RefreshReport()

[Ivan Hristov]

Hello Vishnu,

Your code runs fine and the InstanceReportSource gets created properly.

Actually given your code It is highly unlikely the XmlReader to be Nothing after executing XmlReader.Create() method. In case the supplied file path is invalid, there should be an exception thrown. Please check if there are some exceptions that you catch later so your code execution never gets to the deserialization part.

Regards,
Ivan Hristov
Telerik