Introduction
This Post illustrates the steps required to Insert Run functionality is used to return the sum, count, max, etc. for the datapoint(columns) in the E4A Report. The value will be returned in the cell once the calculation is performed. If the ReportReport is defined to run for the specific parameters, then the Insert Run report calculation can also be made to run for that parameter.
How to Create an Insert Run Report
Go to Excel for Apps Responsibility and click Insert Run Report.
List of Reports will be displayed. Select the Report where we need to create Insert Run functionality.
For example if we need to count the number of Employees in the report, Select the Report output and click on any cell in the header section. Then Click “Insert Run Report”. The below screen will be displayed
Now click Next and then add the Filters required for the Count Operation to be manipulated. Users can enter upto 10 filters. The filters will also be applied as in the report or also for the parameters not defined in the report.
Add the filters and then Click Finish. The formula will be calculated and displayed in the cell.
Summary
This Post described the script Insert Run Report Feature in ExcelforApps in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gamil.com or use the comment section below to ask your questions.
