I typed "Hide" in a column and Refreshed and my column is still showing. I have Auto+Hide+Values in A1. Any suggestions? I have used the Hide feature and it has worked before.
Thank you, Sandra
Date
Votes
6 comments
-
Jet Reports Historic Posts Official comment Aaah now I understand your confusion. You are using NL(Table) in this report and you can't hide columns created as part of an NL(Table) function. You could convert this to use NL(Rows) and NF functions and then easily hide the column, but you can't do it when using NL(Table). This is because NL(Table) expands a Jet function which is in a single cell to create both the columns and the rows it uses. Thus whichever column you hide in design mode will get moved over to the right when the NL(Table) function gets expanded. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Hi Sandra,
Did you type Hide in Row 1 of the column?
Regards,
Hughes -
Jet Reports Historic Posts Hi Sandra,
Did you type Hide in Row 1 of the column?
Regards,
Hughes
Hi Hughes,
Yes I typed it in Row 1 and the column I want to hide.
Thank you,
Sandra -
Jet Reports Historic Posts Hi Sandra,
First, if you type Hide in Row 1 of a column and run the report, it will automatically insert Auto+Hide into cell A1 and move your original row 1 down to be row 2. Then the hiding won't work because Hide is now in row 2 instead of row 1. I'm assuming that's not happening to you since you mentioned putting Auto+Hide+Values in cell A1 but I just wanted to mention it just in case.
Secondly, you can't put an Excel formula into row 1/Column A which returns the word Hide. If you want to conditionally hide a row/column you have to put Hide+? in cell B1/A2 and then do your Excel formula in column B/row 2.
Lastly, I seem to recall some issue in a past version of Jet where rows and columns wouldn't be hidden correctly if there was no Jet formulas on the worksheet. I have confirmed this is no longer the case with the most recent versions, but I seem to recall it was a problem in the past. What version of Jet are you using and could this be the issue?
If none of these things seem to be the likely cause, could you attach a sample workbook where the hide is not working for you?
Regards,
Hughes -
Jet Reports Historic Posts I attached the report. I am trying to Hide the column with Case Quantity. Hope you can help.
Thank you,
Sandra -
Jet Reports Historic Posts Thank you! That would explain it.
Sandra
Please sign in to leave a comment.