Conditional Link to the table in Crystal Reports 2011

[sgoyal11]

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

 

[lbass]

My current version (CR XI) does not allow multivalue parameters in a command, so I can’t test this. I also don’t currently have access to an Oracle database, and Xtreme is an Access database, which sometimes behaves differently. Were you testing this with the Oracle? Or with Xtreme?

I don’t understand why you would get multiple results without the ‘all’ clauses, but only single ones with. Maybe you can verify that again. Make sure you are testing with oracle.

-LB

 

[sgoyal11]

I am testing with Oracle
Please check the attached screen shots for clarification and see if that helps.

 

[lbass]

Try this:

select * from EMPL
where
'All' in (?Empl} or
Employee_id in {?Empl}

-LB

 

[sgoyal11]

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