Selection Formula Not Working

[LouieGrandie]

Have the following selection formula:

{MasterFile.Order In} = {?Order In Range} and{MasterFile.RepName} = {?Rep} and
(NOT IsNull({MasterFile.SelectionsOwner}) and {MasterFile.SelectionsOwner} in{?Owner}) OR (NOT IsNull({MasterFile.SubmittalsOwner}) and {MasterFile.SubmittalsOwner} in {?Owner}) OR(NOT IsNull({MasterFile.CalculationsOwner}) and {MasterFile.CalculationsOwner} in {?Owner}) OR (NOT IsNull({MasterFile.LayoutsOwner}) and {MasterFile.LayoutsOwner} in {?Owner} OR (NOT IsNull({MasterFile.CheckingOwner}) and {MasterFile.CheckingOwner} in {?Owner} OR (NOT IsNull({MasterFile.RevisionsOwner}) and {MasterFile.RevisionsOwner} in {?Owner}) OR (NOT IsNull({MasterFile.PE Stamp Owner}) and {MasterFile.PE Stamp Owner} in {?Owner})))

While it filters the Reps and Owners just fine it totally ignores the date range parameter and gives me all dates and not just the date range selected. Anyone have any thoughts as to why.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[fisheromacse]

i would hazard to guess it is all about parenthesis.

try something like this:

(
{MasterFile.Order In} = {?Order In Range}
and
(
{MasterFile.RepName} = {?Rep}
and
(
(NOT IsNull({MasterFile.SelectionsOwner}) and {MasterFile.SelectionsOwner} in{?Owner})
OR
(NOT IsNull({MasterFile.SubmittalsOwner}) and {MasterFile.SubmittalsOwner} in {?Owner})
OR
(NOT IsNull({MasterFile.CalculationsOwner}) and {MasterFile.CalculationsOwner} in {?Owner})
OR
(NOT IsNull({MasterFile.LayoutsOwner}) and {MasterFile.LayoutsOwner} in {?Owner})
OR
(NOT IsNull({MasterFile.CheckingOwner}) and {MasterFile.CheckingOwner} in {?Owner})
OR
(NOT IsNull({MasterFile.RevisionsOwner}) and {MasterFile.RevisionsOwner} in {?Owner})
OR
(NOT IsNull({MasterFile.PE Stamp Owner}) and {MasterFile.PE Stamp Owner} in {?Owner})
)
)
)