InfoPath Dev

Hi,

I cannot figure out how to create an scrollable repeating table in a browser form with InfoPath 2010. Does anybody know how to do it? Is that possible at all? Is there any way to do that by setting certain rules?

Many thanks,

Diego

The scrolling region is not available in browser forms, unfortunately. Here's a table that shows what controls are available for browser and client.

Hmmmmmmmm maybe - you could try placing the repeating table on the form.
Have a field (indexNum) created outside of the repeating group which stores an 'index number'. Default 1.
Decide how many rows of the table you want to display (my example below uses 5)

Now put conditional formatting on the repeating table to hide when position() < //my:indexNum and position() > //my:indexNum + 5.

Add two buttons (Up and Down) and use them to increase or decrease the value of my:indexNum.

Visually Virtual Scrolling. or VVS as we say in the...no I'm just making this up.

Once again, many thanks, Hilary. I wasn't sure whether that was possible.

 Thanks, Skarn. Your trick sounds pretty cool. I am going to try it right now.

Hi,

Were you able to get the solution. If yes, please share.

Thank you

 'ere you go - cobbled this up for you - it is a proof of concept using the method I was describing in my earlier post.

Of course, I'm still stuck in the IP2003 world - you can probably do better with a later version.

Hi Venkatzeus,

sorry for the delay Venkatzeus. I used Skarn´s idea and it worked ok. Well, more or less... Locally I could scroll, but on the server... The performance was not very good with the paging we implemented. After this first tests, my project manager decided to switch to Silverlight and we have not worked with InfoPath anymore. Unfortunately, I have deleted our proof of concept, so I won´t be very helpful. However, I will try to describe you what we did to achieve scrolling on our forms.

If your data source is SQL -that is, a stored procedure- you could use "SELECT column1, column2, row_number() over (order by MyChosenColumn) as RowNumber FROM tblXXX" to get some kind of paging on your source data. After that define one field ( I would call it "LastSelectedIndex") which will keep the first index of the last loaded "page". Let´s assume that you want to show 10 rows every time.

The start value for LastSelectedIndex should be 0. Then you could define a rule for the loaded data, something like "load all data where RowNumber < 11".

Then you could place two buttons "back" and "next" with the following rules.

BACK ->  1st Rule: "LastSelectedIndex = LastSelectedIndex - 10 "

               2nd Rule: Load Data "SELECT all data FROM MyDatabaseTable WHERE RowNumber BETWEEN LastSelectedIndex AND LastSelectedIndex - 10

NEXT->   1st Rule: "LastSelectedIndex = LastSelectedIndex + 10 "              

             2nd Rule: Load Data "SELECT all data FROM MyDatabaseTable WHERE RowNumber BETWEEN LastSelectedIndex AND LastSelectedIndex + 10

I hope this can help you. I am sure you´ll manage to create your own paging. Good Luck!