Case statements in crystal

[tc3596]

I am using Crystal 7 with MS Access 97. My access query is basically just a data dump of information. In Crystal, I have 4 parameters for the user. Whether they use one of the parameters or none of them, I need the correct data to be pulled in. In T-SQL, I can write this very easily through case statements. However, I am using Crystal 7 and I don't understand how to accomplish this same goal. Basicaly, if param1 is null then look at param2, etc... If param1 and param2 then use that. If param1 or param2 then use that. I need help with case statements in Crystal.

 

[kenhamady]

tc,

If this is a duplicate of the next post, could you red flag it for deletion?

Ken Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.