Report on repeating data for existing forms - InfoPath Dev
in

InfoPath Dev

Report on repeating data for existing forms

Last post 05-27-2014 11:07 AM by tenbao. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 05-23-2014 11:50 AM

    Report on repeating data for existing forms

     I've read through a few posts on reporting on repeating data through DBXL. But it seems that in those posts the forms are submitting to DBXL. Is there a way to report on repeating data for forms that are submitting to SharePoint?

  • 05-23-2014 11:56 AM In reply to

    Re: Report on repeating data for existing forms

    Not really - if you promote your repeating fields to your library, you can set them to "merge" the data, but trying to sort that out is pretty messy. You can submit the repeating data to a list (either via CAML, custom code, or qRules) and then report on the list....

    Hilary Stoupa

  • 05-23-2014 01:13 PM In reply to

    Re: Report on repeating data for existing forms

    I think there are some options for DBXL if you don't want the form(s) to submit to the web service.

    In DBXL v2.8, the forms submit directly to the form library, and the DBXL Event Receiver maps the data to DBXL. Then, DBXL can map the data to SQL for reporting. The Deployment Guide (and other DBXL v2.8 documents) can be found here for more info: http://www.infopathdev.com/files/folders/installation_and_setup/tags/DBXL+v2.8/default.aspx

    Using DBXL v2.7 Standalone Edition, you could perform a sync with a form library and download the data into a local version of DBXL, then map into SQL. More info on that scenario here: http://www.infopathdev.com/files/folders/standalone/entry74112.aspx

    Hope this helps!

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-23-2014 01:24 PM In reply to

    Re: Report on repeating data for existing forms

    I was hoping for an easier solution than mapping with SQL. I was also hoping that DBXL had the ability to get the collection of XML documents and parse them somehow.

     It's great to read that DBXL 2.8 is now based on the Event Receiver model. Does that mean form updates done via SharePoint workflows would now be updated in the SQL DB mapped fields as well? 

  • 05-23-2014 03:21 PM In reply to

    Re: Report on repeating data for existing forms

    The DBXL event receiver will submit the document to DBXL whenever the SharePoint Added, Updated or Deleting events are fired. Workflow operations that update the form content should generate these events and the DBXL document updated.
  • 05-27-2014 11:07 AM In reply to

    Re: Report on repeating data for existing forms

     Thank you for the info.

Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.