I am having an issue with a dashboard i am creating, when i test my dashboard in designer it seems to show the data but in the vision client, it is showing an error, has anyone seen this before ? any idea what may be causing this?
This Picture is in vision Client.
This one is in designer.
Most likely you are using a query binding instead of a named query binding. When you use a query binding, you are potentially open to SQL injection, therefore the Vision client needs to allow legacy database access enabled under project properties. I suggest you make the query a named query, then bind to that instead.