Using Reports Report you can create reports over a data source data. The data source can be a database or a REST web service. Refer Creating Data Connections for information on creating a data source.
To create reports, perform the following steps in Canvas Studio:
- Click Create > ReportsReport.
The Information Report page appears. - In the Report Maintenance tab, enter a unique ID for the report in the Report Id field.
- Enter a display name for the report in the Report Name field.
- Click the Data Source Name field and select a data source. Refer Creating Data Connections to create a data source.
Click the Select Columns to Display field and select the columns for the report.
Info When creating child reports in the application, end users will be able to select only the columns selected here for the parent report.
- Click the Select Groupable Columns field and select the column(s) by which the report results are to be grouped.
- Click the Select Sortable Columns field and select the column(s) by which the report results are to be sorted.
- Click the Select Filterable Columns field and select the column(s) by which the report results are to be filtered.
- Click the Select Allowed Formats field and select the formats in which the report can be generated.
- If you want to use bundles for the report column headers specified in Select Columns to Display field, enter the name of the resource bundle property file in the Resource Bundle field.
Click Submit.
Info The new report is made available for the end users in the Information Reports workspace in the end application.