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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping separately

Status
Not open for further replies.

tekniks

Technical User
Jun 27, 2003
98
US
I have the following information displayed like this:
-- GH3a(Group by Material_ID)

Material ID: Description:

FM3051-1-1 STANDARD PLACEBO CAPSULES #1 BLUE (LACTOSE), BULK
FM3806-1-1 SCH 420814 CAPSULES 25 MG/CAP, #1 BLUE, BULK

Lot: Recertification Date: Expiration Date:

78012-104 13Nov2005 13Nov2005
75239-120 21Sep2003 21Sep2003

-- GH3b(Group by Material_ID)

Material ID: Description:

FM3051-1-1 STANDARD PLACEBO CAPSULES #1 BLUE (LACTOSE), BULK
FM3806-1-1 SCH 420814 CAPSULES 25 MG/CAP, #1 BLUE, BULK

Lot: Recertification Date: Expiration Date:

78012-104 13Nov2005 13Nov2005
75239-120 21Sep2003 21Sep2003

I want the info to be displayed like this, instead:

Material ID: Description:

FM3051-1-1 STANDARD PLACEBO CAPSULES #1 BLUE (LACTOSE), BULK

Lot: Recertification Date: Expiration Date:

78012-104 13Nov2005 13Nov2005


Material ID: Description:

FM3806-1-1 SCH 420814 CAPSULES 25 MG/CAP, #1 BLUE, BULK

Lot: Recertification Date: Expiration Date:

75239-120 21Sep2003 21Sep2003

The information in the (Material ID -Description) and (Lot - Recertification Date - Expiration Date) is coming from 2 different sub-reports.

How can I acheive this?
Your help would be greatly appreciated.

Other Details: CR 8.5

Thanks

Tek
 
Try to avoid subreports, the performance can be horrendous.

Try posting technical information:

Crystal version (you did)
Database/connectivity used
Example data
Expected output (you did)

It sounds like you haven't linked the subreports via the material ID.

Right click each and select change links and select the material id as the link from each report.

Place the subreports in the group header or footer.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top