We want to give the user a way to add datawindow group aggregates (like
subtotals and averages) to any datawindow in our application on demand.
We know we could get their user's requirements from a dialog box, then
apply a Create and piecemeal Modify calls (to minimize hitting the 64K
syntax string limit) to recreate the datawindow with the specified groups
and computed fields.
Has anyone been able to solve this in a more straightforward approach?
Also, while most users will be satisfied with fairly simple expressions to
define their computed fields, a few may want to create some very complex
ones. This would require an equally sophisticated expression
builder/parser, since we do not want the user to have to be a datawindow
Does anyone know of a third party package that does this?