Page Comparison

...

1. On the home page of Sigma Studio, right-click an existing database connection and select the Create Data Source option.

   Note
   It is necessary that you create separate data sources for the grid widget and the report. In the given example here, the data source for the grid widget is a DB table data source (SP DS), whereas the data source for the report is a DB stored procedure (SP DS 6).

   
   
   
   

2. Create the DB table data source for the grid widget. For example, SP DS.
   
   
   
   
3. Create the DB stored procedure data source for the report. For example, SP DS 6.
   
   
   
   
4. Access App Designer and create a grid widget with the DB table data source (SP DS).
   
   1. Click Proceed to configure the grid widget.
      
      
      
      
      
5. Drag and drop the required data columns to the design area and click the Save icon to save the widget (e.g. ACCOUNTS).
   
   
   
   
6. Create a report with the DB stored procedure data source (SP DS 6) and provide the necessary configuration details as per your needs and requirements.
   Image Removed
   Image Added
   Select
   
7. choose the appropriate key and description columns from the Key Column and Description Column lookup fields.
   Select the filter criteria of your choice from the Apply Mandatory Filter As drop-down list

   Click the

   Default Configuration tab and then click the Primary Ds Procedure Parameters Image Removed icon.
   Image Removed
   In the Procedure Parameters Configuration pop-up window, select the appropriate grid widget (e.g. ACCOUNTS) from the Load data from Widget lookup field and

    Parameters Configuration Image Added icon to configure the applied procedure parameters for the report.
   
   Image Added
   
   In the Params Configuration screen, the applied procedure parameters of ACCOUNT_NO, AVAI_BALANCE, FD, TD and CURRENCY appear.

   Note
   In this example, the DB stored procedure data source has following five input parameters: ACCOUNT_NO (Account Number) AVAI_BALANCE (Available Balance) FD (From Date) TD (To Date) CURRENCY (Currency) Among these five parameters, the values for the ACCOUNT_NO, AVAI_BALANCE, and CURRENCY parameters must be fetched from the grid widget, ACCOUNTS

   . You can notice in the following screen shot these three parameters are mapped to their respective columns in the grid widget

   , whereas the FD and TD parameters

   have been given default values.
   The

   should be provided with the custom date values in accordance with the data sets. 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.

   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 Removed

   However, both the Is Mandatory and Mandatory Filter Operator are optional fields.

   
   Image Added
   
   

8. Click the ACCOUNT_NO parameter and select the appropriate grid widget (e.g. ACCOUNTS) 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
   
   

   1. Click the AVAI_BALANCE parameter and select the appropriate grid widget (e.g. ACCOUNTS) 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
      
      

   2. Click the FD (From Date) parameter and select Custom from the Source lookup field to provide the relevant date of your choice. In the Parameter Value field, select the relevant date, e.g. 02/02/2022. 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 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 cannot be greater than the FD parameter value.

      
      Image Added
      
      

   3. Click the TD (To Date) parameter and select Custom from the Source lookup field to provide the relevant date of your choice. In the Parameter Value field, select the relevant date, e.g. 04/02/2022. 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 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
      
      

   4. Click the CURRENCY parameter and select the appropriate grid widget (e.g. ACCOUNTS) 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
      
      

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

      Note
      Click outside the Procedure Parameters Configuration window, so that the configured procedure parameters get saved.

      Image RemovedImage Added
      

   
   
   
9. Click Save to save the report.
   Image Removed
   Image Added
   
   
10. Access the relevant report (e.g. REPORT) in the Sigma Application.
    
    
    
    The FD and TD parameters display the default custom date values, which can even be changed by the end-user, whereas the other three parameters display drop-downs from which the end-user can select the values.
    
    
    
    
11. For the Account No procedure parameter, click the parameter value drop-down list and select an account number, e.g. 5500000848.
    
    
    
    
12. For the Balance procedure parameter, click the parameter value drop-down list and select the balance amount, e.g. 15476.00.
    
    
    
    
13. For the Currency procedure parameter, click the parameter value drop-down list and select a currency value, e.g. INR.
    
    
    
    
14. After you provide the relevant parameter values for the applied procedure parameters, you can proceed to click Run to generate the report.
    
    
    
    
15. Access the Generated Reports tab and then download the generated report.
    
    
    
    The fetched data of the report, with the relevant data values provided to the applied procedure parameters, is displayed in the PDF file, as shown in the following screen shot: