Qdabra Tools

Re: Query a Repeating Table with Report Builder

Scarlett — Sat, 11 Oct 2014 04:36:55 GMT

Since you are using calculated values, you will be unable to use the sum function properly. There are two options you can do, A) add a condition to your sum formula (you'll also need to include the quantity column here), or B) use an unused column which will hold the total value per row, which you can easily use for the sum function. Is this approach not possible for you? Please let me know.

Re: Query a Repeating Table with Report Builder

Patrick Halstead — Sun, 15 Sep 2013 21:50:45 GMT

Cool, I love that we now have a competitor to our DBXL Web service suite! :)

In addition to supporting 100s of Web methods that ease InfoPath solution development with SharePoint, SQL, Workspace, etc. Qdabra's DBXL Web Service comes with many tools for Migration, Importing from Excel, Reporting into Excel, Bulk Editing, etc. http://www.qdabra.com/en/products/DBXL.aspx

Re: Query a Repeating Table with Report Builder

spjeff — Sat, 14 Sep 2013 22:22:54 GMT

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 real-time web service to merge XML data for easy query works well and I published that in case it can help others too.

Re: Query a Repeating Table with Report Builder

mfrey — Thu, 20 Jun 2013 14:19:02 GMT

That worked. Thanks!

Re: Query a Repeating Table with Report Builder

ErnestoM — Thu, 20 Jun 2013 13:16:28 GMT

Hi Mike,

Yes, it is possible. When filling out the Report Builder form, the Base Path needs to point to a repeating node in the form. Then, the fields to retrieve must use a path relative to that repeating node.

So if your base path is my:myFields/my:Customers/my:Customer (where my:Customer is repeating)

Then your fields could be:

my:Name

my:TelephoneNumber

my:Address

../../my:Date (this allows you to select a field from outside of the repeating group).

Hope this helps!

Query a Repeating Table with Report Builder

mfrey — Wed, 19 Jun 2013 20:11:53 GMT

Is it possible to query repeating table data from a form stored in DBXL using the Qdabra Report Builder? I read through the blog post and am able to get all the non-repeating data.

Thanks!

Mike