InfoPath Dev

It really helped and forms started to load multiple times faster. Thank you, Hilary!

 Many thanks Hilary, I'll use your solution

 In your repeating table, where you currently have your text boxes bound to the fields with the defaults, put a calculated value instead. For the XPath for the calculated value, use the formula editor to select the secondary data source & add the same filtering. XPath will look something like this (for example): ...

Can you please tell me how I can add expression box for each row of repeating table and filter values for each row with corresponding field from the same row?

I don't see anything in the form - as you said, there aren't any rules or other defaults that use these values. So - what happens if instead of having defaults in these fields, you just use an expression box to display the info from the secondary data source? Do you still get an error with that approach?

Yes, you can use a remote SQL Server instance. The install location can be any server, it is more a server load question. FormsViewer is not very resource intensive, but if you SharePoint WFE is low on resources, you may want to put on a lower utilized server. It is sometimes easier to put on the WFE that already has routing configured where ...

Hi Arthur, Thank you for your questions. I have asked one of our FormsViewer install engineers to respond to you as soon as possible. We appreciate your patience. Regards,

Actually I changed form yesterday. "View Report" button was set to run rule, that is now under QdabraRules -> finishedLoading: "Query Countries if ActualCostsStatus is Paid". This rule runs 2 queries and especially "Countries for Business Trip" query is causing this issue. If I don't run this query, ...

Hello, I'm trying to write a date field into a text field. I'm using the following expression msxsl:format-date(Archive Date, "mm-dd-yyyy") as the default value in my text field and a rule to run on the date field that writes to the text one. It works when I preview it in Infopath but when I try to publish it I get an error that ...