Report Select Expert..

[smmedeiros]

Need guidance. I know it shouldn't be this complicated..I'm trying to pull record selections based on this formula

(not ({chgstat.sym} like "6 - Cancelled") and
{chgcat.sym} like ["Service Request.Hardware.Provisioning.*"])
or
(not ({chgstat.sym} like "6 - Cancelled") and
{Opened_by_ca_contact.last_name} like ["Da*", "Monaco*", "Murren*"] and
{chgcat.sym} like ["Service Request.*"])

so, I want all tickets that are not=cancelled, that are category name starting with 'Service Request.Hardware.Provisioning.*" OR.. not cancelled, was opened by 3 individuals and category name starts with Service Request*

Can this be done in 1 report? and if so, any ideas how?
or do i have to build a seperate sub-report for each condition?

Thanks in advance for anyone that has ideas.

 

[smmedeiros]

All set.. tired eyes.. sorry for the posting

 

[Madawc]

Are your formulas working?

If not, split into a number of boolians. One could be

{Opened_by_ca_contact.last_name} like ["Da*", "Monaco*", "Murren*"] and
{chgcat.sym} like ["Service Request.*"]

This should show True or False. Put these beside unselected data till you have what you want. Then use the formula field names in record selection.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10