Solved

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
  • 3 replies
  • 394 views

Userlevel 6
Badge +5

Hello,

       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?

icon

Best answer by BenjaminCrisman 4 October 2021, 22:02

View original

3 replies

Userlevel 7
Badge +4

Hi @ray20 ! Currently exporting subreport data is not necessarily “supported”, per se. There are really just two options for exporting data to Excel and this is setting the Excel mode to Auto, or Manual.

Using Manual mode allows more control over the data being sent, but does not pick up subreport data at all, while using Auto mode will get the subreport data but may lose formatting applied.

 

Userlevel 6
Badge +5

Hello,

      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.

Userlevel 6
Badge +5

@BenjaminCrisman  Thank you so much for giving all this details.
Can you tell me how /where can I set the two options, “Auto” or “Manual”.
Currently, looks like I am using auto mode.

Reply


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