Unable to save a report as a spreadsheet when using Google Chrome if the report name contains a comma
search cancel

Unable to save a report as a spreadsheet when using Google Chrome if the report name contains a comma

book

Article ID: 227485

calendar_today

Updated On:

Products

IT Management Suite Asset Management Solution

Issue/Introduction

When trying to run a report and use the "Save As > Spreadsheet" option nothing happens. The same things happen if trying to save as an HTML file or an XML file. 

This has been see with both default and custom reports. For example: "Assets by Type, Status, Department, Cost Center, and Location" or "Machine Names, OS, Build, Model & Serial Number".

There have been no issues seen on all other reports.

Steps to duplicate this issue:

1. Go to Reports>All Reports>Service and Asset Management>Assets>"Assets by Type, Status, Department, Cost Center, and Location" report
2. Click on "Save As>Spreadsheet"

3. Select "Include parameters" and "Save All" options

4. The report should be saved as a CSV file (it should be saved in the "Downloads" folder since that is the default location that Chrome uses) but nothing happens. The report is not saved as a file.

5. If you try the same steps with Internet Explorer, you should see the prompt asking if you want to save the file.

 

Environment

ITMS 8.5 RU4, 8.6, 8.6 RU1

Cause

This is a known issue. The problem is related to the report name and how Chrome handles certain characters. If the report name contains a "comma", Chrome cannot trigger the Save option as needed.

See for more details  https://stackoverflow.com/questions/13578428/duplicate-headers-received-from-server

 
Also, this has been observed with other browsers like Microsoft Edge.

Resolution

A fix for this issue is included in the following ITMS 8.6 RU2 release.

Current workarounds are:

  1. Use Internet Explorer to save the report as a "spreadsheet"
  2. Clone the default report and save it under a different name without the comma (",") or if it is a custom report, rename the report without the comma (",") in its name