Change Sub Report based on Main Report's Data

RELATED TO:

AUTHOR: Stephania Tapela

DATE POSTED: June 14, 2016

Article information

Article relates to

Telerik Reporting

Created by

Stef, Telerik

Last modified

June 14th, 2016

Last modified by

Stef, Telerik
  
PROBLEM
Change Sub Report based on Main Report's Data.

SOLUTION 
You can use a custom function in a binding to the SubReport item's ReportSource property. The function should return a valid ReportSource object that wraps a report - the sub report.
For example:
The custom function:
public static ReportSource SetReportSource(string field)
  {
      var TRS = new TypeReportSource();
      TRS.Parameters.Add("Parameter1", field);
      if (field.ToLower() == "yes")
          TRS.TypeName = typeof(SubReport1).AssemblyQualifiedName;
      else
          TRS.TypeName = typeof(SubReport2).AssemblyQualifiedName;
      return TRS;
  }

The binding in the main report's settings:
this.subReport1.Bindings.Add(new Telerik.Reporting.Binding("ReportSource", "= SetReportSource(Fields.MainReportFieldX)"));

Related Products
Telerik Reporting

Resources Buy Try

More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community

  • Demos

    Invoices, Sales Reports, Dashboards and other reports showcasing what you can accomplish with Telerik Reporting

  • Webinars

    Sign-up for upcoming webinars and watch recorded webinars

  • User Voice

    Get answers directly from the people who build Telerik controls

  • Documentation

    Detailed help articles and API references for Telerik Reporting

  • Knowledge Base

    Tutorials and working examples on how to achieve common scenarios

  • Code Library

    Sample projects submitted by Progress staff and community members

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends

  • Release History

    Complete release history for Telerik Reporting.

  • System Requirements

    Operating system, .NET and browser support