Produce a Simple Table with SQL Server (Data Connection) Results on an InfoPath 2007 Form??? - InfoPath Dev
in

InfoPath Dev

Produce a Simple Table with SQL Server (Data Connection) Results on an InfoPath 2007 Form???

Last post 12-05-2011 10:07 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 12-02-2011 08:41 PM

    Produce a Simple Table with SQL Server (Data Connection) Results on an InfoPath 2007 Form???

    Hi,

    Anyone know of a simple, straight forward way to show the returned records from a query in an InfoPath Form?  I need to show users what records belong to them.  I have created the Data Connection, started a repeating Table, defined my header and the row of data points.  Now, when I view the form, I only get one (the first one) row of results.  I can not see a straight forward way to continue the repeating table based on the rows returned from the query?  I hope I am missing an easy answer and one of you good people will share it!

    Has anyone done this, how? 

    Thank you,

    Randy

  • 12-05-2011 10:07 AM In reply to

    Re: Produce a Simple Table with SQL Server (Data Connection) Results on an InfoPath 2007 Form???

    Hi - if your secondary data connection returns multiple rows, they should be displayed. In the data source task pane, if you switch from your main data source to your secondary data source (2DS), and start clicking the plus signs by the folders, do you eventually have a repeating group in your data source? And if you drag that repeating group onto your form, do you get more than one row when the data is loaded?
    Hilary Stoupa

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