Forum Discussion

Paramjit's avatar
Paramjit
Icon for Helper II rankHelper 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 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

Need Help

5 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    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
        Icon for Helper III rankHelper 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 ?