Define the Data

The first step in report creation is defining the raw data. The reports in Interaction Reporter retrieve data from the PureConnect database by using stored procedures. The reports also retrieve some data using IceLib calls combined with database data for readability and display purposes.

For a report you create, you can use any method to retrieve data as long as the final object can bind to an ActiveReports.DataSource object. You can combine data from multiple sources in any way that you require and display the data in a report. For example, you can use:

• A DataTable within a DataSet.

• A DataTable by itself.

• An array of DataRows returned from a DataTable.Select() method.

• Any collection of objects with the object properties bound to the text boxes on the report. This includes a collection that results from a call to a Linq expression.

You can refer to ComponentOne documentation for additional object types.

.NET DataSet objects can have multiple DataTable objects. For example, a stored procedure could execute multiple SELECTs, and the report could utilize all of them. A report could present summarized and detailed data on the same report or create a main report that calls a subreport.