duplicate subreport detail

[JC]

I have a report with a subreport. My main report display invoice #,
dates, customer names, etc. Main report has a group by customer id.
My subreport display only the detail line items for each invoice#.
I would like to have the subreport in the Details section. However,
when I place the subreport there,I
get duplicates invoice detail line items. There is not an option to
hide duplicates in the subreport.

Please help.... Thanks.

 

[Shelley]

What you are doing should work. Is your report set up
like this?...

Customer ID # ABC Company
Inv # 1001
Part # 123
Part # 124
Inv # 1002
Part # 456

....where the Customer ID # is in the Group Header, the
Invoice # is in the Detail section and the Part #'s are
in the sub-report. If so, check which field(s) you are
linking with on your sub-report. In this example, Link
Child Fields and Link Master Fields should be [Invoice #].

Shelley

 

[JC]

Hi
Here's how my report is set up...

Invoice # ( header, group by inv#)
ABC Company (Header)

Part #123 ( in detail from subreport)
Part #456 ( in detail from subreport)

Total of each inv#

So in my preview, I will see....
part #123
part #456
part #123(repeat)
part #456(repeat)

You mentioned Link

Child Fields and Link Master Fields should be [Invoice #], where is this property located at, I tried lookin' but couldn't find it.

Thnks.

What you are doing should work. Is your report set up
like this?...

Customer ID # ABC Company
Inv # 1001
Part # 123
Part # 124
Inv # 1002
Part # 456

...where the Customer ID # is in the Group Header, the
Invoice # is in the Detail section and the Part #'s are
in the sub-report. If so, check which field(s) you are
linking with on your sub-report. In this example, Link
Child Fields and Link Master Fields should be [Invoice #].

Shelley

-----Original Message-----
I have a report with a subreport. My main report display invoice #,
dates, customer names, etc. Main report has a group by customer id.
My subreport display only the detail line items for each invoice#.
I would like to have the subreport in the Details section. However,
when I place the subreport there,I
get duplicates invoice detail line items. There is not an option to
hide duplicates in the subreport.

Please help.... Thanks.
.