Add a lot of columns to the grid on a form

Question

I have to add all 86 fields from a view based query inside a grid on a form. The problem is that a form is very slow and the application freezes. Is there any way to make it faster?

Is your view slow or is the form slow? To differentiate make a form with two fields. — Jan B. Kjeldsen, Nov 09 '11 at 15:43
I think that the problem is of the form, because when i add only 10 fields to the grid its open quickly. — Artem Antonov, Nov 09 '11 at 15:52

score 2 · Accepted Answer · answered Nov 10 '11 at 15:46

2

Also try to disable auto-sizing of columns:

grid.autoSizeColumns(false)

answered Nov 10 '11 at 15:46

Jan B. Kjeldsen

17,817
5
32
50

The problem is that this method was introduced in rollup 3, i have a rollup 1. – Artem Antonov Nov 11 '11 at 09:13
You could try to do a kernel upgrade only (of RU7 or newer kernel). That is, do not install the application update. This will have minimal impact but will allow you to use the `autoSizeColumns` method. Of cause all servers and clients need to be updated. – Jan B. Kjeldsen Nov 11 '11 at 09:40
I would vote this up many times more if I could. Auto size columns slows down so many forms within ax 2009. – Michael Brown Jan 25 '12 at 17:55

score 1 · Answer 2 · answered Nov 09 '11 at 15:11

1

Crazy clients ask for crazy things.

My suggestion is DON'T.

As I have the advantage of working opposite you ;) my suggestion is to avoid using a Form/Grid altogether and export the data directly to Excel. Code example.

answered Nov 09 '11 at 15:11

ian_scho

5,906
9
35
51

Add a lot of columns to the grid on a form

2 Answers2