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/64875.aspxMon, 07 Mar 2011 10:21:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:64875Patrick Halstead0https://www.infopathdev.com:443/forums/thread/64875.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=64875<p>Hi Vrajesh,</p> <p>Yes, you should be able to do this using conditional formatting to hide the rows that don&#39;t equal the max value (this is not filtering). The other way is to use a Web Service to filter on the server but that requires installing a 3rd party product like Qdabra&#39;s DBXL.</p>https://www.infopathdev.com:443/forums/thread/64671.aspxMon, 28 Feb 2011 20:16:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:64671Vrajesh0https://www.infopathdev.com:443/forums/thread/64671.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=64671<p>Hi</p> <p>&nbsp;I&#39;ve been scouring the web looking for an answer to this, but I haven&#39;t been able to find anything thing. I&#39;m designing a form that is connected to an SQL Database, and I have a secondary data source, which gets fed into a repeating table. The user then clicks on a button which takes some values from that repeating table and allows the user to do the work they need to do. I have randomly assigned a number to each of the rows that gets fed to the repeating and I want to only show the row with the the highest (max) number from that column. I&#39;ve tried using a text box to display the max value of that column and use to conditional formatting to filter on that&nbsp;but it doesnt update as users select that row. Is there a way to this where I can filter on the max value and only show the one row?</p> <p>&nbsp;</p> <p>Thanks,</p>