Sales quote layout rows doubled in crystal report layout

[Former Member]

Dear All,

Sales quote layout rows doubled in crystal report layout.

In sales quote layout the rows are doubled. Even in the standard layout. If the quote contains only two rows. Then it is doubled as 4 rows in the crystal report layout.

It is happening in the particular database. Other database are working fine. I request you people to help me to overcome this issue.

Regards,

Siva

[former_member292966]

HI Siva,

This is happening because you have duplicate records returned in your query. If you are linking tables, find out which links are causing the duplicates.

Easiest way to find out is to create a new report and add 2 tables.  Add a field from each table to the Detail section.  If you get the correct number of records, add another table and field until you get the duplicates.

Once you find the link, you'll need to check to make sure you are linking properly and possibly create a record Selection Formula to remove the duplicates.

Now you can apply the same logic to your report.  How exactly depends on your database and data.

Good luck,

Brian

[Former Member]

Hi Brain,

The standard SAP B1 sales Quote layout not working in particular database. In other databases it works fine.

I downloaded from the following link https://websmp105.sap-ag.de/~sapidb/011000358700001064612009 and imported I didnt change anything in that.

Thanks & Regards,

Siva.

[former_member183750]

Please consider posting the issue to the SAP B1 forum:

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter