InfoPath Dev

I want ‘$#%92 symbol for amount fields.

I tried this, but I'm trying to figure out why it didn't work. It just puts a concat(''$'', MonthlyBudget) in my column heading. I would like for the $ to be on the left side of every monthly expense.

When I submit an InfoPath form to SharePoint, it doesn't carry over the $ sign in front. How do I add this to the columns, so that the columns can look more logical. I have tried creating my own custom columns with the exact same name as data source on the form and when it submit to the form library, it does not submit inside the colums, it just ...

I have made the date picker display the current date, but what if the user opens the form. Will this date continue to change to the current date. If so, how do I prevent the form from changing everytime the form opens...unless the form is saved again. I'm trying to make the date picker read only.

Greg, Could you give me a reference or a little more detail(a few steps). Thanks.

I have already submitted 5 different InfoPath forms to different libraries, I want to merge the data together into one Form library or report and be able to view and print this data out. How would I accomplish this. Any suggestions would be appreciative. Thanks.

Success.....I found the code on the internet and edited the code. For future reference here is the Xpath to select a specific department and only the current year from an SQL Server database. I'm getting good. sum(xdXDocument:GetDOM(''TOSSReceive'')/dfs:myFields/dfs:dataFields/d:TOSS/@monthlyExpenses[../@employeeDepartment = ...

Does anyone know the Current Year Xpath function for InfoPath?

Try this...... Make sure Primary id int(data type) 4(Length) At the bottom of the bottom the Columns should be set to..... Precision = 10 Scale = 0 Idenity = Yes Identity seed = 1 Idenitity Increment = 1 ISRowGuid = No

I had the same problem many times, I had to troubleshoot the issue. When I experience the problem, the data type for the primary key was wrong(should be int) or the permissions to submit to the database has to be true for update, insert, view. Good Luck.