Ticket #31579
Question
I'm getting an SQL error when I run my m-Power report: "java.sql.SQLException: Must declare the scalar variable "@P0@P1@P2"."
Answer
The problem with his Filters. Customer had a constant-value Filter over an alpha field where he wrapped the constant value he was filtering against in single quotations ('valuehere'). Informed him to omit the single quotations when creating a constant-value filter. At runtime when the report is executed, m-Power will automatically add this to the query in order to encapsulate the string he's looking to filter on.
Asked on June 8, 2021