For a report based on SQL Query with parameters when Report Settings are applied - parameter value changed - SQL Query gets changed and line breaks (plus adjacent spaces) get cut out. This will often result in query syntax breaking, report not returning any results and an error message displayed about incirrent syntax.
Incorrect syntax near '>'.
When query parameters are changed, query gets reapplied but line breaks and adjacent spaces get cut out. For example:
SELECT * FROM ReportProcess rp
INNER JOIN Task t ON rp.SessionID=t.SessionID
WHERE t.IsCompleted = @Complete
SELECT * FROM ReportProcess rpINNER JOIN Task t ON rp.SessionID=t.SessionIDWHERE t.IsCompleted = @Complete
Symantec Engineering is working on the issue.
Remove line breaks manually from the query before pasting it into query field i.e. put entire query in one line.
For a report based on SQL Query with parameters when Report Settings are applied SQL Query gets changed and line breaks cut.
Subscribing will provide email updates when this Article is updated. Login is required.