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