I have created a crystal report using Command option. It returns data for all the clients for the previous month. NOw my requirement is to modify the report to take parameters such as clientcode and Monthyear and return the data based on the parameters. Here the requirement is if we choose the parameters as

clientcode = ALL

and Monthyear=NULL then it shoud return all the clients data for previous month and if we choose parameters with specific client and specific month such as

clientcode = CRV

Monthyear=DECEMBER2009 it should return only for that particular client CRV. I have tried using the below code in the selection criteria but i coudnt get the results i want. Can anybody throw some light on this. Thanks

 

code that i hav used:
{Command.PERIOD}={?MonthYear} or {?MonthYear}='NULL'
and

(
 ( {Command.CLIENT}={?Clientcode} or
   {?Clientcode} = 'ALL'
 ))

 

 

Thanks

DBlank always reminded us to do exactly that.

 

This is my thoughts on what is happening in CR that we can't see.  CR tries to compare the values, and one is NULL, this throws an error (at least it would in .Net), instead of raising the error to our attention, CR suppresses it and continues on its way.  Not very helpful to the report writer, but cuts down on issues of bad data, which I am sure are plentiful. When you check ISNULL first, CR says, look this part is true, let's not check the rest of the statement and continues on its way.

 

Just something to keep in mind, but you're right, check the ISNULL first.