Create the Data Set

  1. From the BIRT Report Designer, click Data > New Data Set. The New Data Set page opens.
  2. Select an existing Data Source.
  3. Select StarTeam Data Set as the Data Set Type.
  4. Enter a name in the Data Set Name field.
  5. Click Next. The Select Query page opens.
  6. Use the Select Query page to model commands that you would use in the command line. Restrictions on this page are based on how some types will or will not work with other queries or types. The Query Text field is editable and allows you to create your own (advanced) query. For example, you can build a where clause with property names: select * from File where propertyNameA ="A" and propertyNameB="Bla". You can also restrict the columns returned by saying select propertyNameA, propertyNameB from file.

    If the server is down when you open the Data Set page, an error is displayed and all fields will be disabled except for Query Text. This is because many fields retrieve from the server. You can still edit/save the Query Text.

    If you share a report with another user, the DataSource credentials will only decrypt if you have the same user name. If you try to edit the data set or data source, an error will be reported telling you that decryption failed and to re-enter the credentials.

  7. Click Check when you are satisfied with your query. You will be notified of the results.
  8. Click Finish. The Output Columns page opens.
  9. Use the Output Columns page to change display names or change types. The Edit button allows you to change the default fields for the data set. For example, you could change the display name of a column or change a string data type to an Integer data type, as long as the format is correct.
  10. Click OK. The Preview Results page opens with your results.
  11. Click OK. BIRT will display all columns in the tree allowing you to drag them onto the report, create charts, or use any other BIRT functionality that you need.
Parent topic: Rich Reports