0

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)

enter image description here

DVWP 2 (Sum by Month)

enter image description here

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.

enter image description here

I've tried a few things to fix this and nothing has worked.

  1. I've increased the list view threshold
  2. I've setup some Indexed Columns (Request Date, Quantity and a few other columns)
  3. 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.

Jovi

1
  • What error do the logs show for the correlation ID?
    – teylyn
    Jun 19, 2014 at 22:14

1 Answer 1

0

have you done the following

  • Don't use a Linked Source, but instead use DataSourceMode="CrossList". That way, when you add that 37th or 38th list, it'll just keep on working without any changes. Another benefit is that you can get the XSL working with just one list with DataSourceMode="List" and then once you have things the way you want them, you just switch modes.

  • Tick the 'Show with sample data' box in the Common Data View Tasks. SharePoint Designer will then render just sample data without going to the server for the real data while you develop.

link: http://www.endusersharepoint.com/STP/viewtopic.php?f=9&t=1027

Hope it solve the issue

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.