2021 PU2 onward change of web screen report printing process in Sage 300 Cloud

2021 PU2 onward change of web screen report printing process in Sage 300 Cloud

In previous versions of Sage 300 Cloud web Screens reports were generated in preview automatically in the same browser tab. However, after installing 2021 PU2, the default Export Report screen will be loaded into a new tab in your browser. You will now have to select the export format for the report and the export file will be downloaded to your downloads folder. To print a hard copy of the report, export your report to PDF first, then print it to a printer from the PDF.

How to work with the new changes

A note of caution, follow proper backup process and have a roll back point ready before you make any of the following steps.

Now, if you do not like to choose a different format to export to each time, you can configure the Export Report function to just export the report using the default format selected, perform these steps:

  1. Find the web.config file from the \Online\Web folder.
  2. Open the web.config file with a text editor.
  3. Search for the key: ReportPromptForExportFormat
  4. Change the value to: False
  5. Save the change.
  6. Restart IIS.

If you want to change the report format to a specific format, perform the following steps:

  1. Find the web.config file from the \Online\Web folder.
  2. Open the web.config file with a text editor.
  3. Search for the key: ReportDefaultExportFormat
  4. Change the default format value 5 to the one of the format values from the list above.
  5. Save the change.
  6. Restart IIS.

Format values available:

  • 3 = Word
  • 4 = Excel format
  • 5 = PDF format (Default)
  • 8 = Excel record
  • 10 = CSV format
  • 13 = XML

Please note this feature will be added to 2020.6 (PU6) also and it is expected to be released in August 2021.

If you’d like more assistance in sorting this out, please contact us on hello@evomatiq.com