SQL Reporting Services - Parameter not being recognized in oracle 8

Posted on 2006-04-03
Last Modified: 2012-05-05
I setup the paramters via the report menu (via the file menu) and in the datasource parameter tab.  I also add in my sql in the where clause:

fieldname = @parameter_name

but everytime i run the report, i get an ora-01036 illegal variable name/number.

Question by:michael1174
    LVL 4

    Accepted Solution

    into the TAB "DATA"

    Write your SQL, in the where clause write your parameters with "?"

    In the Top of TAB "DATA" where dataset name appears, there is "..." button. Press it.
    Then start new form and press the parameters TAB.
    In this form, associate the "?" with the Parameter value.
    LVL 2

    Author Comment

    Still can't get this working still.. in my SQL statement, my where clause has this:


    in the parameters tab, it has:

    name                                   value
    ------                                    ------

    In the reports menu off of the file menu, it has:

    LVL 2

    Author Comment

    Ahh, found it.. need to use a : instead of a ?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how the fundamental information of how to create a table.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now