Generating Simple Report in Sigma

Owned by Ravikumar Babu CTOO (Unlicensed)

The reports created in Sigma Studio will be available for use by the end users of the application. For representation purpose, the Sigma application is considered as the application. The reports created in Sigma Studio will be available in the "Information Reports" workspace in the Sigma application. To create such parent reports, refer Configuring a Simple Report.


To execute or generate the reports, perform the following steps:

  1. Log-in to the Sigma application and click Information Reports workspace. In Sigma application, Information Reports workspace is displayed by default after logging in.



    The Information Reports workspace opens with Reports section on the left-hand side, which shows the list of reports created in Sigma Studio. In our example, we created the Account Statement report in Sigma Studio.



  2. In the Reports section, click the report name.

    The Customize tab for the selected report appears on the right-hand side.



  3. Enter a name for the report in the Report Name field. For example, Account Statement (PDF).

  4. Choose the report format from the drop-down. For example, PDF.

    The report formats in the drop-down are based on the formats chosen while creating the report in Sigma Studio. In our example, we selected CSV, DOCX, HTML, PDF, XLS, and XML formats for the Account Statement report in Sigma Studio.

  5. Select the report size from the Select Paper Size drop-down list. By default, A4 Paper is displayed.
  6. Select the layout for the report from the Select Layout drop-down list. By default, Landscape is displayed.
  7. Specify the font size in the Font Size field. You can increase or decrease the font size by clicking the up or down arrows respectively.
  8. If you want to include serial number for the records in the report, toggle on the Serial No field. By default, serial number option is selected.

  9. Click the Select Columns drop-down and select the columns that needs to be shown on the report.

    The columns in the Select Columns drop-down are based on the columns chosen while creating the report in Sigma Studio.

    To quickly select all the columns for the report, click the Select All () icon. To remove all the selected columns, click the Remove All () icon. To select specific columns, select the checkbox adjacent to the column names as shown in the following screen shot:

  10. Click the Group By drop-down and select the column(s) by which the report results are to be grouped.
  11. Click the Sort By drop-down list and select the column(s) by which the report results are to be sorted.

  12. If suppose you want to filter the report results based on some parameters, select the filter from the Select Filter drop-down list in the Filter Criteria section.

    The columns in the Select Filter drop-down list is based on the configuration of Select Filterable Columns field while creating the report in Sigma Studio.

  13. Select the filter condition from the Select Criteria drop-down, select or specify the sub-criteria and click Add.

    The options in the Select Criteria drop-down list is based on the filter selected in the Select Filter drop-down list. A sample filter and criteria are shown in the following screen shot:

  14. To specify multiple filter criteria for the report, perform steps 12 and 13.
  15. Perform any of the following:
    • To execute the report, click Run.
      or
    • To save the report, click Save.
      or
    • To save and execute (generate) the report, click Save and Run.



      A confirmation message appears.



  16. Click OK for the confirmation message.

    If you have clicked Save and Run, the generated report appears on the Generated Reports tab.



  17. Wait till the report is generated, i.e. you must see the status as Success under the Running column. If the status is Inprogress, click the Refresh () icon to reload the generated report list. Hover on the generated report, the icons to download or execute the report appears.
  18. To download the generated report, click the download () icon.

  19. To execute the report again, click the execute () icon.

    When you execute the report again, the report will be re-generated and the existing report file is updated.


    The following screen shot shows a sample Account Statement report in PDF format:



Refer the following pages:

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.