Reporting Issue

(0) Share

Report

Posted on by Cynthia Audain

1,280

Hi:

Could someone who knows about crystal reporting assist me with this issue. I will be thankful for any guidance in this issue.

The issue is, on the picking list, client wants to bring on the manufacturer lot serial number on the report. However, in seeking to adjust the report the fields were brought on from the SoShipLot table because it is not in S040600_wk table. The fields were the LotSerNbr and the field that house the manufacturer number. However, I am seeing the information the report but it is showing in duplicates.

When I look at the S040600 table, I am seeing where the records are showing in duplicates but I am not pulling the information from that table. I am pulling the fields from the SOShipLot table which is not in duplicate.

Could you assist in advising the best way that I could bring the field on to the report without it showing as duplicates? I tried looking at the links but it does not bring me closer to resolving the issue.

Thanks in advance.

*This post is locked for comments

All responses (3)

Answers (1)

Verified answer

Cynthia Audain 1,280 on at

Like (0)

Report

RE: Reporting Issue

Thanks Manuel
manuel vela 438 on at

Like (0)

Report

RE: Reporting Issue

Hi Lisa maybe this can help. this is a very new custom report from SL (Since july5 2015). you can download from this link

https://mbs.microsoft.com/customersource/LatinAmerica/SL/downloads/reports/sol_reportslibrary

40660BO.zip
Cynthia Audain 1,280 on at

Like (1)

Report

RE: Reporting Issue

All, just an update, I was able to resolve this issue with a workaround by using some suppression formulae. All the links were correct on the report so I did not have to adjust the links.