Newbie Questions

Re: Set up a "Receive" data connection

Michael71 — Tue, 17 Oct 2006 18:30:33 GMT

Matt if I have my infomation going into a SQL Server database, why do I need to "sum repeating table" ? I'm confused on this...

Re: Set up a "Receive" data connection

Matt Faus — Fri, 13 Oct 2006 16:31:05 GMT

Hi Michael,

This has been discussed many times in the forum before. Please try a search in the top-right corner for a phrase like "sum repeating table"

Good luck!

Re: Set up a "Receive" data connection

Michael71 — Fri, 13 Oct 2006 14:23:04 GMT

Matt,

I have it working. All I have to do now is write the SQL Query or XMSL to calculate the sum for each month and put it in the ytd Expense, ytd Budgeted, ytd Variance column and so fourth. Can you help me out.

Re: Set up a "Receive" data connection

Michael71 — Fri, 13 Oct 2006 13:58:11 GMT

I got a question. I'm a little new at this. Some else is telling to do this by a Web service, I think that the advice is wrong because I already have a main dataconnection
using a data sorce to the SQL database. So, all I have to do is

1. Click Tools -> Data Connections -> Add
2. Select Recieve Data, Database, select your tables, and click Finish.
3. Open the Data Source task pane, select the newly added data source and viola, there's your data!

And then write a SQL query.

Where do I write the SQL Query at? I'm new at this. Thanks Matt

Re: Set up a "Receive" data connection

Matt Faus — Fri, 13 Oct 2006 03:10:10 GMT

Yes, you can use SQL or XSL to calculate the sum. You could even use code if it came down to it.

Re: Set up a "Receive" data connection

Michael71 — Fri, 13 Oct 2006 02:56:23 GMT

Matt,

If the data is not in the Totals Cell in my SQL database, I guess I have to write a query to SUM up each month expenses in the ytdExpense Column and display that data in the ytdExpense Text box on the form. Right

Re: Set up a "Receive" data connection

Matt Faus — Thu, 12 Oct 2006 22:10:21 GMT

Hey Michael,

This shouldn't be too hard, you just follow the steps in the Data Connection Wizard.

1. Click Tools -> Data Connections -> Add
2. Select Recieve Data, Database, select your tables, and click Finish.
3. Open the Data Source task pane, select the newly added data source and viola, there's your data!

Set up a "Receive" data connection

Michael71 — Thu, 12 Oct 2006 14:46:32 GMT

How do I set up a "Receive" data connection to a SQL database. I already have a primary submit data connection to submit some data. I want to retrieve data from the totalPlease help.

Michael71