duplicate subreport detail

  • Thread starter Thread starter JC
  • Start date Start date
J

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.
 
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
 
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.
Click to expand...

Thnks.





Shelley said:
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.
.
Click to expand...
Click to expand...
 
Back
Top