Create a new BIRT data set

After you create your BIRT data source, you select the data set columns that you want to use in the current report.

  • The report design must be open in the editor area.
  • A data source must linked with this report design.
Once you've selected the set of columns, you can order them as you wish, rename them or change their data type as appropriate.
  1. If necessary, open the Report Design Perspective.
  2. In the Data Explorer view, right-click the Data Sets item and select New Data Set.
    The New Data Set dialog appears.

    You'll see the Data Sources associated with your report design in the Data Source Selection pane.

  3. Select the IXIASOFT CCMS data source you want to use.
    BIRT lets you combine data from various sources, but this procedure deals only with connecting with data sources generated in the CCMS.
  4. From the Data Set Type list, select Flat File Data Set.
  5. Enter the Data Set Name you want to use.
  6. Click Next.
    The Select Table dialog appears.
  7. In the File filter list, make sure that *.tsv is selected.
  8. From the Select file list, choose the TSV file you want to use.
    The columns in the selected TSV file appear in the left-hand pane.
  9. In the left-hand pane, double-click the columns that you want to use in your report.
    The selected columns appear in the right-hand pane.

    You can reorder the columns using the up and down arrows on the right of the dialog.

  10. Select the Type.
    The CCMS data is output as strings. You have the option at this point of converting columns (such as Count) into integer or other numerical representations for use in calculations within BIRT.
  11. Click Finish.
    The Edit Data Set dialog appears.
  12. You can use the Edit Data Set dialog to further modify your data set or to preview its results.
  13. Click OK.
Your new data set appears under the Data Sets item in the Data Explorer view. You can expand your new data set to display the selected columns.

You can now start to bind your data set elements to your report design.