peaches9531
Technical User
Hello all. I am a newer user to Crystal Reports as my employer recently went to this platform from a SQL reporting program, so I apologize if I am missing a simple solution. I am trying to write a report that will search several fields and pull data from both fields and return a response if either one or both are true. I can get my reports to work if I use each code separately but when I try and combine them it stops working. I have also tried changing the status in Formula editor to default values for null to prevent the formula from breaking if a null value is returned.
({syinvolv.relship} = "Adult Offender" and
{lwccirc.ccode} = "CONFI" and
{lwmain.agency} = "AC" and
(currentdatetime - 1) <= {lwmain.ocurdt1})
or
({syinvolv.relship} = "Adult Offender" and
{wfstat.status} = "CONFIN" and
{lwmain.agency} = "AC" and
(currentdatetime - 1) <= {lwmain.ocurdt1})
I have also tried to write both of these as formulas and insert the formula into the record selection. Both of these return non-numerical data from other tables so I am not sure how to write an if, then, else statement. I have also tried using not is null with the formulas.
Thanks for any assistance.
({syinvolv.relship} = "Adult Offender" and
{lwccirc.ccode} = "CONFI" and
{lwmain.agency} = "AC" and
(currentdatetime - 1) <= {lwmain.ocurdt1})
or
({syinvolv.relship} = "Adult Offender" and
{wfstat.status} = "CONFIN" and
{lwmain.agency} = "AC" and
(currentdatetime - 1) <= {lwmain.ocurdt1})
I have also tried to write both of these as formulas and insert the formula into the record selection. Both of these return non-numerical data from other tables so I am not sure how to write an if, then, else statement. I have also tried using not is null with the formulas.
Thanks for any assistance.