Grouping to show 1 employee per row

[scotton]

Okay, I have derived fields for the different rows and have queried only so the different levels are no longer there. How do I have the report group on these levels and only show 1 row per employee?
I read in earlier postings that you create one total derived field with all your fields in it. Can I see an example of this?
Thank you,

Sarah

 

[CharlesCook]

Check this out it may help...

http://www.charlescook.com/PPS/ReportSmithandADPPCPayrollforWindows-DatabaseGrouping.pps

Here are some others:

http://www.charlescook.com/PPS/ReportSmithandADPPCPayrollforWindows-SQLDerivedFields.pps

http://www.charlescook.com/PPS/ReportSmithandCSSHRizon-EverythingYouWantedToKnowAboutCrosstabs.pps

http://www.charlescook.com/PPS/UsingReportSmithtoCreateInterfaceFiles.pps

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining