InfoPath Dev

How do I Sum monthly expense, monthly Budgeted, and monthly variance of these into a Year to Date Running Total and output the total to a InfoPath Form; each time a user opens it up? Example

Monthly Expense     Monthly Budgeted      Monthly Variance
$12,000    $14,000    $2,000

YTD Expenses    YTD Budget     YTD Variance

$90,000     $140,000     $50,0000 --->Should be coming from the SQL database and totalling up more each time the user submits that form with monthly expense and monthly budgeted and Monthly Variance

Hi Michael,
You can put all of these operations in your query and pull the data into InfoPath and use that data for processing in InfoPath.

Agni,

Could you ellaborate a little. Or give me a reference. I don't understand.

Hi,
1. Retrieve data to InfoPath from SQL Database using ADO Adapter queries.
2. Process the data (do the required calculations like sum of Monthly Expense). (However retrieved data is in the form of XML so for processing these data we have to load data XML into InfoPath)
3. Place the final results in InfoPath.
4. Place this code in the form load event, so that it executes each time a user opens it up

This is a duplicate thread and therefore is being closed. Please continue discussion here:

http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=3445