https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/124304.aspxTue, 03 Aug 2021 22:58:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124304lou d0https://www.infopathdev.com:443/forums/thread/124304.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124304That did it. Thanks again!..Louhttps://www.infopathdev.com:443/forums/thread/124303.aspxTue, 03 Aug 2021 22:28:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124303Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124303.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124303You may need to rebind the repeating table to the other data source first. Basically, the repeating table needs to be bound to the correct data source - then you can change the control inside it.https://www.infopathdev.com:443/forums/thread/124302.aspxTue, 03 Aug 2021 22:22:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124302lou d0https://www.infopathdev.com:443/forums/thread/124302.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124302Thank you. I need to do the same for a few other fields, but I get the attached error message. I did the following steps, and get the error message at step 5: 1. Added the layout table; 2. Copied the repeating table from the field you helped me with and pasted it into the layout table; 3. right click the value inside the repeating table you helped me with and selected copy; 4. I pasted it into the new repeating table; 5. I attempted to change the binding to the field I need for this new repeating table but when I select the field to bind it to (which is in another data connection I created), I get the attached error. Thanks..Louhttps://www.infopathdev.com:443/forums/thread/124301.aspxTue, 03 Aug 2021 21:49:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124301Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124301.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124301A layout table can be added from the Insert menu - Custom table - I selected a single row, single column table. Then I cut & pasted the table into the cell. :)https://www.infopathdev.com:443/forums/thread/124300.aspxTue, 03 Aug 2021 21:27:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124300lou d0https://www.infopathdev.com:443/forums/thread/124300.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124300Thank you Hilary!. I have to repeat these steps for a few more fields that can have multiple values, so I want to make sure I understand what you did and try from scratch rather than copy and paste. I understand about the conditional formatting, but you indicate you put the table inside a layout table cell. These are the steps I can't follow, as I don't see an option to add a control called 'layout cell'. See the attached screenshot. Do you add a table from this menu bar somewhere and then slide the repeating table into it? Thanks! Louhttps://www.infopathdev.com:443/forums/thread/124299.aspxTue, 03 Aug 2021 20:13:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124299Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124299.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124299You had conditional formatting on the control inside the repeating table to hide it, but not on the table itself. So I copied that rule to the table. Also I put the table inside a layout table cell - perhaps this will now look the way you want it to.https://www.infopathdev.com:443/forums/thread/124298.aspxTue, 03 Aug 2021 20:04:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124298lou d0https://www.infopathdev.com:443/forums/thread/124298.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124298Attached is the .xsn file. The repeating table is for the field 'Metric Type' (about two thirds of the way down the form), which is bound to a sql server data source field called 'Metric Type Name'. I will try out your suggestion as well. Thanks! Louhttps://www.infopathdev.com:443/forums/thread/124297.aspxTue, 03 Aug 2021 16:28:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124297Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124297.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124297I think if you put the repeating table in a layout table cell, and format that layout table cell to have a white background (and auto-height), this might display as you wish. But can I see your form? I'm not sure why you have the gap, as you aren't using a layout table in the last copy I have (which is a common cause of this).https://www.infopathdev.com:443/forums/thread/124296.aspxTue, 03 Aug 2021 16:19:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124296lou d0https://www.infopathdev.com:443/forums/thread/124296.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124296Thanks. I was able to get it to work (see the screenshot I attached). However, the repeating table causes the form to now have a large gap between the last row of the repeating table and the next field below it. It's not that big of a gap, but I would like to have the next field (i.e, Reporting Frequency) to show up close to the repeating table. And in some cases depending on what I select in a dropdown field above it, it creates a few (or many) blank records before the first row. Is it possible to remove these leading and trailing blanks? Thanks again!https://www.infopathdev.com:443/forums/thread/124294.aspxTue, 03 Aug 2021 15:03:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124294Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124294.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124294I wonder if the field is just not returned if it is blank - I know SharePoint does that, but don't know about SQL. An easy way to test this would be to change the conditional formatting to color the row instead of hide it. Then add another formatting rule to turn it a different color if it is not present.... I suppose it could also contain a blank char, and not be blank. Can you directly query the database? What do the blank metric type values look like in the actual data?https://www.infopathdev.com:443/forums/thread/124293.aspxTue, 03 Aug 2021 01:06:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124293lou d0https://www.infopathdev.com:443/forums/thread/124293.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124293Can I attach .png files so you can see the screenshot I was referring to? I attached it earlier but it looks like you only saw my .xsn file. I'm re-attaching the .png file here, where you can see I get hundreds of blank records; a few before the first record and many after the last record. The form prompts the user to enter in an ID from a data connection, and based on the ID selected, the repeating table should show the values that correspond to the ID. It looks like the rule you created is intended to hide the blank records, but they still show up. My intent is to just hide the blank records that appear with the populated ones, but the control should always be shown. This field will always be populated with at least one row. Thanks! Louhttps://www.infopathdev.com:443/forums/thread/124292.aspxMon, 02 Aug 2021 23:58:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124292Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124292.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124292I don't see any screenshots, sorry, just the form you attached. The rule to hide the row was to hide anything where the value was blank - which is what you are saying you want hidden.https://www.infopathdev.com:443/forums/thread/124290.aspxMon, 02 Aug 2021 18:49:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124290lou d0https://www.infopathdev.com:443/forums/thread/124290.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124290I think I see where you put the conditional formatting. It's a rule called 'Hide for Blank'. Note that I do not want to hide the control. the repeating table you added does bring back the five rows I need, but the table shows blank records before the first value, and hundreds of blank records after the last value. If you look at the screen shot I attached earlier, you can see what I'm referring to. Thanks for any assistance.https://www.infopathdev.com:443/forums/thread/124289.aspxMon, 02 Aug 2021 18:43:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124289Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124289.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124289Well - I took your copy and changed it, just to add conditional formatting. Here's the copy I posted the other day with the same format change - I haven't walked through the data connection, so I'm not sure what would have changed there.https://www.infopathdev.com:443/forums/thread/124288.aspxMon, 02 Aug 2021 18:33:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124288lou d0https://www.infopathdev.com:443/forums/thread/124288.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124288Thanks but I downloaded your attachement and tried to test it out. When I click on preview, my data connections to SQL server no longer work. I closed out of your attachment and opened my version, and it no longer works either. I don't get any error messages, but when I click on Preview I do get the prompt to connect to the database, but I no longer get any records back and I don't get an error message. Any idea why? Thanks! Lou