Report Designer - allowing blank fields

Userlevel 1

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.



Best answer by Laura02 18 July 2023, 15:33

View original

2 replies

Badge +18


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!


Userlevel 1

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

Thanks very much.


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