cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Crystal reports with a parameters

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Kalika,

In the Command Object's windows, you should see an option called 'Create'. Click this button to create a prompt and check the option 'Allow Multiple Values'.

You can then modify the SQL as:

SELECT Name, taskid, parentid, levelnumber, creator, userparameter2, Usercomment from TASK

Where Name IN ({?Prompt_Name})

-Abhilash

Former Member
0 Kudos

getting an error Malformed SQL92 string at position: 107. Expecting "=" got "n"