Creating New Reports

To create a new report:

  1. In the menu, click Reports > Details View.
  2. In the Reports tree, select the folder in which you want the new report to display. This determines where the report is stored in the directory tree.
  3. Click New Child Report on the toolbar. The Create New Report dialog box opens.
  4. Type the name of the new report. This is the name that is displayed in the Reports tree.
  5. Check the Share this report with other users check box if you want to make this report available to other users.
  6. In the Timeout [s] field, type the maximum time period in seconds that Silk Central should wait for SQL queries to complete.
  7. From the Default tab list, select the tab that you want to be directed to when you select this report from one of the context-sensitive report lists.
  8. Select the corresponding result type from the Result category list. This setting specifies the database table and view that is to be filtered for the report. The following result types are available:
    Result Type
    Description
    Requirement
    Returns requirements available in the Requirements module that meet the query criteria.
    Test
    Returns tests available in the Tests area that meet the query criteria.
    Test Execution
    Returns executed test results from the Executions area that meet the query criteria.
    Execution Plan
    Returns execution plans from the execution area.
    Issue
    Returns issues, including imported issues.
    Requirement Progress Builds
    Contains information on requirements progress per build so that you can see how requirements develop across builds.
    Requirement Progress Days
    The same as Requirement Progress Builds, but shows development on a daily basis.
    Test Progress Builds
    Shows how tests develop across builds.
    Test Progress Days
    Same as above, but shows development on a daily basis.

    Each result type offers a set of selection criteria. Based on the result type you have selected, specify an appropriate Selection criteria for your report. These criteria typically group properties based on a view or some other intuitive grouping, for example custom properties.

  9. From the Property list, select the property that is to be filtered on. For some selection criteria, properties are dynamic.
  10. Select an Operator for the query. The available operators depend on the property. Example operators are =, not, like, and not like. Strings are always compared lowercase. Allowed wildcards for strings are "*" and "?", where * matches any characters and ? matches exactly one character.
  11. Select or specify the Value that the query is to be filtered on. For date-based properties, the Value field is replaced with a calendar tool that you can use to select a specific date.
  12. Optional: To add an additional query string to this report, click More. An existing query string can be deleted by clicking the string’s Delete button. When multiple query strings are defined, AND and OR option buttons are displayed next to More. Use these option buttons to define if the queries should be considered cumulatively, or if only one query string’s criteria needs to be met.
  13. Click Next to configure report columns on the New Report dialog box.
  14. Click Add Columns. The Add Columns dialog box lists all available report columns.
  15. Select the columns that you want to have included in the report and click OK. You can select multiple columns with Ctrl+Click.
    Note: For test-planning reports, the list of available column names is enhanced with the column names from the LQM_V_Tests table. For details, refer to the Silk Central Database Model Schema.
    The selected columns display in tabular format on the New Report dialog box.
  16. Optional: Configure how each report column is to be displayed. For each column, specify a sort direction, ascending, descending, or unsorted, using the up/down arrows in the Sorting column.
  17. When multiple columns are selected for sorting, a list box is displayed in the Sort Order column that allows you to more easily edit the column-sort order. Set these numbers as required.
  18. Give each column an Alias. This is the name by which each column will be labeled in the generated report.
    Note: An Alias cannot contain double quotes (").
  19. With grouping, you can take advantage of SQL aggregation features, for example when selecting a number of elements or querying a total sum of values. Check the Group by check box to specify that SQL group by functions are to be applied.
  20. Columns that are not selected for SQL group by functions are set to aggregation by default, which means a single aggregate value is calculated. From the Aggregation list, select the appropriate aggregation type. The following types are available:
    • Count
    • Sum
    • Average
    • Minimum
    • Maximum
  21. The Actions column enables you to move column listings up and down in the view, or to delete a column.
  22. Click Finish to complete your new report.
Parent topic: Creating Reports