Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Query Sort Question

Status
Not open for further replies.

cabrera01

Technical User
Nov 24, 2008
15
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
 
Do a left-outer link. Test for IsNull to identify employees who do not have the record.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
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

 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top