SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


I have a site collection that has a lot of sub-sites. I am using SharePoint Designer 2007 to connect a large list from one site to another on a Data View Web Part. It connects just fine and shows all of the lists, but when I click on 'Show Data,' it will wait for a long time and then crash.


Do you know of a good way to modify the actual query that SharePoint Designer uses with the SharePoint database or add in a Data View Web Part without using the typical method that I described above?

share|improve this question
Update: The list I am trying to access has 56,544 items in it, with more items being added every day. – Christopher Mar 5 '12 at 5:41
up vote 2 down vote accepted

The 'Show Data' option normally tries to fetch all the data from the respective SharePoint List or Database.

I can suggest you a workaround solution which might suit you.

While creating a Data View web part, using a list, instead of "Show data" there is another option called "Copy and Modify". While selecting this option, you get a dialog option, to enter a filter criteria for the list to be retrieved. Give a filter criteria that brings you comparatively less number of records. This creates a new list copy, which only has records that is filtered from the main list. Clicking on "Show Data" for this new list should bring you the desired results.

share|improve this answer
I have tried that, and the same problem arises. All the options will grey out, and SPD will crash. Any other ideas? – Christopher Mar 4 '12 at 6:03
I was finally able to do the copy and modify technique and eliminated a bunch of columns I wasn't going to use. It switched to the 'Data Source Details' tab and said "The server returned a non-specific error when trying to get the data from the data source... etc. etc." Could this be a server configuration problem? – Christopher Mar 4 '12 at 13:34
Please look into the solutions provided in this blog -… – Deepu Nair Mar 5 '12 at 11:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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