Hi
Yes. Excel is working as it should be, but for some reason any row that has a conditional hide formula becomes hidden. Regardless of the result of formula.
Another thing I have noticed is that Cell A1 changes from 'Auto+Hide+Values' to 'Auto+Hide+Value+Formulas,Sheet=104,sheet=126,sheet=114'. Not sure if this is significant.
Date
Votes
7 comments
-
Jet Reports Historic Posts Hi.
I have a NL Rows query to give me a list of products and then I have further queries to report on sales of these products.
Some of these products have no sales and therefore I want to hide the rows. To do this I have used the 'Hide+?' in column B along with a simple excel formula to generate the word 'Hide' should sales be zero.
My issue is that the report will ignore the Hide+? command and sporadically hide ALL rows in the report.
Has anybody encountered this issue before?
Cheers -
Jet Reports Historic Posts As a simple test, remove the "Hide+?" from cell B1 and take a look at the results of your simple excel formula in column B.
Is that formula returning what you think it's returning? -
Jet Reports Historic Posts Is your conditional formula displaying 'Show' if they are not 0, and 'Hide' if they are, or just Hide if they are 0?
E.g. =IF(C9=TRUE,"Show","Hide") -
Jet Reports Historic Posts The formula is:
=IF(SUM($G8:$L8)=0,"Hide","")
and cell B1 has the command "Hide+?" -
Jet Reports Historic Posts Try
=IF(SUM($G8:$L8)=0,"Hide","Show")
Regards -
Jet Reports Historic Posts Thanks. Tried that but sadly the same issue. Should I have the column command in B2 as 'Hide?" or "Show?".
What is bizarre is that the issue always arises the first time I run the report. Any subsequent runs the report will generate as you would expect.
This report is based on sales of a specific product - so each time I change the product code, the first report run will hide all the rows. -
Jet Reports Historic Posts Hello,
I tried to reproduce your issue, but everything is working here as expected. In the following I will summarize everything you should take int account:
- Cell B1 needs to contain "Hide+?"
- Column B needs to contain your if-statements in the relevant rows you want to hide or not, like the one you mentioned before: =IF(SUM($G8:$L8)=0,"Hide",""); you can also try to calculate the sum in a different cell to check the value and then refer to the calculated value in your if-statement
- Do you need to apply $-Signs for cells you refer to, like Cell G8 in the statement before, as the replication might move the cells (you said it hides sporadically all rows in the report…)?
If your problem persists, it would be helpful, if you could add an example report.
Regards
Please sign in to leave a comment.