Report parameter to filter to only one nurse, md, or pa

[nuttyernurse]

Good morning!

I have a report the shows incomplete fields by provider. The problem lies when there are multiple providers for one patient, it creates conflict. I want to filter the report to where it only contains one name per provider.

The data looks like this:

Nurse, Nancy;Jones, Jim L.; Keller, Helen;

or if only one:

Nurse, Nancy;;

I would like to only show the charts with one provider and eliminate those with multiples. Staff changes frequently and new staff are hired, manual selection is time consuming.Any ideas on a formula or parameter?

Thank you in advance for helping!

 

[nuttyernurse]

I made a mistake in the data for multiple providers, it should look like this:

Nurse, Nancy;Jones, Jim L.; Keller, Helen;;

Forgot the semicolon on the end!

 

[lbass]

This is not clear--Do you really only want records which contain one name, or do you want to be able to work with each name in a record individually? You can split out the names by using a formula like this:

stringvar x := replace({table.field},";;","");
stringvar array y := split(x,";");
if ubound >= 2 then
y[2] //e.g.,for the second name in the string

If you really wanted to just use records containing one name you could use a selection formula like this:

stringvar x := replace({table.field},";;","");
stringvar array y := split(x,";");
ubound = 1

-LB

 

[nuttyernurse]

Thank you for the reply LB!

I'm sorry I did not get back sooner but I was on holiday!

What I want to do is eliminate the records with more than one name, so I would only have records with only one provider. The reason for this is simple, if more than one provider is using a record, it is harder to pinpoint who should have completed what. By only having records with one provider, all responsibilities go to the one person.

SO how can I tell crystal to only give me the records with only one name in the provider field?

Thanks again!

 

[lbass]

I showed you how to do that in my original post. I don't understand why you would simply ignore other records though.

-LB

 

[nuttyernurse]

LB,

I tried the formula and it worked like a charm!!!! Thank you very much it will same me a ton of time as I was manually filtering for single providers.

The reason if you really want to know is we do individual reports on charting practices, if more than one provider is listed, then the blame game begins, each person saying the other should have charted that. We don't ignore the other data, we use it in an overall report for charting compliance, this report is individualized and fast thanks to you!

Thanks again!