Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dFresh
Starting Member
4 Posts |
 Posted - 2008-06-04 : 13:56:46
|
| I'm quite new at this SQL stuff, so I hope im in the right place.My issue is with getting data from SQL, that is submitted by InfoPath forms on a SharePoint site.This is the process:An InfoPath form is filled out on a SharePoint site and the data is sent to SQL 2005 databaseWhat I'm trying to accomplish is being able to retrieve the data from the SQL database and displaying it in a report. We want to do it this way so that our reports are dynamic. We don't really want to go the route of having to update reports in Access manually everyday or once a week.The problem I'm having is that when a form is filled out that has a fairly large amount of input, the NVARCHAR fields seem to over lap catagories. Is this normal? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-07 : 00:41:35
|
| Does the form have multiple fields? Each field should have a column in sql table. |
 |
|
|
|
|
|
New to SQL