Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010
    Posts
    11

    Unanswered: SSRS with ORACLE

    Parameters
    Dataset:TESTVALUE
    Valuefield:CODE
    LabelField:CODE


    Dataset 1:
    Query:
    Select CODE, ACCOUNT from CIRC.SUBS_TAG
    where CODE = @Turr

    Parameters:
    ParameterName Parameter Value
    @Turr [@Turr]

    TESTVALUE(Dataset 2):
    select distinct CODE from CIRC.SUBS_TAG


    When i run the report i get "Query execution failed fro 'dataset 1' illegal variable name/number".

    I did the similar way in a different report and it worked. But now......Please help me. Thank you

  2. #2
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    You need quotes around the value your passing into the query if the column in the table is varchar2, for example:
    Code:
    select code, account
     from  circ.subs_tag
    where  code  = 'VALUE'


    Also this is another reference to using SSRS:
    SSRS and Oracle parameters SQL Server

    hth

  3. #3
    Join Date
    Dec 2010
    Posts
    11
    I fixed it thanks for the help spacebar. It was not @Turr it was :Turr. Because it is oracle.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •