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 Page History

« Previous Version 11 Next »

To create a report with the fetched widget data for the applied procedure parameters, perform the following steps in Sigma Studio:

  1. On the home page of Sigma Studio, click Manage > Report.



    The Information Report page appears.



  2. Provide the necessary configuration details for the report, as shown in the following screen shot:

    The Data Source Name is selected as the NEW DS, which was configured as the Parent Data Source, while the relevant stored procedure data source of SAMPLE PROCEDURE DS is selected as the Pre Hook Procedure DS for the configured report.




  3. Click the Parameters Configuration icon to configure the applied procedure parameters for the report.



    In the Params Configuration screen, the applied pre-hook procedure parameters of FD, TD and CURRENCY appear.

    In this example, the pre-hook stored procedure data source has the following three input parameters:

    • FD (From Date)
    • TD (To Date)
    • CURRENCY (Currency)

    The values for the FD, TD, and CURRENCY parameters must be fetched from the grid widget, DETAILS_APP. The parameters can be made mandatory by making use of the Is Mandatory option and the Equals filter criteria is applied as the Mandatory Filter Operator for the listed procedure parameters. However, both the Is Mandatory and Mandatory Filter Operator are optional fields.



  4. Click the FD parameter and select the From App option from the Source drop-down list. And then select the appropriate grid widget (e.g. DETAILS_APP) from the Load data from Widget lookup field and choose the appropriate key and description columns from the Key Column and Description Column lookup fields. Proceed to click Update to update the parameter configurations.

    On using a couple of date parameters in a stored procedure report, the Dependency and Validation fields appear, which can be used to assign the dependencies and validations for the date parameters. In the provided example, the TD (To Date) parameter is selected as a dependent parameter for the FD (From Date) parameter from the Dependency drop-down list. Only the date parameters will get listed in the Dependency drop-down list. The Less Than condition is selected from the Validation Condition drop-down list, indicating that the FD parameter should always be lesser than the TD parameter value and in all cases, the TD parameter value must be greater than the FD parameter value.



    1. Click the TD parameter and select the From App option from the Source drop-down list. And then select the appropriate grid widget (e.g. DETAILS_APP) from the Load data from Widget lookup field and choose the appropriate key and description columns from the Key Column and Description Column lookup fields. Proceed to click Update to update the parameter configurations.

      On using a couple of date parameters in a stored procedure report, the Dependency and Validation fields appear, which can be used to assign the dependencies and validations for the date parameters. In the provided example, the FD (From Date) parameter is selected as a dependent parameter for the TD (To Date) parameter from the Dependency drop-down list. Only the date parameters will get listed in the Dependency drop-down list. The Greater Than condition is selected from the Validation Condition drop-down list, indicating that the TD parameter should always be greater than the FD parameter value and in all cases, the FD parameter value cannot be greater than the TD parameter value.




    2. Click the CURRENCY parameter and select the appropriate grid widget (e.g. DETAILS_APP) from the Load data from Widget lookup field and choose the appropriate key and description columns from the Key Column and Description Column lookup fields. Proceed to click Update to update the parameter configurations.




    3. Click the Save  icon to save the configured procedure parameters.




    Once you apply the procedure parameter configurations, a toast message appears, indicating a successful save of the applied procedure parameter configurations.



  5. Click Save to save the configured report.



    A confirmation message, indicating a successful save of the report, appears.



  6. Access the relevant report, e.g. PROCEDURE REPORT in the Sigma Application and click Run to generate the report.

    Provide the relevant parameter values for the applied procedure parameters. For instance, the FD (From Date) is selected as 02/02/2022 (MM/DD/YYYY format), while the TD (To Date) is selected as 02/03/2022 (MM/DD/YYYY format) and the CUR (Currency) is selected as INR. For detailed information on generating the reports in Sigma Application, refer Generating a Report.

     


  7. When the report generation status is displayed as Published to Repository, click the Download icon  to download the generated report.



    The fetched data of the PROCEDURE REPORT is displayed in the PDF file, as shown in the following screen shot:

  • 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.