■ INDEXSSRS roles, 339
system administrator, 350
system user, 350
user authentication, 339
windows integrated authentication, 340
Report Server, 8, 9
ReportServerTempDB, 8
Report server web service, 315–316
access, 231–233
calls, 244
categories, 263
CreateCatalogItem method, 230
CreateReportEditSession method, 231
form coding, 234
form layout, 233–234
RDL file, 237–239
ReportExecutionService, 262
ReportingService2010, 262
server name, 235
SOAP API, 230
TreeView Control population, 235–237
Windows Forms application, 230
Report Wizard
Corporate style, 128
data source, 126
generated report, 129
group and details selections, 128
Query String area, 127
tabular/matrix form, 127
S
Secure sockets layer (SSL), 330
ServiceTypeID, 32
SQL Server Data Tools (SSDT), 6, 13–14
SQL Server Integration Services (SSIS), 1, 309,
362
SQL Server machine, 32
SQL Server Management Studio (SSMS), 6–7
advanced query, testing performance, 28–30
graphical query, 23–25
SQL Server Profiler, 22
SQL Server Reporting Services (SSRS), 90, 91
advantages
BI strategy, 3
cost, 2
customizable, 2
SharePoint portal server, 3
standard platform, 2
subscriptions, 2
Web-enabled solution, 2
architecture
authentication layer, 10
components, 7, 8
data processing, 10–11
databases, 8–9
Report Processor, 10
report rendering, 11
Report Server, 9
scheduling and delivery, 11–12
Web service interface, 9–10
Business intelligence (see Business
intelligence)
charts and visualizations, 4
client applications
BIDS/SSDT, 13–14
command-line utilities, 14
custom clients, 15
installation and configuration, 15–16
Report Builder 3.0, 14–15
Report Manager, 12–13
secure deployment, 16–17
tools, 12
controlling with SOAP
Class-Level Private Variables, 317
ComboItem class, 319
CreateSubscription method, 319
ListSchedules method, 318
Namespaces importing, 317
PickSchedule Constructor, 318
PickSchedule.cs class file, 316, 317
PickSchedule_Load event, 317
PickSchedule_Load method, 319
report delivery, 324–326
report scheduler, 320–323
Report Server Web service, 315, 316
subscription functionality, 316
controlling with WMI, 326
data modeler, 3
deployment, 279, 308
embeddable controls, 5
HTML text formatting, 5
logging, 309
lookup functions, 6
memory management, 4
Microsoft Word rendering, 5
performance enhancement, 4
Report Builder, 3, 422–423
report parts, 5
roles, 339
shared datasets, 6