- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
I have attached a calculation table sample that demonstrates my generic approach. The PDF looks like this...
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
Views
Replies
Total Likes