Parameter syntax for Oracle Database connection in Paginated Report

[Paramjit]

Hello ,

@SivaMani  @amitchandak  

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

[Icey · Accepted 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.

[moldepc]

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.

[cplesner]

Hi @moldepc 

Did you ever get queries to work with the option of having user input multiple parameters for ex. Customer and Country, where either might be left blank ?

[Paramjit]

@Icey  Thank you so much. It is working.

[Paramjit]

Hi Everyone,

Any help on this pls.

Thank you.