Changing 'Report Settings' for a report based on 'Sql Query with Paramaters' will remove line breaks from query.

Products

• Workflow Solution
• ServiceDesk

Issue/Introduction

Changing setting - 'Report Settings' link/button at the top left of the report - for a report based on 'Sql Query with Paramaters' will remove line breaks from query, potentially breaking the query.

Varies, generally displays an error message about incorrect statement or column name.

Environment

Workflow 7.5
Workflow 7.6
Workflow 8.0
Workflow 8.1
Workflow 8.5

ServiceDesk 7.5
ServiceDesk 7.6
ServiceDesk 8.0
ServiceDesk 8.1
ServiceDesk 8.5

Cause

Line breaks are removed from the query.

Resolution

This issue is fixed in Workflow 8.5 RU1 and ServiceDesk 8.5 RU1.

Workaround:

To work around the issue, please make sure every line in the query has a space in the end. This way, when line breaks get removed there is still a space there.

Note that once you have run into this issue, IIS may need to be restarted to get the report out of non-working state even after report has the spaces added. This is because parameters state for a report is cached.