Hiding Rows

I am having an issue with hiding rows in my report. I have created a formula within the hyperblock based on a report variable and other criteria which (TRUE/FALSE). I edited my Row Properties to show or hide the row based on this formula (in this case in Y25)

When I run in view mode it doesn't hide the rows for the first two iterations of the hyperblock. I can see the "FALSE" result of the formula. It appears to be working for further iterations of the hyperblock which is what makes this very confusing. Is this a bug? Any thoughts as to why this might be occurring?

Find more posts tagged with

FAQs, How-To, and Best Practices

Comments

Legacy Contributor

Yes...I totally know that issue well. If it is the same issue I was having, it's the style sheet. I had to do two things. First, I had to make sure the report I had open and the style sheet ended in the same column. Second, I had to make sure in my report I didn't have any random formulas or anything past that column. Literally hid Ctrl+Shift+End to find the end of your report.

kdickman

Thank you Kate! How can I determine where the style sheet ends?

Legacy Contributor

Same was as the report. Open the style sheet and hit Crtl+Shift+End. You don't want any data past that point. I also (forgot to add this earlier) had to make sure the HB started in column A.

kdickman

Hi Kate - I checked the ending column on my report it goes to BB (see below) and compared to the Style sheet (Financials Default Style), which ends at column KN. Based on this it appears that my report is within the appropriate range, correct? I altered my report to make sure the hyperblock starts in column A. I am still seeing the same row-hiding issues. Am I missing anything? Any other thoughts on what might be causing this? Thanks again for your help!

dEPM-606 - 12.0.5 What's new.mp4

r11_upload_2014_sample.xls

kdickman

I figured out the issue. I had a hyperblock running horizontally. My row formula was referencing a column to the right of the hyperblock; therefore, when the hyperblock expanded it wasn't referencing the correct cell in the formula (for the first iteration). I moved my "TRUE/FALSE" formula to the left of the hypeblock and it fixed the issue. Thank you again for your response.

Copyright © 2025 Infor. All rights reserved.