Hello!
I have a report with a conditional Hide or Show on each row.
When I run the report for the first time (after any changes are made and the report is saved), the Hide/Show logic works beautifully.
But each subsequent Refresh of the report creates extra rows beginning where the end of my report should be. Row 574 should be the last row of my report, and A574 has =IF($D574="","Hide","Show"). The report should end there, but it continues… A575 now has =IF($D575="","Hide","Show")+Auto. What is the +Auto? Why is this happening?
My 18 page report turns into a 26 page report the second time I run it, and then a 34 page report the third time I run it, and then a 46 page report the fourth time I run it….
Thanks for any help!
Date
Votes
4 comments
-
Jet Reports Historic Posts Problem solved! I guess the conditional Hide/Show doesn't belong in column A.
I inserted a column B with Hide+? in B1. Then moved the conditional Hide/Show to column B.
It works perfectly now.
I hope this is helpful to at least one other person! :D -
Mulki, Agoes Hi,
Can you help me workaround to hide row
-
Harry Lewis To hide a row, place the HIDE keyword in column A for that row. If using Conditional Hiding, you would place it in column B (with the keyword HIDE+? in cell B1).
-
Mulki, Agoes Hi Harry,
thanks it's works
Please sign in to leave a comment.