InfoPath Dev

Attached 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! Lou

I 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).

Thanks. 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 ...

 Here's a link to a download: https://spaces.hightail.com/space/0oVmqQfv73 You can install the full trust form on a machine with InfoPath installed. Instructions are in the qRules Full Trust Form Installation Guide.pdf in the zip file. This is a trial version - if you hit the limits and decide the tool will work for you, let me know ...

I 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 ...

Can 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 ...

I 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.

Hey, Hilary. Thanks for that. I was slow responding to this, but I never saw the email come through. I checked my spam folder as well. Is there another way to send?

I 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 ...

Well - 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.