Post reply

Problem with retrieving sharepoint list data using Report Builder 3.0

  • July 29, 2011 at 4:08 am

    #245139

    We created one of the out of the box time tracking sites on sharepoint 2007 standard and I'd like to report on the data.

    I've successfully used Report Builder to gather data from other lists so it's not my connection or set up that's a problem.

    The error message thrown when trying to retrieve data from the list is:

    An error occurred while executing the query.

    Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.

    An entry with the same key already exists.

    The list on a full view will export to excel and I've validated that the ID column is unique.

    Does anyone have any suggestions for overcoming this issue or how to troubleshoot it further?

    Thanks in advance

  • July 29, 2011 at 5:08 am

    #1360669

    I've resolved this- the issue was caused when the projects in the associated project list were deleted and resulted in a number of items in the log having their project value broken.

    A filter excluding blank project values allowed the query to ignore these duff values.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply