"or" functionality in Select Expert Formula Editor

[Stroke]

It seems Select Expert will only alow one instance of "or" functionality in the Formula editor.

Example:

({V_RPT_PayList.LastName} like {?Last Name} and
{V_RPT_PayList.FirstName} like {?First Name}) or
({V_RPT_PayList.DomUserId} = {?User ID})

If I attemp to add an additional "or" codition like this:

({V_RPT_PayList.LastName} like {?Last Name} and
{V_RPT_PayList.FirstName} like {?First Name}) or
({V_RPT_PayList.DomUserId} = {?User ID})or
({V_RPT_PayList.OldUserId} = {?Old User ID})

When I try and enter data in the "Old User ID" prompt, I do not get data returned.

Please help.

Thanks,
John

 

[rosemaryl]

Dear Stroke,

Hmmm, I think it should be structured as thus:

(
{V_RPT_PayList.LastName} like {?Last Name} and
{V_RPT_PayList.FirstName} like {?First Name}
)
or
(
{V_RPT_PayList.DomUserId} = {?User ID}
or
{V_RPT_PayList.OldUserId} = {?Old User ID}
)


I put the open and closed parens on separate lines so that I can see them more easily.

I would also check what is getting passed to the SQL by doing a database/show sql query.

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.