FlexReport for WPF | ComponentOne
In This Topic
    Data Binding
    In This Topic

    In addition to a report definition, FlexReport needs the actual data to create the report. In most cases, the data comes from a database, but there are other options. The following sections explore how to retrieve data from other sources.

    Retrieving Data from Database

    For retrieving the report data in FlexReport, following DataSource properties of C1FlexReport should be set:

    To set data source, use the following code:

    C1FlexReport rep = new C1FlexReport();
//initialize DataSource
DataSource ds = rep.DataSource;
ds.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\...\ComponentOne Samples\Common\C1NWind.mdb;";
ds.RecordSource = "Employees";

    If these properties are set, C1FlexReport initializes the data source and uses them to load the data from the database automatically.

    Using DataTable Object as DataSource

    Many applications need to work on the data outside C1FlexReport and load it into DataTable objects. In such cases, you can use DataTable objects as report data sources, avoiding the need to load them again while rendering the report.

    This approach is also useful in applications where:

    To use a DataTable object as a C1FlexReport data source, simply load the report definition and then assign the DataTable to C1FlexReport.DataSource.Recordset property. For example:

    // load DataTable from cache or from a secure/custom provider
 DataTable dt = GetMyDataTable();

 // load report definition (before setting the data source)
rep.Load(@"reportFile", "reportName");

 // use DataTable as the data source
rep.DataSource.Recordset = dt;
        
private DataTable GetMyDataTable()
{
  DataTable result = new DataTable();
  result.Columns.Add("ID", typeof(int));
  result.Columns.Add("Caption", typeof(string));
  result.Rows.Add(1, "Red");
  result.Rows.Add(2, "Blue");
  result.Rows.Add(3, "Green");
  return result;
}

    Using Custom Data Source Objects

    You can use custom objects as data sources. The only requirement is that the custom object must implement the IC1FlexReportRecordset interface.

    IC1FlexReportRecordset is a simple and easy-to-implement interface that can be added to virtually any collection of data with ease. This is often more efficient than creating a DataTable object and copying all the data into it. For example, you could use custom data source objects to wrap a file system or custom .xml or .flxr files.

    To use custom data source objects, load the report definition and then assign the object to the C1FlexReport's Recordset property of the DataSource class. For example:

    public class MyRecordset: IC1FlexReportRecordset {
  private int _recNo;
  private int _recCount;

  public MyRecordset() {
    _recCount = 60;
  }

  public int RecCount {
    get {
      return _recCount;
    }
    set {
      _recCount = value;
    }
  }

  // IC1FlexReportRecordset implementation
  public string[] GetFieldNames() {
    return new string[] {
      "ID",
      "Caption"
    };
  }

  public Type[] GetFieldTypes() {
    return new Type[] {
      typeof(int), typeof(string)
    };
  }

  public object GetFieldValue(int fieldIndex) {
    switch (fieldIndex) {
      case 0:
        return _recNo + 1;
      case 1:
        return string.Format("Caption {0}", _recNo + 1);
      default:
        return null;
    }
  }

  public bool BOF() {
    return _recNo < 0;
  }

  public bool EOF() {
    return _recNo >= _recCount;
  }

  public void MoveFirst() {
    _recNo = 0;
  }

  public void MoveLast() {
    _recNo = _recCount - 1;
  }

  public void MovePrevious() {
    --_recNo;
  }

  public void MoveNext() {
    ++_recNo;
  }

  public int GetBookmark() {
    return _recNo;
  }

  public void SetBookmark(int bkmk) {
    _recNo = bkmk;
  }

  public int Count {
    get {
      return RecCount;
    }
  }

}

private IC1FlexReportRecordset GetMyCustomDataSource() {
  return new MyRecordset() {
    RecCount = 3
  };
}

private void btnGet_Click(object sender, EventArgs e)
{
  // get custom data source object
  IC1FlexReportRecordset rs = GetMyCustomDataSource();

  // load report definition (before setting the data source)
  rep.Load(@"..\..\Products Report.flxr", "Products Report");

  // use custom data source object in C1FlexReport component
  rep.DataSource.Recordset = rs;

  PdfFilter pf = new PdfFilter();
  pf.Preview = true;
  pf.FileName = @"..\..\Products Report.pdf";
  rep.RenderToFilter(pf);
}

    Retrieving Data from a Stored Procedure

    Stored procedures can assist you in achieving a consistent implementation of logic across applications, improve performance, and shield users from needing to know the details of the tables in the database. One of the major advantages of stored procedures is that you can pass the parameters to have the database filter the recordset. This returns a smaller set of data, which is quicker and easier for the report to manipulate.

    You can populate a report from a stored procedure in the C1FlexReport Wizard. To open the C1FlexReport Wizard, click the New Report button from the Reports tab the C1FlexReportDesigner application.complete the following:

    Populating a report from a stored procedure is no different than using SQL statements or straight tables. In the first screen of the C1FlexReport Wizard, click the ellipses button to choose a data source. Then choose a Stored Procedure from the list of available Data sources:

     

    Select Next and continue through the wizard.

    For loading other forms of data, you have two options: