Pro SQL Server 2012 Reporting Services

(sharon) #1

■ INDEX


Report rendering (cont.)
RenderReport Button Click method, 277
report designing steps, 259–262
report list, 276
report parameters form constructor, 266
Report Server web service, 244
calls, 244
categories, 263
ReportExecutionService, 262
ReportingService2010, 262
Report Viewer control, 243, 244
ASP.NET application, 245
button, 274
Default.aspx Partial Code Listing, 275
DropDownList, 274
Horizontal Rule, 274
local rendering, 245
reportViewerWeb, 274
ScriptManager, 274
server-side mode, 245
SOAP API, 243
URL access, 243, 245–246
credential parameters, 250
HTML Viewer commands, 247–248
HTML Viewer parameters, 247
optional path information, 246
readme.html file, 251
rendering access, 244
report document map, 251
report parameters, 246, 247
Report Server command parameters,
247–249
Report Viewer Web Part commands, 247,
250
rs:Format parameter, 251
syntax, 245
user-supplied parameters, 251
URL reporting parameters, 244
URL viewer application, 244
ViewerParemeter method, 271
ViewerRVC.cs Form, 272
web service reference, 275, 276
Windows Forms SSRS 2008 viewer
application (see Windows Forms SSRS
2008 viewer application)
Report library, 388, 389
Report security
auditing, 356–358
components, 329
data encryption
complexity and reliability, 330

HTTPS, 330
IPSec, 330
Protected Health Information (PHI), 329
RDP, 330
VPN client systems, 330
WEP, 330
data sources
authentication, 340
connection options, 354–355
data storage securing, 337–339
filtering reports, 340
health-care application
Active Directory users and computers,
340, 341
browser, 341
Clinical Reports root folder, 345
connection screen, 342, 343
content filtering, 352
content management permissions, 341
content manager, 341
Daily Activity report, 346
data source authentication method, 345
db_datareader permissions, 345
default security group, 348, 349
error message, 347, 348
Group Policy settings, 340
My Reports feature, 341
New Role Assignment form, 349
Registered Nurse folder, 345
Report Builder role, 341, 343, 344
report objects, 346, 347
reports publishing, 341
RN Windows security group, 351
RN_DS data source, 345, 346
RNsecurity group, 340
roles and system roles, 342
test account, 351, 352
users task, 342
windows integrated security option, 345
HTTP traffic
capturing, 335–337
display filter rule, 332
display filter window, 332
network interface card, 331
network monitor, 330–332
PI data captured, 333
port 80, 331
report manager, 332
permissions settings, 340
SQL server permissions, 355–356
SSL certificate, 334–335
Free download pdf