Auto-Number SQL Query Results Infopath 2007 - InfoPath Dev
in

InfoPath Dev

Auto-Number SQL Query Results Infopath 2007

Last post 10-14-2009 11:12 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 10-14-2009 09:25 AM

    Auto-Number SQL Query Results Infopath 2007

    Hello everyone! I've searched the forums, and can't find any advice on my problem. 

     

    I have an Infopath 2007 form that queries\submits data to a SQL 2005 database. It works beautifully, but end-users have one request I am trying to fullfill. When they run a query on our vendors (Over 1000) based on certain criteria, they would like a quick way to just see HOW MANY results there are. Currently the form will display the results, but there are is no numbering beside them, so to get an idea of just how many vendors fit the criteria, they hsave to scroll and count manaully. Obviously, this is laborious. 

     

    So my question is, can I insert another row in the form that would auto-increment QUERIED data? (Ive seen plenty info on how to submit auto-increment numebrs tot he DB, which I don't want to do) 

     

    Any advice would be great!

  • 10-14-2009 11:12 AM In reply to

    Re: Auto-Number SQL Query Results Infopath 2007

    You are displaying the returned results in a repeating section or table, right? Just add an expression box in another column (for a table) or in the section that uses the position() function... that will give you a row number. You can also use an expression box at the top of the form somewhere that uses the count funtion to return a count of the returned rows -- count(yourrepeatinggroup).

    Hilary Stoupa

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