Page Comparison

eMACH-Sigma enables you to display the values from widgets (apps) as report filters by configuring the Linked Widget settings in eMACH-Sigma Studio.

For instance, a report by applying the linked widget filter appears, as shown in the following screenshot:



To create a report with widget columns configure the additional steps in eMACH-Sigma Studio:

1. Create an app using App Designer option in eMACH-Sigma Studio by selecting Classic Grid as the view type and drag and drop the columns from the data source into the column section. Refer /wiki/spaces/CTv21/pages/2160560085 for more information on creating an app.
   
   For example, here ACC_STATEMENT app is created using ACCOUNTSTATEMENT data source in App Designer with ACCOUNT_NO and Auth_id dragged and dropped into the column section.
   
   
   
   

2. Similarly, create a report with the same data source that is used while creating the app.
   
   

   Warning
   It is mandatory to select the same data source that was used while creating the App.

   
   

3. Click the Select Filterable Columns field and select the column(s) by which the report results are to be filtered.
   
   Image Modified
   
   
4. Click a column name from the selected filterable columns and the Linked Widget Configuration window appears.
   
   
   
   
5. Click Linked Widget lookup field and the existing apps created in eMACH-Sigma Studio appears.
   
   
6. Select the app (created in Step 1).

7. Similarly, select a column from Linked Column and Linked Description lookup fields, where the columns of the app appear.
   
   Image Modified
   

   Tip
   Click outside the pop-up window to save the Linked Widget configurations.

   
   

8. Repeat steps 4, 5, 6, 7, and 8 to link another widget to a column and its column as report filter.
   
   
   • Here, AUTH_ID column from the widget is chosen as another report filter.
   
   
   
   
9. Click the Dependency Field and choose the column for which you want to display the secondary filter drop down with respect to the column chosen in the Dependency Field.  
   
   
   
   
10. Perform the other configurations and save the report in eMACH-Sigma Studio.

To generate the report with the widget columns filters, follow the additional steps in eMACH-Sigma Application:

1. Select the required report in eMACH-Sigma Application and in Customize column, click Select Filter drop-down and the filter columns selected in eMACH-Sigma Studio appears.
   
   
2. Select a column to filter the data set and click the Select Criteria drop-down list.
   
   
3. Select the filter criteria. For example, select the in the list of option.
   
   
   • All the values of the selected filter are available in the REPORT_FILTER_LINK_IN drop-down list.
     
     
     
     
4. Select a value from the drop-down and click the  icon to add the selected filter value.
   
   
5. Repeat the steps 1 and 2 and 3 in order to select the other filter columns.
   
   The values with respect to the first filter selected will be displayed in the REPORT_FILTER_LINK_IN drop-down list.
   
   
6. Select the value from the drop-down and click the  icon to add the selected filter value.
   
   
   The following screenshot displays Authentication ID column with the value 'SYSTEM' as another report filter:
   
   
   
   
7. Perform any of the following:

• To execute the report, click Run.
  or

• To create a duplicate of the report, click Save As.
  
  
  
  

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