Multiple Query Sort Question

[cabrera01]

I'm currently running a report that will show me a list of all current employees off a sql server.

In this list of employees, I use a table called HRUSERFLDS
This table holds various data fields that pertain to each employee. Among these fields is the "Prev Yrs Experience" field. This field is designated by the field HRUSERFLD.FIELD_KEY = 94 and the actual value of years is listed under HRUSSERFLD.N_FIELD.

My problem is that I need to show this particular field in my list, without excluding those that do not have this particular field and value.

Can someone help me with this.

Thank you

 

[Madawc]

Do a left-outer link. Test for IsNull to identify employees who do not have the record.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Use a left outer FROM your main table TO the HRUSERFLDS, with no selection criteria on the HRUSERFLDS table. Then use a formula to display the desired results in the detail section:

if {HRUSERFLD.FIELD_KEY} = 94 then
{HRUSSERFLD.N_FIELD}

You can format the details to "suppress blank section" and also format your fields to "suppress if duplicated".

-LB

 

[cabrera01]

Thanks, that helped me out. I appreciate it.
I wanted to ask you a question. Is there a place where I can learn all the extra stuff I can do i crystal or is it just by experience.

Once again, thank you for everything.

 

[lbass]

I think the Help files are very good, and I would say between them, experimenting with the Xtreme database which comes with CR, and reading TekTips, you can learn a lot. You could also read the George Peck book and check out Ken Hamady's website and materials.

-LB