Forum Discussion

Paramjit's avatar
Paramjit
Helper II
4 years ago
Solved

Parameter syntax for Oracle Database connection in Paginated Report

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 error...
Need Help
  • Icey's avatar
    Icey
    4 years ago

    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's avatar
moldepc
Frequent Visitor
2 years ago

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's avatar
cplesner
Helper III
1 year ago

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 ?