Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SSRS Reports based on two or more list

  Asked By: Britney    Date: Feb 16    Category: Sharepoint    Views: 2835

Well, I am looking for SSRS reports based on one or more sharepoint list.
for example,
Order Invoice report which contains Order information from "Order" List and order detail information from "OrderDetails" list. Both the list contains "OrderID".



1 Answer Found

Answer #1    Answered By: Tyrell Nash     Answered On: Feb 16

SSRS reports  communicates with the SharePoint list  using the web service and you need to pass in CAML query. CAML query in MOSS 2007 does not support to query multiple lists (join) at same time. CAML joins are supported in SharePoint 2010.

To meet your above requirement you can try one of the following,

1) Create a separate custom list which has columns from both Order and OrderDetails list. You can have a custom event handler on both the list's so that the data is synched to the new custom list and the new list can be used for reporting

2) Create new SQL table with the data from the Order and OrderDetails list, so that you can query the SQL table from the reporting services.

Didn't find what you were looking for? Find more on SSRS Reports based on two or more list Or get search suggestion and latest updates.