Showing results for 
Search instead for 
Did you mean: 

Subreport duplicates Query

Former Member
0 Kudos

Good Day,

I am creating a Statement of Account in Crystal Report.

All are ok until I inserted ItmsGrpNam from OITB.

I have suppressed the invoices by creating a formula {OINV.DocStatus} = "C", it still generates and duplicates the invoices.

Thank you for your usual support.


Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos

Hi Florencio,

Are you inserting a sub report ? if so, where you have inserted  ? or  Are you trying to link with another table then you are getting duplicates ?  If so, it could be a join issue between both tables.

Do the following :

Go in Insert menu-- insert a group on Po_Number, drag all fields to group footer and suppress Details and group header.


If you are joining two tables, then try to change the join type to Left outer join and see how you are getting records.



Active Contributor
0 Kudos

Hi Florencio,

This indicates that there are multiple records for the field being joined on in the OITB table.

See if checking the 'Select Distinct Records' option from the Database Menu helps.

If that doesn't help, insert a group on the NumAtCard field and:

1. Move all fields from the details section to the Group Header

2. Suppress the details section.