Skip to Content
0
Former Member
Apr 10, 2014 at 05:58 PM

Use of OR operator in the record criteria

35 Views

version# crystal report XIR2

Type: cross tab

I wrote the below criteria in REPORT-> SELECTION FORMULAS->RECORD

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

//Status is CLOSED or CANCELLED

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

and

//Manager level

{table.manager_level} ="Phani Thota"

and

(

{table.cancelleddate} in lastfullmonth//Cancelled date is Lastfullmonth

or

{table.closeddate} in lastfullmonth //closed date is lastfullmonth

)

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

When i run the query the cross tab generates only the Cancelled date and ignores the Closed date date

1. The query that I wrote after the OR operator didn't read by the crystal reports.

2. If I remove the red braces then the values are becoming weird

in simple, the crystal takes only the query before the OR operator

Attachments

crosstab.jpg (125.5 kB)