Hi
I have a report based on a dataset of objects each of which has enumerable lists of children of various sorts ..
Claims
- transactions
- attachments
- logs
etc
Now I can feed the Claims dataset in to my report and all good so far..flexcel sees the Transactions, Logs etc child datasets
<#Claims.Number>....
I want a sum across the transactions for a claim
<#aggregate(Transactions;<#Transactions.Amount>)>
I can get this but to make it work I seem to have to include a Transactions named range or something similar but I just don't need these detail lines, just the sum from them...
I tried <#aggregate(Claims.Transactions;...)> but that blew up
I have looked pretty hard and tried a horizontal I__Transactions__ range at the end of the Claims_ line (doesnt work) ... any suggestions as to how to do this - strikes me as a reasonable common request.
Reason I am not doing the aggregation in the object is because we are trying to build code free flexibility.
thanks
Andrew