I am trying to use SSRS to connect to Denodo as a data source. The ODBC connection takes far too long to establish the connection - longer than it takes Denodo to return to data and longer than SSRS takes to render the report by an order of magnitude. ...
Has anyone tried using Power BI Report Builder (or SSRS) to access a derived view? If not, is there a way to do it, or if there is a plan to develop this feature?
I have created an SSRS report with parameters that the user inputs (using ? as parameter in the SQL). The derived view that the SSRS report is using has partial cache mode turned on with match exact queries only selected.
It seems as if the report is ...
How to create a multi-value parameter in SSRS?
In MSsql I do this sql
Select * from table1 where column1 in (@values)
But when I do the script below on Denodo
Select * from table1 where column1 in (?)
it returns error. Any Idea on how to pas...