Subreport duplicates Query

[Former Member]

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.

Florencio

[former_member205840]

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.

Or

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

Thanks,

Sastry

[abhilash_kumar]

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.

-Abhilash