Count Filtered Rows

[Stephen McDaniel]

I am wondering how I can find out the number of rows in a SubReport after filtering is applied.  I want to know whether all rows of a given SubReport are filtered out (leaving an empty report) so that I can hide that particular SubReport.  It's easy enough to see how many rows I get back from the database, but until the Filtering is processed, I don't really know how many rows will display.

This seems like an easy task, but so far I'm stumpted.

[Milen | Product Manager @DX]

Hello Stephen McDaniel,

Add the following event handlers and private field in your subreport to show and hide it according to the count of rows.

        private int rowCount = 0;
      
          //eventhandler for the whole report
        private void DetailDBReport_ItemDataBinding(object sender, System.EventArgs e)
        {
            this.rowCount = 0;
        }
          //eventhandler for the detail section
        private void detail_ItemDataBinding(object sender, System.EventArgs e)
        {
            this.rowCount++;
        }

        private void DetailDBReport_ItemDataBound(object sender, System.EventArgs e)
        {
            Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
            report.Visible = this.rowCount != 0;
        }

Write us if you need further assistance.

Best wishes,
Milen
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center