Search results for query: *

It WORKED! Thank you so much. That must be the only combination I did not try.

I am testing with Oracle Please check the attached screen shots for clarification and see if that helps.https://files.engineering.com/getfile.aspx?folder=70348ed9-2cf8-407d-a712-540405b9eb88&file=Parametrs_and_command.docx

Yes, it is string. Can you please try to do the same with Xtreme Database with Customer ID and get it to work?

Yes, it does.

I did that, but posted wrong here. Sorry! select * from EMPL where ( ( {?Empl}<> 'All' and Employee_id in {?Empl} ) or {?Empl}= 'All' ) Crystal reports accepts only Employee_id in {?Empl} part, if I add anything else to this it fails.(Invalid relational Operator) With the above syntax, I got...

My original Query is too complicated. I do not want to complex the things. This is the other parameter that I need to use in the report. I am using Oracle DB. So I was testing this portion of query in the simple test report. If I can get this to work, I will plug it in my original query.

select * from EMPL where ( ( {?Empl}<>’All’ and Employee_id in {?Empl} ) or {?Empl}=‘All’ )

Yes, I am able to set the parameter to multi value. I tried the syntax but its throwing error: invalid relational operator, when more than 1 Empl ids are entered. This part of the query doesn't work together. ( {?Empl}<>’All’ and Employee_id in {?Empl} )

I have the 2011 version that does support multi-value parameters, but it's working for multiple value or 'All'. For example: Option 1: employee_id in {?Empl} I can enter as many values as I want but there is no way to enter 'All' Option 2; employee_id = (case when {?Empl} = '*' then...

Thank you so much, I played around it and finally got it it to work. But, I have another issue now. Since I have to create all my parameters in Command, I am struggling with multi select parameter that should select all the employee ids if '*' is selected. Earlier I had if {?Empl}='*' then...

Thanks for you reply, but it doesn't solve the problem. Let me try to explain again. As mentioned in the original thread, I have a parameter called Customers to include, which, if set to 'All', I don't even want to look in the table 2. If 'Current' is selected it's easy it looks for the...

Hi, I found this thread766-408341 closed thread that describes my problem exactly. Does anybody has any suggestion? Thanks in advance for any help, Shikha