Page Comparison

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.
   Image Removed
   Image Added
   
   

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

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

   
   Image RemovedImage Added
   
   

3. Click the

   Default

    Parameters Configuration

   tab

   Image Added icon to

   provide the default and additional configurations for the applied procedure parameters.
   Image Removed
   Click the Primary Ds Procedure Parameters Image Removed icon to assign additional configurations for the applied procedure parameters.  
   Image Removed
   

   In the Procedure Parameters Configuration pop-up window, select the appropriate app or configure the applied procedure parameters for the report.
   
   Image Added
   
   In the Params Configuration screen, the applied pre-hook procedure parameters of FD, TD and CURRENCY appear.

   Note

   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.

   Image Added
   
   

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.

   1. Select the filter criteria of your choice from the Apply Mandatory Filter As drop-down list, e.g. equals.

   Note

   The applied procedure parameters are FD (From Date), TD (To Date) and CUR (Currency). The parameter values for the listed procedure parameters are fetched from the widget of DETAILS_APP. The equals filter criteria is applied for the listed procedure parameters. By making use of the Apply Mandatory Filter As field, the equals filter criteria is applied as a mandatory data filter for the listed procedure parameters. However, the Apply Mandatory Filter As is an optional field.

   Image RemovedProceed to click Update to update the parameter configurations.

   Note

   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.

   Image Added
   
   

   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.

      Note

      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.

      
      Image Added
      
      

   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.
      
      Image Added
      
      
      
   3. Click the Save Image Added icon to save the configured procedure parameters.

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

5. Click Save to save the configured report.
   Image Removed
   Image Added
   
   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.

   Note
   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 Image Modified 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: