web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Reporting Issue

(0) ShareShare
ReportReport
Posted on by 1,348
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

I have the same question (0)
  • Cynthia Audain Profile Picture
    1,348 on at

    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.

  • manuel vela Profile Picture
    440 on at

    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

  • Verified answer
    Cynthia Audain Profile Picture
    1,348 on at

    Thanks Manuel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans