Page Comparison

Perform the following additional steps while configuring a report in Canvas Sigma Studio:

1. Click the Data Source Name field and select the table datasource that is corresponding to the created stored procedure. In this example, ACCOUNT SUMMARY

   _

   DETAILS DS is chosen as the datasource.
   

...

1. 
   Image Added
   
   

2. Click the Pre Hook Procedure DS field and select the datasource for relevant stored procedure datasource.
   

...

1. 
   Image Added
   
   
2. You can also set the default procedure parameters for filtering data by clicking the Default Configuration tab.
   

...

1. 
   Image Added
   
   
2. Click the Procedure Parameter icon and a Procedure Parameters Configuration window appears.

Image Removed

1. Set Parameters option to define the procedure parameters for the report..
   
   Image Added
   
   
2. In the Procedure Parameters Configuration screen, provide the appropriate values for the listed procedure parameters.
   

...

1. 
   Image Added
   
   
2. Click outside the window Save to save the provided procedure parameter values.
   
   Image Added
   
   A toast message with a success

...

1. info is displayed on the screen.
   

...

1. 
   Image Added
   
   
2. Click Save to save the configurations for the report.
   

...

1. 
   Image Added
   
   
2. Generate Access the report at Sigma. relevant report (e.g. Summary Procedure Report) in Sigma Application and click the Procedure Parameters option to define the parameter values for the listed procedure parameters.
   
   Image Added
   
   
3. In the Procedure Parameters Configuration screen, define the appropriate parameter values for the listed procedure parameters and proceed to click the Save option.
   
   Image Added 
   
   
4. Click Run to generate the Summary Procedure Report in the selected PDF format. Refer Generating Simple Report in Sigma for more detailed information on generating a report in Sigma Application.
   
   Image Added
   
   The following screenshot shows the generated report with the applied procedure filters

...

1. as per the provided configurations:

Image RemovedImage Added