Grouping?

[jd1]

I have a report similar to below that reads in data from a stored procedure

------------------
Employee Name
Employee Address Line 1
Employee Address Line 2

Qualifications Details

Publications Details
------------------

There can be numerous qualifications per employee and there can also be numerous publications per employee.

(So if 'Bill' has 2 qualifications and no publications 2 records are returned:
Bill Acacia Road B.Sc
Bill Acacia Road MA

if Bill adds 2 publications I get
Bill Acacia Road B.Sc Book A
Bill Acacia Road B.Sc Book B
Bill Acacia Road MA Book A
Bill Acacia Road MA Book B

I report on more than one employee. None of the information above can go into subreports as it is a subreport itself.

Any help appreciated..

 

[kenhamady]

That happens becauses of the fact that you have 2 different one - to - many relationships. Typically you would use subreports to solve this problem. You could also rewrite the SP so that there was a union query to append the records, instead of joining them.

You could also try a couple of cross-tabs that return the 'maximum' of the detail values for each publication.

Or you can try conditional suppression to suppress the duplicates of each group.

Is there a unique identifier for the records in each detail table?
What fields are you printing from the each detail table? Ken Hamady

http://www.kenhamady.com/

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