sfl grid number of rows

[ppbedz]

I have a sfl grid which lists employee performance totals followed by a grand total and shift totals. The user can click on an employee to exclude them from the totals. Instead of rebuilding the sfl, I read through the sfl, recalculate the totals, and update the sfl total records. My issue occurs when all of the employees from a shift are excluded. Right now, I am updating the record to blanks and it still remains in the grid. I would like to be able to hide the sfl records when there is no longer a total for that shift. I was wondering if setnumberofrows would help me, but I am not sure how to use it. Is there any way of manipulating the number of rows visible in the grid without rebuilding the sfl?

gridscreenshtots.docx

(176.42 KiB) Downloaded 52 times

Note: My "blank" rows are always at the bottom. Thank you.

[Scott Klement]

Unfortuately, setNumberOfRows() isn't what you're looking for. This routine changes the number of rows that are visible on the scrreen at one time. (approximately the same as changing the SFLPAG value in green screen.) It does not remove any rows, it just changes how many are on the screen at once.

To remove that row completely, you would have to clear the subfile and re-load it without the blank rows. So instead of 'updating' them, perhaps you'd load them into an array, clear the subfile, and then reload it from the array (without the unwanted rows.)

[ppbedz]

Thanks, Scott. I figured that might be the case. Any chance of a future enhancement to allow individual rows to be hidden, or perhaps allow variable row heights/column widths? (I could have compressed the rows I did not want to show). Have a nice weekend... Patti