-
Fun! See attached sample. Enter the name of a field (field1, field3, field4) in the top text box and the value should show up in the bottom text box.
-
Hi -
Sorry about the paragraph breaks - I think the forum doesn't play nicely with all browsers.
So - when you say "doesn't work" - what do you mean? No value is returned to the field with the formula? Is the XPath valid when you check it in the formula box? Is the my:rSMName field populated? Are you 100% sure of the ...
-
This is going to require code - You can add a data connection to your form to your SQL database and then change the command to run your stored proc, but since you want to export to Excel, you'll still need to be full trust. I'd suggest you start with the code to connect to your DB and execute your stored proc. Then you can copy the ...
-
Sorry - I don't know about this / have never done it - you may want to start a new thread and see if someone else has done this.
-
Are you using the same UDCX connections? Can you test the form in filler by disabling your rules and simply trying the data connection by manually setting the query fields and adding a rule to a button to execute the query?
-
Looks like you are back to your earlier issue then - the same error you were getting initially. If you paste the URL in the browser, do you get a prompt to open or save the XML?
-
Yeah, I can't think of a reason why the web service connection would use your credentials unless there is something up with the UDC? Can you test with a form not using a UDC? Can you test in filler while signed in as different user to see if you have different results?
-
I'm sorry, I don't know that your reply answers my initial question? I'd asked if this formula:
concat(substring-before(substring-after(xdXDocument:get-DOM()/processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'href="'), 'Forms/template.xsn"'), ...
-
Hi -
2.8 should be released very soon - Keep an eye on the DBXL product page over the next week or so. There will be a list published there of the enhancements.
Do you currently submit filled out XML for your SQL bound form? Or is the template just for querying from / submitting to SQL? Do you need to submit to the same tables, or can you ...
-
Perhaps no one has any ideas that don't involve a third party tool? You'll need to write some code to do this yourself. You may want to look into Word Automation in SharePoint - apparently that can be leveraged, but I've not done it myself.