| How do I save a report as an Excel spreadsheet? |
Resolution | To export reports to a Microsoft Office Excel Workbook (.xls): - From the Reports menu of any application, select the report.
- In the Print Selection window, click Printer Setup.
- Select the Print to file check box. Click Select File.
- Browse to the folder you want to save the file and enter the file name.
- In the Save as type list, select Microsoft Office Excel Workbook (*.xls). Click Save.
- Click OK and Start.
Notes: Sometimes saving Sage 300 CRE reports as an .xls file will not be successful. You may get the error: "Invalid .xls. .xls file format is invalid" Another option is to save the report as a Plain Text (*.txt) file: - From the Reports menu of any application, select the report.
- In the Print Selection window, click Printer Setup.
- Select the Print to file check box, and click Select File.
- Browse to the folder you want to save the file and enter the file name. The file name can be the same as the current name.
- In the Save as type list, select Plain Text (*.txt). Click Save.
- Click OK and Start.
- In Microsoft Excel, open the file you saved in step 5. To view text files in the browser, select Text Files (*.prn, *.txt, *.csv) in the Files of Type list.
- The Text Import Wizard window appears. The default Original data type is Fixed width. You can preview the report in this window. Click Next to view and set additional options.
- Click Finish to open the report in Excel.
Notes: - You may need to adjust column widths, but that should be the only change necessary to view the original report.
- After you save the report to a text file, the data is static. Your data does not link in real-time as in an ODBC-connected report. If you plan to use Excel often for Sage 300 Construction and Real Estate data, you may consider the Office Connector product. Click http://www.event1software.com/product/office-connector-suite/ for further information.
- For tips on how to design a report for export as a text file in Report Designer, see Columns are not aligning when I export my report to Excel.
- MyAssistant is an add-on application that includes functionality to email reports and tables. MyAssistant tasks can be created to gather information from sage tables and send Excel worksheet. To see a demo of MyAssistant and get pricing information, contact Sage 300 CRE Support to arrange to have an associate contact you.
[BCB:156:Chat 300 CRE US:ECB]
|
|