-
Hi mmahmoud,
in the datasource I'd try to move the sub-totals outside the group where they are (for example putting them in the same group of grand-total) leaving them in the original optional secting.
Bye!
-
Sorry, me and my jargon - I meant Drop Down List.
-
OK, replies in order:
1. Yes, I'm using the main data source for the database connection. I'm setting it up by enabling Submit on the form and then pointing the submit to the web service that I've written. This then puts the schema for the web service into the Data Source.
2. I'm populating the field from AD in the following way:
a) Creating a ...
-
I have 13 optional section inserted with repeating table and each
section has a subtotal field in it.
At the end of the form I have a grand total box, which is the sum of
all the sub-totals in the optional sections.
However, the grand total doesn't show up unless i open all the 6
optional sections. But I don't need all 6 to open at one time. ...
-
Thanks for your reply...
- I started with a sharepoint list and linked this to an access table (i did it this way as that is the only way sharepoint will allow - in fact the sharepoint list was created as an import from a spreadsheet to make things easier)
- The linkage was created by putting the list into datasheet mode, then ...
-
Hi Patrick!
I tried to reinstall infopath and so I opened the form with framework required.
:)
-
But still it gives error when I try to open it to fill from my sharepoint site. I only add a user role. No conditional formatting or anything else like that, but it gives an eror message about permissions when I try to open the form to fill.
-
Hi Mik,
When you created the form did you do so from a SQL connection? Was the main data source created from the database schema, or is it something you created? In general, you will have to set a query field and programmatically (via rules) call the SQL query adapter. This assumes that you use a main data source which was created from the DB. If ...
-
Hi Rilliam,
We have a tool to do this. Check out:http://www.infopathdev.com/webstore/detail.aspx?itemid=15
Patrick Halstead [InfoPath MVP]
InfoPathDev
-
Hi,
I am developing a form which will retrieve the users information from a table based on their username. I can get their username, but how do I query the database conditionally?
I have set it up as a secondary data source (will be submitting to another database)
I understand you can add additional commands to the query in the script (currently ...