Skip to Content
0
Former Member
Apr 14, 2014 at 09:57 PM

Advanced level of using OR & NULL operator

58 Views

crystal reports XIR2

to generate cross tab

Folks,

thanks for the answer

to the above above query link, i need to add one more query with OR operator.

problem# i was unable to generate the combination of

QUERY1 or QUERY2

======================================

(

//Status is CLOSED or CANCELLED //Query1

{table.status}= ["Closed","Cancelled"]

and

//Manager level

{table.manager_level} ="Phani Thota"

)

OR

(

{table.manager_level} ="Phani Thota" //Query2

and

(

(isnull({table.closeddate}) and {table.cancelleddate} in lastfullmonth)

or

(isnull({table.cancelleddate}) and {table.closeddate} in lastfullmonth)

or

{table.cancelleddate} in lastfullmonth

or

{table.closeddate} in lastfullmonth

)

)


==============================================

1. I was unable to apply ISNULL() in the QUERY1

2.Query2 is perfect, no need to change