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
romeiovasuAsked:
Who is Participating?
 
mlmccCommented:
I knew what it was just not enough Oracle knowledge to know if it was good SQL.

Are you adding that as the COMMAND as the data source in Crystal?

mlmcc
0
 
mlmccCommented:
What database are you using?

Where are you adding the SQL?

mlmcc
0
 
romeiovasuAuthor Commented:
using Oracle.  Adding for Crystal reports.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
mlmccCommented:
What is the query trying to do?

Can you run it in Oracle?

mlmcc
0
 
romeiovasuAuthor Commented:
yes i can run it in Oracle, it is parent child relation ship, it gives the parent and child record.
0
 
romeiovasuAuthor Commented:
yes, as a sql query.
0
 
mlmccCommented:
It should work assuming you are connecting to the Oracle database.

Can you build it as a view in Oracle?

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

mlmcc
0
 
romeiovasuAuthor Commented:
sql works in crystal report when i pass an initial value.  Instead of value i wante to gived a parameter.
0
 
mlmccCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.