Excel integrated reports
Link or bind data from DevMan directly onto MS-Excel to create an integrated report.
Use the many features of this popular analytical tool with built-in pivot tables to create reports and save them to be reused.
Reflect changed filters or latest information in Excel by a simple data refresh.
Reports can be regularly updated by simply refreshing the data in the spreadsheet. Select the Data tab and then select Refresh all.
The steps to create an EIR are as follows:
•Create a saved search using the advanced reporter.
•Select Export or Statistics.
•Create a saved Export or Statistics selection, and then select Publish report.
•Save the published report, and then select Extract > To link.
•Copy the link. In an Excel spreadsheet on the Data tab, select the From Web button, and paste this as a Basic URL.
•Select your saved report, and then select Transform data. (For Excel help follow the link provided in the pop-up)
Detailed steps can be found in the Search and report printable quick guide.