SQL Database Integration

Re: Missing repeating section fields (sourced from MSSQL) when form is emailed

ladyath — Fri, 30 Dec 2011 07:22:13 GMT

I fixed it by querying the data on form load. Unfortunately submitting to a database was not an option since I have yet to figure out how to create a web service and my DB has large binary fields. As per my other post I resorted to creating additional fields to store the data I did not want to overwrite.

Re: Missing repeating section fields (sourced from MSSQL) when form is emailed

Patrick Halstead — Mon, 26 Dec 2011 14:11:47 GMT

This seems related to your other post. Because you are sending the XML and the secondary data source is not hte main data source, you won't see the data. You could copy the values to your main data source (as you mention in the other post), or you could submit the form to the DB and have person B open a link whch refreshes it on open. You could also just query the secondary data on open of the XML and that should also work and be better since it won't require copying values into the main data source nor submitting data to SQL.

Missing repeating section fields (sourced from MSSQL) when form is emailed

ladyath — Sat, 24 Dec 2011 11:17:20 GMT

I am running into an odd problem. I have a form published on SP 2010 and a user can open it, push a button so it populates the form from MSSQL and make changes. The user is then supposed to email the form to the next person. Person A sees all the fields (spread across various views), but person B cannot see data from repeating sections where the source is a secondary MSSQL table. It seems to keep all other data without a problem - even the changes Person A made. All other fields are set to 'Refresh value when formula is recalculated' and the data connection is set to 'Store a copy of the data in the form template'. I do not have 'Automatically retrieve data when the form is opened' as it ends up overwriting changes made by Person A.

Anyone see this problem before? Or know how I can fix it? I would prefer the users not to open the form from the SP site (except Person A) and to have to respond as delegated parties when they receive the form as a mail attachment.