I have used the Jet reports Aged Accounts Receivables to create a report which only shows the Customers with outstanding invoices over 60 days. Of these customers all invoices should be reported. I have used the conditional Hide (in Dutch "hide" ="verbergen" en "show" = "tonen") function. Somehow the hide function is not doing what I expect to do: it is hiding some rows which should be shown in the report.
In the paint example you can see that row 26 is hidden, while it should be shown.
I have also attached the original report.
How can I use the conditional hide correctly?
Saskia
Date
Votes
4 comments
-
Jet Reports Historic Posts Could you please provide a copy of the report in Viewer Mode (after it has been run)
it may be when your rows is copied down that the formula is referring to somewhere else.
-Bromy -
Jet Reports Historic Posts I have uploaded the report after running it. For example lines 61-68 are hidden, while they should be visible. The conditional hide is referring to the wrong cells, but I do not know how to adjust it.
Best regards,
Saskia -
Jet Reports Historic Posts What has happened is the "Rows" in E23 is copying down the formula after the rows have been inserted.
if you refer them Upwards that should fix it.
ive attached an updated copy of the report,
ive changed the Formula in B
B22 now has =IF(SUBTOTAL(9,$P22:$P26,$Q22:$Q26,$R22:$R26,$S22:$S26)<1,"verbergen","Tonen")
while the 4 cells below them now have =B22, =B23, =B24, =B25
These 4 cells will just plainly mirror the above formula rather than re-calculating is.
Please test the report and let me know if it works.
-Bromy -
Jet Reports Historic Posts Thnx! It's working!
Please sign in to leave a comment.