I hope someone can help me out with this one. I have a large list that contains about 40 columns and currently holds 33 thousand list items in SharePoint 2010.
One of the columns is used to enter an item quantity, and I am using a DVWP and some XSLT to display a report that sums up the quantity per day. I also have a second DVWP that sums up the quantity by month.
DVWP 1 (Sum by Day)
DVWP 2 (Sum by Month)
My problem is that I get the following error message when ever the Sum by Day DVWP shows more than two weeks of data, and the same error when ever the Sum by Month shows two months or more.
I've tried a few things to fix this and nothing has worked.
- I've increased the list view threshold
- I've setup some Indexed Columns (Request Date, Quantity and a few other columns)
- I've run the powershell to increase the XsltTransformTimeOut all the way up to 15
I should also mention that when working on the DVWP in SharePoint Designer everything renders correctly, for example I can see up to 6 months on the Sum by Month WP. However, I consistently get the error message when I browse to the page.
I'm really stuck on this one and would appreciate all the help I can get.
Thanks in Advance everyone.