Using Nevron Chart for Sharepoint 2012 Vol1. I notice the new feature for database properties which can be configured with expressions.
I want to pass a parameter to the SQL Command for a chart connecting to a Database Data Source. So something like
Select col1, col2, col3
where table1.userid = Params![UserId].STR
However it doesnt work as the query parser throws an error
Error:Cannot connect to data source. Eroor was:Invalid column name 'Params![UserSid].STR
Is there not some form of parameter expansion done before the SQL is passed to the query parser ? I've tried a variety of ways of specifying the Params![UserId].STR (in quotes / double / single etc.)
How do I get one of these pre-defined parameters passed to my query ?