Record Selection Problem

[creyes]

I have two tables that have the same info:
{NATURE OF CALL #1} = "290" OR {NATURE OF CALL #2} = "290"

The above formula in Select Expert gives me what I want - all cases classified as 290. The problem comes in when I want to apply more filters:

and {INVOLV} = "SUS" and {FINAL STATUS} = "OPEN"

The last two filters don't work, and depending on how I reorganize the formula sometimes the first doesn't work either. However, when I delete OR {NATURE OF CALL #2} = "290", the whole formula works fine. I have created a subreport for Nature of Call #2, but it seems like I shouldn't have to do that.

 

[rosemaryl]

Dear Creyes:

Try formatting your formula as follows:

{INVOLV} = "SUS" and {FINAL STATUS} = "OPEN"
and
({NATURE OF CALL #1} = "290" OR {NATURE OF CALL #2} = "290&quot

I hope this helps,

ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[creyes]

Nope - didn't work

 

[rosemaryl]

Dear Creyes;

OK. How do you have these tables linked?

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[creyes]

Nature of Call #1, Nature of Call #2, and Final Status are all part of a larger table (called InMast) - Involv is part of a larger table (called Pers) and I have linked InMast and Pers by Case Number.

 

[rosemaryl]

Dear Creyes,

Please cut and paste your Select formula and the SQL Query

(Database/Show SQL

The reason I am asking, is that I just did a test here with my data and it works, so I need to see how you have it formatted.

Thanks,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[creyes]

{MP_INMAST_VIEW.FINAL_STATUS_G} = "OPEN" and
{MP_INPER6_VIEW.INVL_G} = "SUS" and
{MP_INMAST_VIEW.NATURE_OF_CALL_G} = "290" OR
{MP_INMAST_VIEW.NATURE_OF_CALL2_G} = "290"

 

[rosemaryl]

Dear Creyes:

It was what I thought. Notice in my post of the formula below that the "OR" statement is enclosed in parens. I put the parens on separate lines so it stands out. The parens are necessary!

Please try it this way (just cut and paste:

{MP_INMAST_VIEW.FINAL_STATUS_G} = "OPEN" and
{MP_INPER6_VIEW.INVL_G} = "SUS" and
(
{MP_INMAST_VIEW.NATURE_OF_CALL_G} = "290" OR
{MP_INMAST_VIEW.NATURE_OF_CALL2_G} = "290"
)


This should work, let me know,
ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[creyes]

IT WORKED!!! Thanks so much - it's been driving me crazy for weeks.

 

[rosemaryl]

Dear Creyes,

You are very welcome,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.