Databases Reference
In-Depth Information
The report will be displayed. Now, the command to display the report
is
rs:Command = Render
. Note the changes in the URL as you make
changes.
Report1
will be successfully deployed. This the first report
on this Report Server.
The report and report-related information are stored in the catalog of the
Report Server database, which you may recall is
ReportServer$Kailua
.
You can run a query against this database to get all the information related
to the report, as shown in SQL Server Management Studio:
Use ReportServer$Kailua
go
Select * from dbo.catalog
Hands-on exercise 2.3 - creating a report
using the Report wizard in SSDT
Report Server Project
is the second template under
Reporting Services
in SSDT.
In this section, we will be using this template to create a report.
1.
Start SSDT from
All Programs
|
Microsoft SQL Server 2012
|
SQL Server
Data Tools
.
2.
In the user interface, click on
File
|
New Project...
.
3.
In the
New Project
window, click on
Report Server Project
. Change the
default name of the project to
RP2012
. Accept the default location and click
on
OK
. The
RP2012
project is created with the following folder structure:
Search WWH ::
Custom Search