Microsoft Office Tutorials and References
In Depth Information
in the previous example, you saw how to use SQL Server analysis Services as your data connection type.
authoring a report using a Sharepoint list as a data source and publishing it to a Sharepoint document library
is similar. in the latter case, of course, you retrieve data from a Sharepoint list.
Integration with a SharePoint List
For this example, let’s use the Airport Flight Stats custom list you created in Chapter 2. We will also author a new
report using the same Report Project Sample you created using SSDT earlier in this chapter.
author and publish a report using the airport Flight Stats custom list.
Launch SQL Server 2012 SSDt, and open the previously created report project Sample
project. in Solution explorer, right-click on the reports folder, and then click add new report.
on the Welcome screen, Click next to continue. For “Select the Data Source,” choose “new
data source,” enter the name as dsairportFlightStatus, and choose “Microsoft Sharepoint list”
Click on Credentials, select “Use Windows authentication (integrated Security),” and click oK.
in the “Select the Data Source” window, enter http://yoursharepointsiteurl/ as the
Connection String and click next.
in the “Design the Query” window, click the Query Builder button. in the Query Designer
window, from the available Sharepoint Lists, select the airport Flight Stats list as shown in
Figure 3-27 and click oK.
Figure 3-27. SSDT Report Designer Query Designer
Search JabSto ::