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
-- 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