Add Excel Spreadsheet to the Reports List

The MAR Report screen allows for Excel spreadsheets to be attached and classed for building ODBC data connections for selected job and equipment reports.  Spreadsheets are added to the report tree using the Add button and browsing to the desired spreadsheet.  Once a spreadsheet has been added, the report class needs to be set up on the selected spreadsheet so that the proper data is built for the spreadsheet to access.  All required connection files (.DQY) and report tables will be created and copied to the user's local hard drive in the C:\AccuBuild\ODBCXls folder.  Please refer to Microsoft Excel Documentation for more information on using ODBC data connections in Excel.

Note: If you make modifications to a spreadsheet in MAR, you will need to save the modifications and then use the Add button again to add the revised spreadsheet to the MAR Report Tree.  You cannot use the Copy button on spreadsheet reports.