Skip to main content
Solved

Report Designer - allowing blank fields


  • Freshman II
  • 4 replies

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 Laura02

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

View original
Did this topic help you find an answer to your question?

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • 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


  • Author
  • Freshman II
  • 4 replies
  • July 19, 2023

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

Thanks very much.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings