AnsweredAssumed Answered

Report runs in designer but fails on server

Question asked by Dean Flinter on Dec 19, 2017
Latest reply on Feb 16, 2018 by Dean Flinter

Just wondering if anyone has come across this before?

 

I have a report that runs perfectly in Report Designer but when I try to run it on the server I am getting a failed at query error

 

I know that suggests an issue with the query but if I take it out and substitute the parameters for actual values it runs fine in workbench

 

Thinking something might be up with the parameters I then did the same in the report itself so it is effectively just running a straight query against the database, yet the error is the same

 

I'm running ver 5.4 in case that helps

 

Any ideas?

Outcomes