Skip to main content
Solved

The "Is Null" in report designer visibility setting does not work, then how can I filter the data I want?

  • December 29, 2020
  • 3 replies
  • 1482 views

Forum|alt.badge.img+5
  • Captain II
  • 398 replies

Hello,
Thanks to Gabriel’s help. I can get the data I want in GI using a second filter.  like below:

 

  The key in the join condition is that “INitemsitehistday” might only have qty in record,no sales record

     So if “left join” used, might get a joined line with INitemsitehistday.Sdate as Null.

 

This filter out  is working well in GI.
However if I would like to apply the same kind of second filter by using the visibility section setting in report Designer. 
The “ Or [INItemSiteHistDay.SDate] Is Null” does not work.
 

 

Then can somebody help me to get the data I want in Report designer?

1, Not sold in 90 days

2, never sold, which left join get a NULL value

Best answer by BenjaminCrisman

Hi @ray20 Have you tried using something like IsNull() or INItemSiteHistDay.SDate=Null or ‘’?

 

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

3 replies

  • 2 replies
  • December 30, 2020

Hi Ray

You can try do one of the following in Report Designer:

  1. Add the two conditions to the Report Filters (Schema Builder>Filters) or, if that doesn’t work, try
  2. Add the two conditions to the Relationship Data Links (Schema Builder>Relationships) for that specific join.

Then yoiu can remove the VisibleExp condition.


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 716 replies
  • Answer
  • December 30, 2020

Hi @ray20 Have you tried using something like IsNull() or INItemSiteHistDay.SDate=Null or ‘’?

 


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • December 31, 2020

Hello, all,

([INItemSiteHistDay.SDate] = Null)   is working

So remember in Report design, should use ‘=’ not ‘is’


Reply


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