?
Solved

SQL Reporting Services - Parameter not being recognized in oracle 8

Posted on 2006-04-03
3
Medium Priority
?
257 Views
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.

0
Comment
Question by:michael1174
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
pbocanegra earned 250 total points
ID: 16364971
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.
0
 
LVL 2

Author Comment

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

COMPANY_NAME.WRITING_COMPANY_NAME = ?WRITING_COMPANY_NAME

in the parameters tab, it has:

name                                   value
------                                    ------
?WRITING_COMPANY_NAME  =Parameters!WRITING_COMPANY_NAME.Value

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

Parameters:
WRITING_COMPANY_NAME
0
 
LVL 2

Author Comment

by:michael1174
ID: 16370701
Ahh, found it.. need to use a : instead of a ?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

829 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