It annoying to me that I can’t just display, and potentially use (for currency conversion eg) the total of a column in a TransView column.
Here I am using two date pickers to set a date range to query invoices and labour entries within the range, storing these in TransView columns, and applying them to both grids via Grid Model, Provider, BAQ Options, Where clauses. This “Dashboard” created using the application wizard (see Basic Application Wizard no TransView - #7 by Carson) as opposed to the classic dashboard to Kinetic UI conversion process.
I thought I might be able to include a sum column in the BAQ via subqueries etc, but basically the BAQ WHERE clauses are applied to the BAQ as if its a subquery, so the totals have already been SUMmedbefore the WHERE is applied and thus not what I am after.
Yes i could do it with BAQ parameters, but they really don’t work terribly well as everytime you search, sort, filter, refresh, sum… the parameter slider appears.
I thought there might be an event to catch the loading of each row during the BAQ get, that I could intercept and do summing there, but nope, not as far as i can see at least.
Surely this is doable…somehow?
