Pro SQL Server 2012 Reporting Services

(sharon) #1
■ INDEX

Windows Credentials, 391
Report layout, 61
list data region
design area, 63
free-form objects, 63
List Start, 63
patient group, 67, 68
Patient_Name grouping, 66, 67
preview, 64–66
RDL file, 68–69
Row Groups, 65
Tablix properties, 65, 66
ungrouped fields, 64
Matrix data region, 86
cost estimation, 87
data field grouping, 85
Matrix Start.rdl, 85, 86
Matrix.rdl, 88
preview, 87
RDL output, 88
page setup, 61–62
rectangle data region
default currency format, 82
formatting report, 82
free-form container, 80
preview, 84
RDL output, 84
Rectangle Start.rdl, 81, 82
Rectangle.rdl, 85
Textbox report object, 80
report objects, 62–63
table data region
data organization, 75
detail row, 76
Estimated Cost expression, 78
Group Properties, 77, 78
preview, 79
RDL, 79
Row Group creation, 76, 77
Table Start.rdl, 75
Table.rdl, 80
Textbox control
multiple format output, 74, 75
patient name value, 73, 74
plane text date formatting, 72, 73
Rich Text Formatting, 69
TextBox properties, placeholder, 70, 71
TextBox_Start report, 70
value properties, 71, 72
Report management
data source, 290–292


execution auditing and performance analysis
built-in logging feature, 308
ExecutionLog Table, 309–311
performance monitoring, 313–315
Report Execution Log, 312–313
SSRS deployment, 308
SSRS logging, 309
RDL (see Report Definition Language)
report history, snapshots
caching, 296
data-driven subscriptions (see Data-
driven subscriptions)
History tab, 295
report processing, 295–296
snapshot options, 293, 294
standard subscriptions (see Standard
subscriptions)
types, 293
shared schedules
creation, 281–282
report configuring, 282–284
set up, 280–281
SSRS (see SQL Server Reporting Services)
Report Manager, 12–13, 214
EmployeeServiceCost.rpt file, 215
manage option, 215, 216
properties modification, 216–218
RDL file, 215
Upload File option, 214, 215
Report Page Layout (RPL), 11
Report Processor, 10
Report rendering, 11
buttonOK click Event Handler, 271
Class-Level Private Variables, 266
data source creation, 259
finalized Web report application, 277, 278
finished report, 273
GetItemParameters method
code, 267
Combo Item class, 270
ForRendering, 267
GetParameters_Load event method, 268–
270
HistorylD, 267
Item, 267
Parameters dialog box, 271
ParameterValues, 267
ValidValue, 267–268
getParameters click Event, 272–273
GetParameters Form creation, 263–265
GetParameters_Load Event, 266
Free download pdf