Hidden Detail Lines

FLX TMS FlexCel for VCL & FMX
1

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
2

Hi,

The syntax should be:

<#aggregate(SUM;Transactions.Amount>

Can you try it? I am not 100% sure it works with Table.Subable, but if it doesn't I'll take a look to add this support.

Regards,
   Adrian.
3

Adrian


The aggregate function works fine (I just mistranscribed sorry)

The issue is that I seem o have to put a dummy Transactions range on the template to be able to reference Transactions.  I have a bodgy solution where I have just put I_Transactions_I in a cell at the end of the Clients row and this now works so that is good.

The more general question of how subtables are dealt with remains - for instance I cannot sort on a subtable element.

But looking much better now anyway.

thanks
Andrew