I have a sales details form which also displays totals by region for sales quantity, sales amount etc.
This worked fine in Axaota 4.0. But , after migrating to Axapta 2009, it takes ages to work out the calculation and display. The grid itself fills up fast. It is only the sum data that is slow.
The code used is looping through query output such as
cij = this.queryrun().getno(1);
additions based on region
} while this.queryrun().next();
Can anyone help me with this problem?