Adding Summary Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CrazyRaymo - 02 May 2006 21:08 GMT

Basic idea: Add additional rows to a filtered repeating table showin
subtotals.
Example:
Data Source: Vendor, Month, ServiceType, InvoiceAmount
The user selects a Vendor from a drop down list then the repeatin
table shows all the InvoiceAmounts for that Vendor, organized by mont
and type. (I can already get that far.) But also, rows should b
added, interleaved at the appropriate places, that show the subtotal
of InvoiceAmounts by Month and ServiceType. Obviously, this scenari
requires sorting, but assume the data is pre-sorted. And assum
another column to hold the "Total" label.

I cannot use C# or managed code. It needs to work for offline forms o
machines that don't have .NET. I have done this 1.3 million times i
VB, but InfoPath has me stumped. However, maybe my programmin
background is keeping me from seeing the solution.

Thank yo

--
CrazyRaym
Posted from - http://www.officehelp.i

Reply to this Message

Ben Walters - 03 May 2006 01:22 GMT

Howdy,
Have you tried using a footer row on your repeating table ?

Cheers
Ben walters

> Basic idea: Add additional rows to a filtered repeating table showing
> subtotals.
[quoted text clipped - 14 lines]
>
> Thank you

Reply to this Message

CrazyRaymo - 03 May 2006 17:04 GMT

A footer won't help as the added rows need to be scattered through th
result set. For instance:
Vendor Month ServiceType InvoiceAmount
-----------------------------------------------
Bob July Plumbing 42.19
Bob August Plumbing 57.81
Total 100.00
Mary August Finance 13.00
Total 13.00

And, of course, the user wants to sort by vendor or month and hav
everything retotaled.

I found how to insert rows into the DOM with insert.Before. However
that means deleting the added rows and adding new ones for after sort.
Is it possible to add the rows only to the view?

Thanks

--
CrazyRaym
Posted from - http://www.officehelp.i

Reply to this Message