selection expert 1

[rubberhead10]

I am tring to do a report that has three fields. the first two fields are first name, last name the last field is a health insurance field that has numerous codes. I have used the selection expert to pull out the codes that I want and that works fine. but what I need it to do is to list the first name and last name of employee that do not have any of the selected codes along with the ones that do have the selected codes......Thanks for your help I dont know what I would do without this group

 

[synapsevampire]

Well you can't filter out data and then say but show me the data I filtered out.

This assumes that "I have used the selection expert to pull out the codes that I want" means that you are filtering for only those codes, pulling out codes is a tad unclear.

Perhaps you should give an example of what you intend as output, along with other basic technical information, such as your software version and the database used.

-k

 

[rubberhead10]

Ok I will try to be a clearer.

in my report i have three fields the first two fields are first name and last name. the third field is a insurance code that describes the type of coverage an employee has. I need my report to list the employees first name and last name even if they do not meet the insurance code I am filtering for. this way I can see that they do not have any insurance....Thanks for your help......

 

[Kendel]

In the filter, you also need to include those who have insurance code = "" or null.

 

[synapsevampire]

OK, remove the criteria for the codes and you'll have all of the people.

Then you can deomnstrate which people have those codes by using a highlighting formula or some such, as in:

if {table.code} in {1,2,3] then
cryellow
else
crwhite

I asked for this:

Perhaps you should give an example of what you intend as output, along with other basic technical information, such as your software version and the database used.

If it's too much effort to post basic technical information, expect slow, bloglike solutions as we slowly extract your requirements...

-k

 

[rubberhead10]

Thanks for the help

 

[synapsevampire]

Kendel: How could including blank or null account for the requirement of " if they do not meet the insurance code I am filtering for".

They may have other codes in there, just not the ones of interest, and if they have tables joined using a Left Outer and adding criteria to the child table then that won't work either unless you can get it into the SQL using a Command Object or some such.

-k

 

[Kendel]

I thought he wanted to display those who have certain insurance code and those who don't have insurance as well. By "don't have insurance", I assume they "insurance code" is blank or empty.

 

[rubberhead10]

there are codes in the field that are not health insurance codes they are codes for dental insurance and life insurance. I am using crystal reports 11 on a betrieve data base. I think what I am looking for is if the field does not meet the criteria then fill in the field value as "no coverage" but I am not savy enough to write the formula for this

 

[dgillz]

If {YourField} in ["A","B","C"] then {YourField} else "No coverage"

Replace "A", "B" and "C" with the valid values you want to test for. Add as many more as you likeseparatingeach with a comma.

Then remove the test for this field in the record selection formula.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown