Forum Discussion
Query Parameters in Paginated Report(Text Editor) against DB2 database
Hi All, We are using SQL Queries in Power BI Report builder for reports development aganist DB2 database. I am facing an issue to pass values using parameters in SQL Query. select distinct A...
I should pass only ? not ?EmployeeID. In this case, if i am going to use same parameter multiple times, it will be difficult to maintain the code. It is creating ambiguity when more than one parameter should be used multiple times.
Replacing @EmployeeID with ? worked for DB2 but it didnt suffice for the complete requirement.
JOIN(Parameters!pCategory.Value, “,”) is not working when multiple values are selected.