-
Hi Kathie and welcome to our forum!
The sum will calculate all entries at once. If you want a running balance, you'll have to use preceding-sibling as your opening balance and subtract the current line item. Search the forum (upper right) and site (upper left) for preceding-sibling() and current() to find references to how to use those xpath ...
-
Hi Song and welcome to our forum!
How are you deleting it? Why not create an XSD file outside of InfoPath and create a form from it - then the namespace will be whatever you want. Otherwise, you have to change it in multiple places (for example, the XSF).
-
Hi Alexander,
Probably because you are in the designer and you can't edit it at the same time that InfoPath is editing it. Just a guess though.
-
Hi Navid,
Did you create your form from the Web service? Are you using InfoPath 2007? If so open the form in the Designer. Go to Tools->Convert Main Data Source and upgrade it after you have removed the requirement from the WS and DB.
Good luck!
-
I have tried the approach outlined in the article and it almost works.
The form reports success, but the list does not contain my submited data.
The list GUID seems to be correct because any modification results in a error message.
Any ideas on why no data reaches the list?
-
Greg, Thank you so much for the help. i did use the cascading article, built a small SQL table for my needs and filtered using the form, worked perfectly!
I'd like to take it one step ahead, maybe you can give me a place to start as well:
now that i have my cascading dropdowns, i want to pick these two data bits and query another SQL table which ...
-
Hi.
I have a question :
I have some InfoPath forms and a web service and a SQL2005 DB.
(InfoPath <==> WS <==> DB )
The forms use the web service as their main connection.
The problem is that although I check ''Allow Nulls'' some fields in my tables in sql, but when I insert them into a form, they are checked as ''cannot be blank !!'' ...
-
Hi again,
Yes, it's a Web service that integrates with SharePoint to allow storing forms in SQL (but you're still using SharePoint to view, etc.). Works with Form Server, etc.
-
hmm is this an add on to the sharepoint site?
-
Hi Homeguard and welcome to our forum!
This is a common problem of SharePoint - it limits display to flat structures. For a relational structure, you'll want to use SQL (in addition to SharePoint). That will also provide other benefits such as permissions, reporting, etc. Our Qdabra Database accelerator simplifies integration with SQL and includes ...