Avatar

Level 10

I have attached a calculation table sample that demonstrates my generic approach. The PDF looks like this...

generic_table_view.PNG

I create 1 body row named 'row' with 13 columns. I then change the columns from text objects to numeric field objects and rename the objects 'jan', 'feb', 'mar',...and 'total'. I then declare any other properties I want to apply such as paragraph alignment. Once I am satisfied the 1 row satisfies my requirememts I then use the Copy Multiple toolbar feature to replicate as many rows as I need.

I then apply the same approach to the footer row. Each cell in the footer row becomes a column total. For each column total it easy to apply a FormCalc to each month. For example,

// form1.page1.subform1.table.footer.jan_::calculate - (FormCalc, client)

$ = Sum(table.row[*].jan)

For the row totals you need simply to add the column variables. FormCalc is smart enough to limit the scope to the current row.

// form1.page1.subform1.table.row[0].total::calculate - (FormCalc, client)

$ = jan + feb + mar + apr + may + jun + jul + aug + sep + oct + nov + dec

Steve