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