Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Next »

In order to create a complex report as shown, perform the following steps in Canvas Studio:

  1. Click Create > Report.


The Information Report page appears with the Report Maintenance tab open by default.

  1. In the Report Maintenance tab,
  2. Enter a unique ID for the report in the Report Id field.
  3. Enter a display name for the report in the Report Name field.
  4. Click the Data Source Name field and select a data source. Refer Creating Data Connections to create a database or web service connection and data source.

Note: Here, SUMMARY (M) which is created manually is used as the data source.
If you select a multilevel data source, Data Grid field appears near the Template Design icon.

  1. Click the Data Grid field and select a data source. . Here, we have chosen D_SUMMARY _DS as the data grid in order to display their data in the report

Info: If you click the Data Entitlements ( ) icon, the Entitlement Configuration page appears.

By default, the configuration is provided to be as CANVAS. This can be changed by selecting the alternatives in the drop-down list.

  1. Click Template Designer ( ) icon to design the template.

The Template Designer page appears with the list of header and footer options on the left-hand side of the page and the list of columns from the selected data source on the right-hand side of the page.

  1. Select the type of the field to be designed.
  2. Select the column layout. By default, a section with single-column (stack) layout is displayed and they can be altered from single-column (stack) to six-columns.
  3. Click Content ( ) icon.

  1. Click Add Content to create a template.


A page to create the template appears.

  1. Enter the template ID, description, type the content and click Save.

  1. Now, drag and drop the added content template from right-hand side into the section.

  1. To edit the content, click edit ( ) icon on the existing content template.

  1. Edit the content and click Save.
  2. If you want to add additional sections, click Add Sub-Section, drag and drop the required columns into that section.
  3. Click Save ( ) icon and go back to the Report Maintenance tab.

  1. Click the Select Columns to Display field and select the columns for the report.

Info: When generating reports in the application, end users will be able to select only the columns selected here for the report. Similarly, the following fields behave in the same manner - Select Groupable Columns, Select Sortable Columns, and Select Filterable Columns.

  1. Click the Select Allowed Formats field and select the formats in which the report can be generated. The following formats are supported: CSV, DOCX, HTML, PDF, XLS and XML.

Note: End users can generate reports in the application in the formats configured in the Select Allowed Formats field. For example, if CSV and HTML are selected for a report, end users can generate reports in the application in CSV and HTML formats only.

  1. Click the Select Filterable Columns field and select the column(s) by which the report results are to be filtered.
  2. Click Default Filter and the Default Filter Configuration page appears.

  1. Select the filter, criteria and enter the value.


  1. Click Add.


Note: Default filter provides the given value as the selected column in Sigma. Whereas, System filter will allow only the selected columns to be displayed.

  1. Click the Select Groupable Columns field and select the column(s) by which the report results are to be grouped.
  2. Click the Select Sortable Columns field and select the column(s) by which the report results are to be sorted.
  3. If you want to alter the default configuration settings for the report, click Default Configuration tab.

  1. Enter the title of the report in the Report Title field and select the format of the report from the Report Format drop-down list.
  2. Click Page Size field and select the size in which the report needs to be generated.
  3. Select the layout of the page to be portrait or landscape from the Page Layout field.
  4. In the Font Size field, select the font size by increasing or decreasing the number using the plus or minus sign respectively. By default, the font size is 12.
  5. Click the Select Columns to Display field and select the columns for the report.
  6. Click the Group By field and select the column(s) by which the report results are to be grouped.
  7. Click the Sort By field and select the column(s) by which the report results are to be sorted.
  8. Click Save.

A confirmation message appears.

  1. Click OK for the message.

Info: The new report is made available for the end users in the Information Reports workspace in the end application.

  • No labels

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.