I have an Infopath form that receives 100 rows, to display this on the UI at the same time causes perfomance issues therefore I have two datasets, one to store the information in the background (memory) and one that is bound to the UI.
I only show 10 records at a time and thus have controls on the form where a user can request the next 10, previous 10 etc..
Asking for the next 10 records works fine up until you hit the 71 to 80 record numbers, where Infopath crashes everytime (Microsoft error message comes up asking me if I want to send the error report), I have even tried to show 25 per page but this crashed on the 26 to 50 entries.
Is Infopath not the solution I need? As it seems to me that it just can't handle large result sets, even though 100 records is a small amount.
Many Thanks