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
