Help with grouping

[Dshoaf]

I have a fairly simple report - mostly just text except for one tricky part.

I am using three tables

CompanyInfo, EmployeeInfo and PlanInfo
Each employee can only belong to one company, so that is straighforward enough. The tricky part is each Company has multiple plans and each plan has multiple revisions. (With the largest revision being the most current.) When I have had to work with revisions before, I grouped the report by revision and then put everything in the report footer. (This only pulled out the last revision.) However, when I throw EmployeeInfo into the mix, using that plan of attack only gets me the last employee. If this is not clear I want something similar to the following:


Employee1
Address
City State Zip
Plan1
Plan2
Plan3

Employee2
Address
City State Zip
Plan4
Plan5

Employee3
Address
City State Zip
Plan6
Plan7
Plan8
Plan9

Any help would be appreciated.

Thanks,
Dave

 

[kenhamady]

I think you want to group by Employee and then by Revision.
Put the employee info in the Employee Header. Put the Plan info in the Plan footer.
Suppress the other sections. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)