General

Re: Total from a SQL Database and output to InfoPath

Matt Faus — Tue, 17 Oct 2006 07:38:32 GMT

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

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

Re: Total from a SQL Database and output to InfoPath

Kamal — Mon, 16 Oct 2006 06:42:36 GMT

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

Re: Total from a SQL Database and output to InfoPath

Michael71 — Fri, 13 Oct 2006 13:48:36 GMT

Agni,

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

Re: Total from a SQL Database and output to InfoPath

Agni Jonnalagadda — Fri, 13 Oct 2006 04:21:20 GMT

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.

Total from a SQL Database and output to InfoPath

Michael71 — Wed, 11 Oct 2006 18:18:03 GMT

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