The variable to control sub report visibility does not work when exporting to EXCEL, while it is working on Screen and PDF

  • 19 June 2021
  • 1 reply

Userlevel 5
Badge +2


       I’ve met an issue in 2020R2 as below:


I created a Variable named FN to control the sub report visibility.
If $FN=0, would display sub report “FNNOW”,

if $FN>0, would display sub report  “FN”,


As math tells, the two conditions above can not be both true at the same time


It is working as expected when showing on screen or export to PDF

But when exporting to Excel, both sub report are displayed at same time.


I don’t understand, is it a platform glitch?

1 reply

Userlevel 5
Badge +2


      I have two findings to add

1, I have printed the $FN out at the same time, it is 1.
So the $FN=0 should not be true. 
But the sub report is still being displayed.

2, The $FN to control the visibility of  a “TextBox” in the main report is OK. Even exporting to excel.

So my large guess is there is something wrong with visibility control of sub report when exporting to excel.


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 — 2020  Acumatica, Inc. All rights reserved