How does parameter binding in the HTML reporting control - when using report parameters and datasource parameters.
I have a file that works 100% in the designer - where the report parameters are linked to the datasource parameters ( FWIW - using postgres so no name parameters - they are ? in the query source).
I have 2 parameters per query... and they are bound to the Report parameters.
So each query has a section like this in the designer.
I am using the reports controller to return the report to the client... but when using the html version - the parameter binding doesn't seem to work and this i end up with syntax errors - as it looks like the ? is never replaced in the query.
The report parameters section renders fine.. and will match what i set via the parameters object.
Using fiddler i can see the post to the below URL setting my param to the values I choose..
http://localhost/reporting/api/reports/clients/cabb01e7aa1/parameters
But the query still fails with syntax error ( that doesn't happen in the designer).
I was hoping to leave "parameters" blank - since I dont want to set them independently of the reports parameters section.
If I leave it blank... the post to http://localhost/reporting/api/reports/clients/acb333b0fd4/instances shows the default parameters from the parameters area... but i still get syntax error.
We are serving the report via a custom resolver returning the actual trdx file... and it does contain the section i expect - which maps report parameter to query parameter...
I don't know how to resolve or move forward - any advise on how to resolve or what else i can post to try and assist diagnosing the issue ?
Steve