NARISA.COM

This article will show you step-by-step on creating report base the following technology & Tools

· SQL Server Reporting Services

· SQL Server Business Intelligence Development Studio

And base on SQL Server 2008R2 product sample databases

1.Explore database diagrams via Microsoft SQL Server Management Studio on target database

2.Starting SQL Server Business Intelligence Development Studio with Report Server Project Wizard

In this sample Server\instance is FUJU-MSFT\SQLEXPRESS and database name is AdventureWorks

http://fuju-msft/ReportServer_SQLEXPRESS

http://fuju-msft/Report_SQLEXPRESS

Common issues:

Reporting Services Error

The permissions granted to user 'fuju-MSFT\fuju' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

See Also:

• · http://msdn.microsoft.com/en-us/library/aa337491.aspx
• · http://msdn.microsoft.com/en-us/library/aa337471.aspx
• · http://msdn.microsoft.com/en-us/library/aa337312.aspx
• · Report Manager: http://msdn.microsoft.com/en-us/library/ms157147.aspx
• · Reporting services for MS Express : http://msdn.microsoft.com/en-us/library/ms365166.aspx