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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
What database are you using?

Where are you adding the SQL?

mlmcc
0
romeiovasuAuthor Commented:
using Oracle.  Adding for Crystal reports.
0
mlmccCommented:
What is the query trying to do?

Can you run it in Oracle?

mlmcc
0
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

romeiovasuAuthor Commented:
yes i can run it in Oracle, it is parent child relation ship, it gives the parent and child record.
0
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.