Using two parameters

[newbie0423]

I am writing a report where I would like the end users to be able to select their names if they were the nurses working in the OR. I would like each nurse (whether 1st nurse or 2nd nurse to be able to run the report using their names.
1st Nurse
2nd Releif Nurse


I am using two parameters.
{V_JGG_1stSurg_nur_delay_lastNUR.FirstNurse} = {?Circulator} and
{V_JGG_1stSurg_nur_delay_lastNUR.LastNurse} = {?Relief Nurse}
But this isn't returning anything. When I only use one parameter it will return data fine.

I have also tried using this formula from another post, but nothing returns with this on either. Is it possible to have two parameters with two different fields. I'm using Cystal XI

(
(
{?Circulator} = "ALL CIRCULATOR" and
{V_JGG_1stSurg_nur_delay_lastNUR.FirstNurse} = {?Circulator}
) or
(
{?Relief Nurse}= "All Relief Nurse" and
{V_JGG_1stSurg_nur_delay_lastNUR.FirstNurse}= {?Circulator} and
{V_JGG_1stSurg_nur_delay_lastNUR.LastNurse} = {?Relief Nurse}
)
)


thanks in advance

 

[Madawc]

Try

{V_JGG_1stSurg_nur_delay_lastNUR.FirstNurse} = {?Circulator} [u]OR[/u]
{V_JGG_1stSurg_nur_delay_lastNUR.LastNurse} = {?Relief Nurse}

Alternatively, if you are looking for just one nurse in either role, try

{V_JGG_1stSurg_nur_delay_lastNUR.FirstNurse} = @SpecifiedNurse or
{V_JGG_1stSurg_nur_delay_lastNUR.LastNurse} = @SpecifiedNurse

A useful trick when selection fails is to turn it into a Boolian formula field. Display it against unselected data, and it should say True or False. (Or blank if you hit a null.) This method exposes errors very quickly.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 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 Crystal 2008 with SQL and Windows XP

 

[newbie0423]

Thank you very much for responding. I used the formula below that I found in a previous post and it seemed to do the trick!

If {?Circulator} <> "" Then {V_JGG_1stSurg_nur_delay_lastNUR.FirstNurse} IN {?Circulator} Else
Not({V_JGG_1stSurg_nur_delay_lastNUR.FirstNurse} IN {?Circulator})
AND
If {?Relief Nurse} <> "" Then {V_JGG_1stSurg_nur_delay_lastNUR.LastNurse} IN {?Relief Nurse} Else
Not({V_JGG_1stSurg_nur_delay_lastNUR.LastNurse} IN {?Relief Nurse})