Skip to main content
Solved

Report Designer

  • November 26, 2020
  • 7 replies
  • 1021 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:

https://community.acumatica.com/reports-and-generic-inquires-83/how-to-hide-section-in-a-report-with-a-subreport-when-subreport-is-empty-139

 

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

7 replies

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

Hello, could you please illustrate your issue with screenshots?


Forum|alt.badge.img
  • Author
  • Freshman II
  • 20 replies
  • December 2, 2020
Irina wrote:

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 Support Analyst
  • 518 replies
  • Answer
  • December 2, 2020

Forum|alt.badge.img
  • Author
  • Freshman II
  • 20 replies
  • December 2, 2020
Irina wrote:

i’m not allowed to view the article


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 518 replies
  • 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
  • 20 replies
  • December 2, 2020
Irina wrote:

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 Support Analyst
  • 518 replies
  • December 2, 2020

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


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