Link to home
Start Free TrialLog in
Avatar of romeiovasu
romeiovasu

asked on

Crystal reports parameter

Hi All,

I have a query where i need to pass a parameter, where the user should be able to select the multiple parameters and it should be able to give me there result

SELECT Name, taskid, parentid, levelnumber, creator, userparameter2, Usercomment from TASK
connect by parentid = prior taskid
start with taskid =
(select taskid from task where name = '05010817_job')

i am getting an error.  Can someone help me out with the query
Avatar of Mike McCracken
Mike McCracken

What database are you using?

Where are you adding the SQL?

mlmcc
Avatar of romeiovasu

ASKER

using Oracle.  Adding for Crystal reports.
What is the query trying to do?

Can you run it in Oracle?

mlmcc
yes i can run it in Oracle, it is parent child relation ship, it gives the parent and child record.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
yes, as a sql query.
It should work assuming you are connecting to the Oracle database.

Can you build it as a view in Oracle?

mlmcc
Your initial question says you want to use a parameter.  Is that the issue or does the SQL not work in Crystal?

mlmcc
sql works in crystal report when i pass an initial value.  Instead of value i wante to gived a parameter.
Ok.  WHen you create the SQL in Crystal you can click the NEW PARAMETER button and create one.   You then add it to the SQL instead of the hard-coded value.

What version of Crystal are you using?

mlmcc