Hi
I'm sure this is Jet 101 but I can't work out how to hide columns in a report. I have two columns that I want to add together so I've added a third column with a formula that does that. These two are now extraneous for the purposes of reading the report and I want to hide them.
How do I do that? (I've tried typing "Hide" at the top of the columns - it's clearly not that simple…)
Report attached in both design and report mode. The columns I'm trying to hide are "Purchase Amount (Expected)" & "Purchase Amount (Actual)"
Cheers
Matthew
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Hi Matthew,
Well I looked at the problem again and sadly it looks like I made a mistake. Columns from NL(Table) cannot be hidden this way (unless it's the first column in the table which is why I thought that it worked). Now I actually don't think it's possible to hide columns generated by NL(Table). So the only other solution to getting rid of those 2 columns is to actually change the formula which adds them together to a calculated formula which retrieves them and does the calculation. Then we can just remove them from the report entirely. This is a little more complicated (and potentially could run a little slower), but I think it will work. I am attaching the report with this change. Does this work?
Regards,
Hughes -
Jet Reports Historic Posts Hi Matthew,
Because the NL(Table) formula expands all the columns, you can't just use a static Hide keyword in row A of the column. If you were to unhide rows 12 of 13 you would see what I mean. The formula in D14 actually expands into the entire table, which pushes out everything in columns to the right of column D.
Fortunately, you can accomplish what you're trying to do with a conditional hide. In order to do this, put Hide+? in cell A2, then you can put formulas in row 2 in the column you want to hide which will hide that column if they return the keyword Hide. So in this case, I created a formula in cell D2 which returns Hide if the value of D14 is either Purchase Amount (Actual) or Purchase Amount (Expected). I'm assuming those are the 2 columns you wanted to hide; it should be easy to modify if they aren't. I'll attach the report with these modifications. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes
I've tried running it with this formula but it doesn't hide the columns.
I tried modifying the formula thus:
=IF(OR(D14="Purchase Amount (Actual)")*OR(D14="Purchase Amount (Expected)"),"Hide","Show")
and thus:
=IF(OR(N14="Purchase Amount (Actual)",O14="Purchase Amount (Expected)"),"Hide","Show")
But no joy. what am i doing wrong?
Matthew -
Jet Reports Historic Posts Oh that's very elegant!
Thanks Hughes, that works beautifully!
I'll be using that in a ton of other reports too!
Cheers
Matthew -
Manish Patel Hi All
I'm bringing up this old post because it seems to explain exactly what I'm trying to achieve. I've built a table and I want to hide one of the columns. The only reason the column is there, is because the value is used with a formula, but it doesn't need to be visible.
Column K, the column in the table called "Discount %" is the one I'm trying to hide. When I run the report, it actually shows in column J.
I would love to see the attachment that Hughes added to this post, but for some reason I cannot access it. I've logged in but I get an error saying "ERR_TOO_MANY_REDIRECTS".
Thanks in advance for any help anyone can shed.
As I mentioned, the responses above explain what I'm trying to achieve. I'm just having a hard time visualizing how I can make it work.
Manish.
Please sign in to leave a comment.