Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello ,
I am trying to pass the parameter in Oracle SQL in pagianted report using Oracle Database conneciton. But i am getting missing expression error or syntax errors. where ABC = @ParameterName
the expression is working with ODBC conneciton (preview).
Could you please help me with the correct paramterter expression with Oracle database.
Thank you,
Paramjit
Solved! Go to Solution.
Hi @Paramjit ,
Please use ":" instead of "@" like so:
where ABC = :ParameterName.
SQL Server uses an @ sign for the parameters, but Oracle uses a : (colon) to prefix it’s parameters.
Reference: defining oracle query parameters - Report Designer (SSRS) (microsoft.com)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Paramjit ,
Please use ":" instead of "@" like so:
where ABC = :ParameterName.
SQL Server uses an @ sign for the parameters, but Oracle uses a : (colon) to prefix it’s parameters.
Reference: defining oracle query parameters - Report Designer (SSRS) (microsoft.com)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there a way to pass multiple parameters? So I want to do a direct query to the Oracle database through Paginated reports but I want the user to be able to query on Order Number OR Customer name or both. I got it to run but it returns no results because if I enter an Order number but not a customer name, it sends null to the customer name and then returns no results for the query because the customer name is populated for that order number I tried to lookup. Thanks.
Hi Everyone,
Any help on this pls.
Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |