Skip to main content
Answer

Report Designer - allowing blank fields

  • July 18, 2023
  • 2 replies
  • 108 views
A
Freshman II

The below image is an except from a customer shipping report listing products shipped on a particular date.

I added a new column for Client SKU =[CSAnswers.Value] which works exactly as I need with one exception…

If a product does not have an Client SKU, it is not included in the report...the row is omitted.  It seems the report only includes the row if all fields are present and I would like to flag this field as optional so the row is included regardless of the presence of a value.

None of the properties seem to correlate to that behavior and I’ve been unsuccessful in finding any clues in the forum.  I’m sure the answer is simple but I’m at a loss for the right keywords to locate a solution.

Any help appreciated.

Thanks

Best answer by Laura03

Hello,

Usually when results of a GI show us too many records (duplicates) or too few, the problem is the JOIN on the two tables/DACs. 

Try using a Left join to connect to the table that holds the Client SKUs (not Inner join).

 

If that doesn’t work, please Show Us your joins.  Thanks!

Laura

    Laura03

    2 replies

    Laura03
    Captain II
    Forum|alt.badge.img+19
    • Laura03
    • Captain II
    • Answer
    • July 18, 2023

    Hello,

    Usually when results of a GI show us too many records (duplicates) or too few, the problem is the JOIN on the two tables/DACs. 

    Try using a Left join to connect to the table that holds the Client SKUs (not Inner join).

     

    If that doesn’t work, please Show Us your joins.  Thanks!

    Laura

    ~ Laura Barber, WM Synergy
    Chris Hackett
    A
    Freshman II
    • Arran
    • Author
    • Freshman II
    • July 19, 2023

    Thanks, that was it...a left join was required. 

    Thanks very much.

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved