InfoPath Dev

If you want to query repeating table data with Microsoft SQL Report Builder 3.0, SSRS, SSIS, Excel, Access, or Performance Point be sure to check out http://infopathdb.codeplex.com Over the years I've tried many InfoPath reporting options with PowerShell scripts, Scheduled Tasks, code behind, and multiple submit data connections. Having a ...

If you want to query repeating table data with Microsoft SQL Report Builder 3.0, SSRS, SSIS, Excel, Access, or Performance Point be sure to check out http://infopathdb.codeplex.com Over the years I've tried many InfoPath reporting options with PowerShell scripts, Scheduled Tasks, code behind, and multiple submit data connections. Having a ...

I had a similar issue with NaN headaches. Essentially I wanted to show a warning message (section with red background color) when the percentage exceeds 100%. The solution for me was a simple translate() function I found at http://braintrove.com/id/71 translate(../my:Dividend div ../my:Divisor, "aN", "0") This ...

Try making sure that the "Edit XPath" check box in the lower right corner of the formula editor window is checked. Sometimes when pasting a formula to InfoPath, we must first check this box to enable advanced XPath formula editing.

I add the below formula as a calculated field in the bottom right corner on all views. This helps with support and troubleshooting. I hope you find it useful too. substring-before( substring-after( /processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'solutionVersion="'), '"')