Datasheet

22
❘
CHAPTER 1 BUSINESS REPORTING PARADIGMS
CPU MSI SAMPLE
32-bit SQL2008.Reporting_Services.Samples.x86.msi Reporting Services Samples
SQL2008.AdventureWorks_OLTP_DB_v2008.x86.msi AdventureWorks2008
Sample Database
SQL2008.AdventureWorks_DW_BI_v2008.x86.msi AdventureWorks2008DW
Sample Database
x64 64-bit SQL2008.Reporting_Services.Samples.x64.msi Reporting Services Samples
SQL2008.AdventureWorks_OLTP_DB_v2008.x64.msi AdventureWorks2008
Sample Database
SQL2008.AdventureWorks_DW_BI_v2008.x64.msi AdventureWorks2008DW
Sample Database
IA64 64-bit SQL2008.Reporting_Services.Samples.ia64.msi Reporting Services Samples
SQL2008.AdventureWorks_OLTP_DB_v2008.ia64.msi AdventureWorks2008
Sample Database
SQL2008.AdventureWorks_DW_BI_v2008.ia64.msi AdventureWorks2008DW
Sample Database
Before starting the sample installations, verify that the SQL Server Database Engine and Reporting
Services are running. Then, launch each downloaded MSI and follow the instructions provided to
install the samples.
The installation procedure and specific files you may need are subject to change. Please refer to infor-
mation on the CodePlex web site for the most up-to-date installation instructions for these files.
SERVER REPORTS
The new generation of Report Builder provides true ad-hoc reporting tools that allow users to create
reports directly on the server without using the local file system. This capability is not enabled in the
initial RTM release of SQL Server 2008 but was added in Service Pack 1. The functionality is enabled
by default in SQL Server 2008 R2 with Report Builder 3.0.
With server reports enabled on the report server, any standard reports to which the user has access can
be opened directly in Report Builder using the standard Open dialog. To open a report on the server,
local, or network file system, click the ‘‘orb’’ Office start button in the top left corner and select Open
from the menu. You can navigate to a folder using the most recent items or other folder shortcuts on
the Open Report dialog window.
In this book we will not discuss any specific differences between reports deployed in native mode and
SharePoint integrated mode. For our purposes, you will simply use the appropriate URL to target the
report server or the SharePoint library used to manage your reports. If your report server is in native