Simple Formula not working

[Monkeyboy126]

Hi

Can anyone tell me why the Select formula below isn't working? The database (SQL) is for a helpdesk logging problem and changes and the formula will only display closed calls (so ignores the second part of the formula)

({int_org.iorg_name} = "Company x" and {@Close Date} in MonthToDate)
or
{int_org.iorg_name} = "Company x" and {chg.active_flag}=1.00

Any ideas would be greatly appreciated

Paul

 

[dgillz]

try this:

{int_org.iorg_name} = "Company x" and
({@Close Date} in MonthToDate or {chg.active_flag}=1)


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Monkeyboy126]

Tried the formula but same results, still only showing closed calls.

The idea is to show all open calls (active flag=1) and added to this calls closed 9@close date) for the current month.

Maybe there is a simpler way??

Any ideas...

 

[Monkeyboy126]

Actually theres 3 parts to this select formula, i need:

1. a specific company (from another table)
2. Calls in an open state (active flag = 1)
3. Calls with an active flag of 0 but must of been closed in current month

Hope this defines it better...

 

[Reebo99]

Try this:

{int_org.iorg_name} = "Company x" and
({chg.active_flag}=1 or {@Close Date} in MonthToDate)

I know it looks like the formula you have already tested, but this will allow for {@Close Date} = Null.


Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[dgillz]

Please post your formula for {@CloseDate}

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

Did you try my suggestion at the end of your previous post?

-LB