...
This report enables real-time aggregation consolidation and management of inbound and outbound inventory data by month.
...
Download the sample Excel file from the Learning Experience Samples.
From the EPA main screen, go to [Menu] > [ToolsTool] and launch i-AUD Designer.
Drag and drop the saved Excel file into the i-AUD Designer window.
Ensure the report automatically resizes to fit the web browser window.
In the Properties pane on the right, check Docking: Left, Right, Bottom.
To remove the border from the report on the designer screen, set the Line Type property under Border to ‘None’.
When database data is connected, the number of records displayed on the web screen is limited to 1,000 by default. You can adjust the limit to display as many records as you need.
Data > LimitofBinding : 5000
...
In AUD Designer, double-click an empty cell in the data area and enter a number, . Verify that the value is entered and totals are calculated automatically.
- To save the entered data to the database, connect to the DB and configure the Save and Retrieve buttons.
- Go to DB Bot > DB Upload and register an execution plan.
- Enter the ‘Table Name’ and select the ‘Data Control’ containing the data to be saved. Then, columns will be automatically mapped.
- Set ‘Execution Type’ to ‘Merge’.
- The setup for saving data is complete.
- Now, let's save the entered data to the DB and set up a button to retrieve the saved data.
- Add two buttons from UI Bot > Button and place them in appropriate positions.
- Rename the buttons to distinguish their functions.
’Save’ : ‘BTN_SAVE’
’Refresh’ : ‘BTN_REFRESH’
- Use Process Bot to assign actions to the buttons.
- Once this is set up, entering data and clicking the ‘Save’ button will store the data in the database, and the 'Refresh' button will fetch the stored data.
...
- Save the completed report to My Folder.
From the EPA main screen, go to [Menu] > [Individual] in the left-hand sidebar.
Click the Search(Magnifying glass icon) button to refresh the report list and confirm your saved report.
Enter data on the web and save it to share with your team.
- Save the completed report to My Folder.
...