Remove scrollbars from EpiUltraGrid

Epicor ERP 10
,
1

I have a BAQ tied to a EpiUltraGrid. It can display 1 to 50 rows. If I size the grid for 10 rows it can look right, small or blank :confused: I would like to remove the vertical scroll bars allowing the grid to expand/constrict based on the # of rows returned.

2

So really you want it to autosize, to within a min and max number of rows. And the scroll bar would only show when the number of rows exceeds the upper limit?

Or do you want no upper limit, and you’ll use the form’s scrollbar to scroll the whole forms contents?

3

Thanks for the reply. Autosize sounds like exactly what I want. Ignorant of the property. I will look into that.

4

I wasn’t trying to just point you to a specific control property. Just trying to get a better idea of your end goal. There might not even be an autosize property. You may have to programatically adjust the height after new data is retrieved (some constant + some value for row height x # of rows).

FWIW - it seems like Ultra grids are the least cooperative controls to use in customizations. Many of it’s properties are automatically changed upon receipt of new data.

For example, I think you can set the number format of a column using the Properties pane during customization. But your manual changes are overruled by the dataset.

Many customizations to grids need to be done via code, and at the right time.

5

Yeah I quickly figured out the property was not the slam-dunk I was hoping for.

Would you recommend a different kind of control? I already iterate through the query result with code summarize some columns, so I am not adverse to coding.

THanks again

6

You can control the scrollbars whether horizontal or vertical by row count or column counts and using the methods in this link.

7

@danbedwards - If you turn off a scroll bar (say the vertical one), what happens when there are more rows than fit in the grid’s height? They just get clipped off?

Can you select a cell and then use arrow keys to “scroll” down to see the clipped rows?

8

You can do it by knowing how many rows trigger the need for the scrollbar and then turn it back on if needed. So when you place it if 4 rows fit with no scrollbars and 5 cause it to scroll you handle it accordingly. For the most part it will handle a lot of this for you.