Skip to main content
Solved

Report Designer

  • November 26, 2020
  • 7 replies
  • 1041 views

Forum|alt.badge.img

Hello

I just encountered a problem with report designer fields
if i changed the disposition Can grow to true i get a lot of empty space between the lines even if i dont print the it when its empty

thank you

Best answer by Irina

Please refer to the following article to adjust your report:

 

7 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • December 2, 2020

Hello, could you please illustrate your issue with screenshots?


Forum|alt.badge.img
  • Author
  • Freshman II
  • December 2, 2020

Hello, could you please illustrate your issue with screenshots?

thank you for taking the time to respond

well in the screenshot below the yellow space is reserved for other values with some conditions i just want to remove all that space if the value does not  exist

 


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • Answer
  • December 2, 2020

Please refer to the following article to adjust your report:

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • December 2, 2020

Please refer to the following article to adjust your report:

 

i’m not allowed to view the article


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • December 2, 2020

I see, our Knowledge Base is available only to customers or partners with a valid contract.

Just try updating VisibleExpr for the element as follows:

=[TableName.FieldName]<>NULL

OR
=[TableName.FieldName]<>0

depending on the type of value.

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • December 2, 2020

I see, our Knowledge Base is available only to customers or partners with a valid contract.

Just try updating VisibleExpr for the element as follows:

=[TableName.FieldName]<>NULL

OR
=[TableName.FieldName]<>0

depending on the type of value.

 


i have this in VisibleExpr

(=(IsNull([InventoryItem.ItemClassID], [InventoryItem.ItemClassID])<>'COMMENTAIR') and [InventoryItem.Body]<>'')


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Platform Analyst
  • December 2, 2020

Adjust your formula according to the formulas mentioned in my previous comment.