0

Conditional Row Output

Jet Reports Historic Posts

June 30, 2017 10:30

None

Follow

I have a simple report, on one tab it shows the sales by customer

On the next tab, I want the report to be by customer- item, but only run if a customer is selected in the options filters

To simplify, I have this report to replicate the problem

I added the following formula

=IF($C$3,NL("rows","Customer","No."),"No report specified")

$C$3 is the (customer no. <> '*'), so if no individual customer is selected '*' then the rows function will not run and the text No report specified is output, if one is selected then it evaluates as TRUE and the rows function will work

However, if we select a customer in $C$3, only one record is returned, not all rows as expected

• Test Conditional Report.xlsx

• Facebook
• Twitter
• LinkedIn

8 comments

• 
  Jet Reports Historic Posts June 30, 2017 16:45 Official comment

  As you have discovered, it is not possible to place one of the replicating NL functions ("Rows", "Columns", or "Sheets") inside of an Excel IF() function.
  
  You'll want to see the knowledgebase article on Conditional Replication for information on how to accomplish what you are trying to do.
  
  I hope that helps.

• 0
  
  Jet Reports Historic Posts July 03, 2017 15:22

  Thank you, worked like a charm
  
  How did you find that one? I searched the support site but obviously used the wrong terms
  
  Regards

• 0
  
  Jet Reports Historic Posts July 04, 2017 22:26

  Let me know some the terms you searched for and I will make sure they get added to the article as tags. That way, others will have an easier time finding the information.

• 0
  
  Jet Reports Historic Posts July 07, 2017 11:25

  One issue, if we use the help link article to hide the rows by passing the blank array, when it is published to the portal it produces an error and an exclamation mark showing against the report, when you open the report, there are no errors and the second tab report is hidden as expected

• 0
  
  Jet Reports Historic Posts July 07, 2017 11:34

  Actually it appears if we run any report that would output a tab with no data, e.g. wrong filter or no sales value then the portal shows an exclamation mark and says it errored, when it did not

• 0
  
  Jet Reports Historic Posts July 07, 2017 17:01

  Could you provide a simple example that demonstrates this?

• 0
  
  Jet Reports Historic Posts July 11, 2017 11:28

  Here is an example report that you can upload to the portal, comments on filter field to show what does and does not display

  • test empty report.xlsx
• 0
  
  Jet Reports Historic Posts July 11, 2017 14:24

  Thank you.
  
  I have not been able to reproduce the issue you describe in the version I have installed.
  
  What this suggests is that, although I have not personally heard of this issue, it would appear that the underlying cause has been addressed by the Jet Development Team.
  
  Once the current beta is officially released, I would recommend updating your installation of Jet Professional and then re-test.