W@rfi Blog

I had to pass through a scenario that may rare as far as working with MOSS is concerned, sharing it on my blog so it might help someone else. I had built an office automation application using MOSS. We need to pull legacy data within our application as well. In the application there were several sharepoint views.

Problem

After performing import for the legacy data, the total count of items was like more than 150k. I see the following problem opening up page in designer:

I was not able to do anything with the file using designer. I tried clicking off the option to “Show Values” in the Data source details tab but it won’t help as the values are still fetched but just not shown in the tab. I have to try with several things before I came up with this solution.

Solution

Solution is simple, we just need to limit the rows to show in the view. We need to add three tags only. First you will need to put a pagesize with webpart tag:

Then you will add rowlimit tag before the end of </SelectParameter> tag:

Thirdly, you will put the RowLimit tag in the tempate dvt_1 tag as well:

You are done, now when you will open the page in designer page will be opened. Now you can make any changes to your page as you want. Do you customization and stuff.

Enjoy !!!

admin SharePoint Automation Application, Customization, Data Source, Legacy Data, Load Test, MOSS, Office Automation, Pagesize, SharePoint, Source Details