Index

index

 
Symbols
 
@ExecutionTime 498
@ReportName 498
 
A
 
accept-language header 181, 561
access control list 271, 287
access options 300
evaluating 331
Access snapshot format 464
AccessAdapter adapter 469
ACL. See access control list
ACT 575, 581
Activator class 468
ACTUser account 584
ad hoc reporting 57, 60
adapter design pattern 459
adapters 459–463
configuring 468
implementing 467
loading 469
ADO.NET
custom dataset extension 523
dataset reporting 73, 83, 407
reporting approaches 524
Advanced Textbox Properties 152
Adventure Works Cycles 23
introduced 23
Adventure Works Enterprise Reporter 460
process flow 460
Adventure Works Report Viewer 399
Adventure Works Reporter
introduced 23
Adventure Works Web Reporter 383
AdventureWorks
warehouse database 426
AdventureWorks Access Database 426
AdventureWorks2000 504
AdventureWorks2000 database 23
and localization 177
aggregate functions 161
aggregate scope 161, 187
specifying explicitly 162
Aggregate() function 164
aggregations 421
Allow null value option 94
Analog analyzer 593
Analog log analyzer 577
Analysis Manager console 435
Analysis Services 6, 423
Cube Editor 438
definition 418
Level Naming Template 437
optimizing cube schema 436
parent-child dimension 430
vs. Reporting Services 418
analyzing report execution 255
anonymous access 262, 331, 547
AppDomain CAS policy 282
AppDomain policy level. See code access security
AppDomain.SetAppDomainPolicy 283
application blocks 482
Application Center Test 568, 575, 581, 592
advantages 581
New Test Wizard 582
Overview report 585
Performance Counters report 587
Requests Summary report 585
application framework 349
application pool 266
application security 472
application-defined groups 475
ArrayList collection 160
ASP.NET
control 592
Forms Authentication 557
menu sample 384
worker process 266
AssemblyLoad method 468
asserting permissions 290
AsyncCallback delegate 374
asynchronous design pattern 470
asynchronous report delivery
with subscriptions 485
asynchronous report generation 348, 471
with WinForm clients 372
asynchronous Web service calls 374
AsyncState 374
authenticating, web users 410
Authentication 547
and data sources 69
defined 261
vs. data source authentication 264
Authoring features 7
authorization
creating policies 274
creating roles 274
defined 261
policies 270
policy inheritance 271
policy management 271
roles 268
tasks 268
Authorization Manager 294, 472–473, 481, 549
AccessCheck API 480
and Windows 2000 481
application groups 474
Authorization Store 473
console 473
creating authorization stores 473
defined 472
dynamic rules 481
operations 475
role assignments 478
roles 477
security model 472
tasks 476
vs. RS role-based security 472
authorization store
initializing 478
auto-filtering 592
AutoRefresh property 174
auto-refreshing reports 174
availability 574
available parameter values 363
available values
data-driven 95
non-queried 95
Avg function 84
AW Report Wizard
requirements 343
workflow 343
AW2000 Shared DS data source 505
AWC.RS.Extensions assembly 523
AWReportViewer
configuring 400
control 549
control properties 405
debugging 406
design goals 399, 403
handing images 404
handling parameters 401
rendering reports 403
server-side properties 400
using 401
AwRsLibrary 192, 195, 197–199, 201
AwRsLibrary assembly 193
AzMan. See Authorization Manager
azman.msc 473
 
B
 
BackgroundColor property 161
BackgroundImage Source property 112
BackgroundRepeat property 112
bands. See report sections
Base64-encoding 543
based reporting applications
and latency 569
Basic authentication 262
batching 249
BeginInvoke 375
BeginRender 374
BI 2
Microsoft Business Intelligence Platform 5
Binary Interchange File Formats (BIFF) 563
binding data regions 107
BizTalk 414
blog file 206, 210
blogging 205
BMP 176
body section, used for pseudo events 146
BookmarkID command 308
BorderStyle property 280
browser language settings 178
Browser role 220, 268–269, 271, 276, 551
Browser task 489
Build configuration 51, 204
build menu 51
building reports 51
explicitly 51
implicitly 51
Business Intelligence Project
creating 25
working with 46
Business Intelligence solution 46
business-to-business reporting 412
business-to-consumer reporting 409
 
C
 
C# code compiler
CodeDom 367
CacheManager 372
caching
and effect on report execution 238
report sessions 231
Caching Framework Application Block 371
calculated fields 81, 137, 143, 148
Calendar property 177
callback function 374
Campaigner Web service 327
capacity planning
determinig requirements 573
overview 567
process 572
case sensitivity and datasets 82
Caspol utility 282
Catalog table 224, 228, 278, 357, 496
CatalogItem collection 355
CatalogItem object 351, 355, 357
Ceiling() function 109
charts 135
data fields section 126
data region 124
Data tab 126
designing reports 124
image identifiers 323
legend 126
nesting reports 127
point labels 126
region 128
reports xxix–xxx, 3, 107, 175
types 124
ChartSpace 425, 450
ChartSpace component 446
CheckAccess 558
Children statement 442
ChunkData table 234
circular references
and expressions 148
Cizer’s home page 62
Cizer’s Quick Query 60
Cizer’s Report Builder 62
ClearSession command 308
ClickOnce 376, 604
deployment model 338
client-side reporting 383
dynamic hyperlinks 385
hyperlinks 384
server-side generated hyperlinks 387
static hyperlinks 385
client-side validation 347
Client-to-Fa?ade-to-Report Server 264, 337, 380
and extranet applications 382
application scenarios for WinForm clients 341
challenges for WinForm clients 341
introduced 339
report generation for WinForm clients 369
scenarios 341
security, WinForm clients 342, 370
Client-to-Report Server 263, 337, 378–379, 381, 395
advantages for WinForms 339
introduced 339
report generation with WinForm clients 368
CLR. See Common Language Runtime
clustered deployment 10
code access policy 537
code access security 197, 260, 296, 338
and custom assemblies 189
and custom delivery extensions 543
bypassing 284
code groups 284
configuration files 286
custom permission sets 287
dealing with unmanged resources 289
default RS settings 285
elevating 288
managing 286
overriding 283
overview 281
permission sets 284
policies 196, 281–282, 543
Code Editor 186–187
Code element 186
code generators 366
code groups 284
creating 287
Code keyword 190
Code member 184
code profilers 569, 589
code sample
Access Options 312, 583
Ad Hoc Reporter 56
Adventure Works Data Miner 424
Adventure Works Enterprise Reporter 458
Adventure Works Report Viewer 399
Adventure Works Report Wizard 342
Adventure Works Web Reporter 383
ApplicationDataset 408
AW Campaigner 327
AWReporter Demo 402
AWRsHttpModule 561
Campaigner 511
Campaigner Web service 330
Data Miner 427
GetProductInventory 413
Inventory Browser 414
Inventory Levels 413
RDL deployment 245
Report Picker 390, 526
RS Console 250
SetProperties 358
standard e-mail subscription 497
triggering subscription 511
Using rs.exe 253
Web Behavior 393
Writeback Demo 389
code security policy 193
Code tab 186
code-based security 10
CodeDom 349, 376, 543
using for custom parameters 366
CodeGroup element 197
collapsed command 311
collection syntax 150
Color property 154
column groups 132
COLUMNS dimension 441
CommandExecute event 452
Common Language Runtime 188, 260
compiling reports 51
Computer Management console 274
Compuware Application Expert 569, 593
Compuware DevPartner 576
concurrent users 570
conditional formatting 151, 169, 201
Configuration Manager 49
Configuration Properties 202
ConfigurationInfo table 74, 219, 232, 309
connection
database connection 64
connection pooling 264
connection string 73
Content Manager role 220, 269, 271, 274
converting from Access 53
cookie management
and custom security 555
cookie-less report sessions 309
cookies, for report session management 308
Count() function 163
CountDistinct() function 163
CountRows() function 155, 163, 187
CPU utilization 572, 576
Credentials Stored Securely in the Report Server 264
and connection pooling 73
Credentials tab 528
CrossJoin function 442
crosstab reports 43, 129, 175, 191
defined 3
designing 129
dynamic groups 131
static groups 132
subtotals 133
Crystal Reports
converting from 62
CSV export format 20
cube
aggregations 421
creating 427
dimension tables 421
dimensions 421
fact table 421
measures 421
private dimensions 429
processing 440
schema 438
shared dimensions 429
star schema 433
storage model 439
Cube Editor, Data tab 440
CultureInfo 180
culture-neutral format strings 177
CurrentPrincipal 261
custom application authorization 472
custom application security 294
custom assembly deployment 196
custom authentication 159
implementing 555
custom authorization
implementing 558
custom code 161, 295, 517
debugging 201–202
debugging challenges 49
options 184
tracing 201
custom configuration store 459
custom data entities 349
custom data extensions 100
debugging 537
custom dataset data extension
and typed datasets 527
download location 564
implementing 533
testing 531
custom delivery extension 487, 537
debugging 544
implementing 540
Custom element, RDL 56
Custom .NET code 9
custom parameters 345, 347
and self-configured UI 364
validation 312
custom properties 357
for handling custom parameters 361
Custom report items 592
custom security 261, 379
GenericPrincipal 559
group assignments 559
IPrincipal.IsInRole 560
limitations 548
vs. anonymous access 262
custom security extension 379, 382, 546
advantages 381
cons 382
debugging 560
implementing 553
CustomParameters property 357
 
D
 
data consolidation 418, 423
data differentials 167
Data element
RSReportDesigner.config 68
RSReportServer.config 69
data extension 524
defined 68
supported 67
data hiding 294
Data Link Properties 66
Data Output settings 205
Data Output tab 205, 208, 210
data processing extensions 10
data provider 66
data reader 387
data regions 42, 103
advantages 108
and multi-section reports 108
binding 108
chart 107
defined 107
list 107
matrix 107
overview 107
placing side by side 108
table 107
using in place of subreports 106
Data relations 525
data source 63–64
authentication options 69
defined 64
deploying 77
limitations 100
properties 66
report specific 65
shared 66
data source authentication
best practices 76
credentials stored securely in the report 72
credentials supplied by the user running report 70
no credentials 73
Windows NT Integrated Security 72
Data Source dialog 65, 79
Data Source tab
Report Manager 69
Data Sources page 230
Data tab 45, 63, 66, 80, 92
Data Transformation Services 6, 423–424, 427
data type casting 94
data warehouse 417
vs. OLAP 417
database authentication
and Client-to-Report Server model 264
database connection pooling 72–74, 101
monitoring 75
prerequisites 73
database schema
retrieving 57
Database server utilization 572
Database.dbp 427, 504
DataBinder 388
data-bound controls 107
Data-driven localization 179
data-driven subscription 487, 491, 504
defined 490
example 503
recipient query 491
scenarios 491
dataset 107
accessing bound reports 532
creating 79
creating a schema 526
creating queries 84
definition 77–78
fields 81
filters 83
Dataset dialog 81, 92
dataset-bound reports 526
DataSetName property 107–108, 115
DataSets element 58
DataSource parameter
and custom dataset extension 529
DataSource table
ReportServer database 72
DataSources element 58, 66
DatePart function 112
DateTime parameters 365
DateTime structure 94
DateTimePicker control 365
db_datareader role 76
DbgView 561
utility 288
dealing with nulls 155
Debug menu 560
Debug Mode setting 202
debugging reports 51
debugging web controls 406
DebugLocal configuration 52–53, 204
DebugView 311, 583
tool 201, 211, 258
DefaultTraceSwitch setting 217, 258
delivery extensions 487
configuring 493
defined 10
settings 507
supported 22
delivery features 9
Deploy
configuration 51, 204
menu 52
deploying reports 52
first report 32
from VS.NET 52
programmatically 245
single report 52
deployment features 11
deployment guide 591
deployment options 42
Descendants statement 442
Details Grouping button 112
developer edition 4, 591
device settings 368
as shown in figure 10.8. 348
HTMLFragment 404
overview 306
Dimension Wizard 435
dimensions 421
fine tuning 436
Direction property 134
distributed applications 339
DLL Hell 338
DocMapID 308
document map 170
and rendering formats 173
defined 171
implementing 172
label 172
drilldow report
defined xxviii, xxx, 3
drilling down 43
drill-through reporting 169
and Office Web Components 451
defined xxix–xxx, 3–4
DTS. See Data Transformation Services
Dundas Software 124, 141
dynamic columns 43, 132
dynamic connection strings 67
dynamic hyperlinks 384–385
dynamic reports
benefits 444
defined 443
dynamic sorting 157
Dynamic Web Service invocation 543
Dynamic XML Web Services Invocation sample 564
DynWSLib 543
 
E
 
Edit Details Group button 120
Edit Item Security 274
e-mail data-driven extension
configuring 505
e-mail delivery extension 493
configuring 493
introduced 22
embedded code 193, 197
Code Editor 186
definition 184
example 185
limitations 184
maintaining state 185
overview 184
vs. expressions 186
embedded functions
expression-based queries 88
EMF 176
encryption key 254
EndRender 374
Enterprise CAS policy 282
enterprise edition 4, 591
enterprise reporting 457
complexities 457
configuration store 462
framework requirements 457
report adapters 468
reporting fa?ade 461
errors, dealing with for SOAP access 320
Eval javascript function 366
evaluation edition 4
event
RS Report Object Model 150
subscriber-publisher design pattern 485
Event table 487, 510, 545
EventData 510
EventProcessing 510
evidence 281
Excel export format 19
Exchange Server
using as mail server 494
ExecuteReader 534
execution caching 230, 233, 589
example 234
how is affected by parameters 235
invalidating 236
prerequisites 234
execution log 255
defined 255
sample 423
Execution Log DTS package 578
Execution page 220, 230, 235
Execution permission set 284, 286
Execution rights 196
execution stage 17, 230
Execution tab 501
ExecutionLog Business Intelligence project 256, 579
ExecutionLog DTS package 255–256
ExecutionLog table 255, 578, 581
ExecutionTime 159
expanding columns. See dynamic columns
exploded pie chart type 126
export format 173, 348, 368
CSV 176
Excel 176
HTML 173
HTML OWC 174
image 176
MHTML 174
PDF 176
XML 176
exporting
to XML 204
using HTML Viewer 310
Expression Editor 143, 181
expression scope 146
expression sequence processor 145
expression-based queries 87, 97
expressions
compilation errors 147
dealing with errors 147
defined 143
disadvantages 143
execution order 145
overview 143
scope 146
syntax rules 145
using for calculated fields 81
extensibility 184
defined 517
features 9
Extension object 315
external code 187
advantages when using custom code 187
calling instance methods 190
calling shared methods 189
deployment 188
referencing 188
external functions 160
external resources 47
Extraction, transformation, and loading 422
extranet applications 382
reporting model 382
security considerations 383
 
F
 
fa?ade 339
fa?ade layer
and extranet applications 382
defined 264, 341
using for custom security 294
fact table, creating 428
factory design pattern 353, 468
field expression 143
Fields collection 143, 155–157
Fields tab 81
Fields toolbox 46, 88
Fields window 115
File Share delivery option 501
configuring extension 493, 495
example 499
FileSystemObject 395
filtering data 83
Filters tab 83
finding text
using HTML Viewer 310
First() function 84, 163
folder namespace 303
defined 224
logical partitioning 227
organizing 272
overview 224
folder Properties page 225
folders
requesting by URL 303
forecasting 192
form inheritance 352
Format command 306
Format function 132
Format menu 46
Forms Authentication 265, 380–381, 409, 548, 552, 556, 564
configuring 410
FQDN 494
freeform reports 107
defined xxviii, xxx, 2–3
designing 119
grouping data 121
with nested regions 119
with side-by-side data regions 123
FullTrust permission 193, 284, 286–287
fully qualified type name 190
functions, aggregate 161
overview 160
 
G
 
Generate events
task 511
generating RDL 56
Generic Query Designer 86, 529
expression-based queries 87
GetApplicationOperations API 480
getBestForecast method 196
GetChildRows method 525
GetDataSourceContents command 304
GetProperties. See SOAP API
GIF 176
Global Assembly Cache 188
and PIAs 448
Globals collection 159
Graphical Query Designer 84, 92
and parameters 91
Diagram pane 85
Grid pane 85
limitations 86
Results pane 85
SQL pane 85
stored procedures 97
Graphical Query Generator 592
Group dialog 116
group on expressions 121
group-based security policy
custom security 552
Grouping and Sorting Properties dialog 110, 120–121, 166
groups
creating 109
defintion 43
Groups tab, table region 116
GroupsBeforeRowHeaders property 134
 
H
 
hidden parameters 311
History tab 238
History table 238
Hitachi’s RDL Generator 62
home page 62
Home folder 224, 226, 271–272, 274
horizontal data filtering 550
horizontal security 290
HTML
and subscriptions 493
export format 19
fragment 404
fragment reports 307
OWC 445
OWC export format 19
      limitations 175
HTML 4.0 173
HTML Viewer 333–335, 339, 341, 347, 359, 396, 404, 552
commands 310
features 309
limitations 311
overview 309
replacing 364
using for parameters 360
HTMLFragment device setting 307, 321
HTMLOWC 404
HTTP 1.1 583
HTTP Handler 560
introduced 14
HTTP modules 311, 560
definition 560
implementing 561
security 562
HTTP Pipelines 564
HTTP POST. See web reporting
using HTTP POST
HTTP-GET
defined 11
requests 301
HTTP-POST 333, 525–526
advantages for requesting reports 390
defined 11
hyperlinks
using for sending e-mail 168
 
I
 
IAsyncResult 374
IAuthentication interface
LogonUser 557
IAuthenticationExtension interface 554, 556
GetUserInfo 556
IsValidPrincipalName 557
SetConfiguration 556
IAuthorizationExtension interface 554
CheckAccess 554
SetConfiguration 558
ICustomTypeDesciptor interface 405–406
IDataParameter interface 533–534
IDataParameterCollection interface 533–534
IDataReader interface 533–534, 536
GetValue 535
implementing 536
IDataReader interfaceGetOrdinal 534
IDbCommand interface 533–535
CreateParameter 534
ExecuteReader 535
IDbCommandAnalysis interface 533, 535
GetParameters 535
IDbConnection interface 533, 535
IDbConnectionExtension interface 535
IDbTransaction interface 533
IDelivery interface 521
IDeliveryExtension interface
Deliver 541
ValidateUserData 541
identity impersonate 370
IExtension interface 522
SetConfiguration 540–541
IExtension.LocalizedName 539
IF. See report intermediate format
IFRAME element 398
IHttpModule interface 562
IHttpModule methodOnBeginRequest 562
IIdentity interface 261, 556
Iif() operator 87, 153
IIS logs 581
Image export format 20
image files 226
used as background 112
image report item 105
used to display logos 115
Image Wizard 115
images
and web applications 323
approaches for handling with SOAP 321
database 105
embedded 105
external 105
handing with custom image handler 404
rendering external images 321
rendering via RenderStream 322
rendering with SOAP 321
impersonate element 266
impersonating the authenticated user
and data sources 72
impersonating the user 266, 331, 342, 370
disadvantages for data source authentication 72
implementing interfaces 520
Importing from Access menu 54
Include Group Header 110
inline expressions 143
in-memory caching 371
with WinForm applications 371
InScope() function 165, 169
Installation 594
instance methods 184, 190, 201
and maintain state 189
configuring 190
instance variables 190
integrated security 264
Integrated Windows authentication 262
integration approach
choosing 334
interactive features 117, 129, 181, 332, 340, 381, 549
interface
achieving standartization 521
casting 522
definition 520
inheritance 519, 522
multiple inheritance 522
type discovery 521
interface-based programming 467, 518
benefits 521
overview 518
the need of 518
intermediate format 230–231, 358
Internet access
configuring RS for 381
Internet applications
reporting model 379
Internet-oriented applications
and latency 569
Internet-oriented reporting
and security 546
interoperability 210
intranet applications
and Client-to-Report Server model 263
reporting model 378
security considerations 379–380
intranet reporting
custom security 550
IntraVNews 205, 484
RSS reader 208
InvokeRequired 375
IPrinicipal interface 261
IReportAdapter interface 467
IsAuthentic function
Forms Authentication 411
IsInRole 292
IsMissing property 156
IsNewExecution property 325
IsNothing() function 155
isolated storage 57
ISubscriptionBaseUIUserControl interface 540
UserData 541
item-level roles 269
item-level tasks 268
ItemNamespaceHeaderValue 357
ItemNamespaceHeaderValue property 357
 
J
 
J# library project 194
Joint Application Development 41
JPEG 176
Jump to URL hyperlink 168
 
K
 
KeepForFiles setting 258
Kerberos 217, 259, 262, 264, 266, 465
 
L
 
Label property 172
Language Preference dialog 178
Language property 159, 178
latency
application 568
defined 568
getting a breakdown of 569
network 568
total latency time 568
what-if analysis 570
Layout tab 45, 92
report properties 139
Layout toolbar 46
Level() function 165–166
licensing requirements 5
linked reports 240
defined 240
linked servers 64
LinkTarget device setting 389
List Folder Contents task 304
List Group dialog 120
list region example 120
list report region 135
ListChidren command 303
live execution 345
LocaleID 180
localized reports 159, 177
techiniques 179
locks database 81
log files 255
Longhorn 369
 
M
 
Machine CAS policy 282
MachineKey 578
Manage all subscriptions
task 491
Manage individual subscriptions
task 495–496
Manage Jobs 222
Manage Shared Schedules task 221
managed report 8, 47, 51–52
management API 242
management features 8
management utilities 254
management with Web service 242
managing content 223
managing folders 227
managing jobs 222
managing reports 228
margins settings 104
matrix region 193, 198, 200, 421
advantages 129
and OLAP reports 441
interactive features 130
rotating data 129
matrix report region 43, 107
columns section 132
rendering 134
Rows section 132
subtotals 133
virtual columns 129
MaxActiveReqForOneUser setting 217
MDX 440
parameterized queries 442
measures 420
Member Keys Unique 437
Member Name
property 438
memory capacity recommendations 590
Memory utilization 572
menu control for ASP.NET 415
method batching 249
MHTML 321, 493, 499, 542, 571
advantages for e-mail delivery 493
export format 19
Microsoft Access
generating reports using OLE Automation 469
importing reports 53
supported versions 53
vs. Reporting Services 53
Microsoft Application Blocks 371, 376
Microsoft Business Intelligence Platform 5, 422
Microsoft Configuration Application Block 468
Microsoft Graph 124
Microsoft Java Language Conversion Assistant 194, 211
Microsoft Message Queuing 471, 481
Microsoft Messenger 484
Microsoft Network Monitor 569
Microsoft Office 2003 444
Microsoft Office Chart 11.0 447
Microsoft Office PivotTable 11.0 447
Microsoft Office Web Components 130
Microsoft OLE DB Provider for ODBC Drivers 66
Microsoft OLE DB Provider for OLAP 447
Microsoft Outlook 484
Microsoft Persistence provider 445
Microsoft Query 427
Microsoft SOAP toolkit 318
Microsoft SQL Server 2000 Reporting Services. See Reporting Services
Microsoft WebService behavior 393
Microsoft XML Parser 329
Microsoft XML Parser SDK 336
Microsoft.ReportingServices.DataExtensions 68
Microsoft.ReportingServices.Interfaces 522
Microsoft.ReportingServices.Processing assembly 149
Microsoft.ReportingServices.XmlRendering 205
Microsoft.VisualBasic assembly 160
Microsoft.VisualBasic namespace 160
missing data 186–187
missing fields 156
missing parameter value
URL access 305
mixed-security mode 548
mixed-security model 551
MOLAP 439
mscorlib assembly 160
MsgBox function 160
used for debugging 201
MSMQ. See Microsoft Message Queuing
MSReportServer_ConfigurationSetting 252
MSSoapT 583
multicolumn reports
designing 138
testing 140
Multidimensional expressions 440
multiple columns 139
multiple datasets 83
limitations 84
when to use 83
multiple report providers
supporting 459
multiple SQL statements
executing 86
Multiple-resultset stored procedures 101
multi-select parameters 347
implementing 362
multi-stream exporting formats 321
multi-stream rendering formats 542, 578
multi-threaded WinForm applications 374
multi-threading 372, 376
multi-value parameters 89, 312, 360, 592
IN operator 361
My Reports 220
AW Data Miner 449
My Reports folder 224
My Reports role 220, 269
My Subscriptions 495
MyComputer zone 284
 
N
 
named parameters 90
NamedPermissionSet class 285
naming convention
for report items 110
navigation action
bookmarks 168
report 168
URL address 168
navigational features 167, 388
and rendering formats 173
defined 167
hyperlinks 168
used for write-back reports 388
nested expression scopes 147
nested groups 121
nesting regions 122, 161
.NET Configuration console 282
.NET data provider
definition 67
.NET Reflector 190, 211
.NET Remoting 190, 369
.NET SqlClient provider 73
network capture 570
network delays and latency 569
New Data-driven Subscription button 493
New Subscription button 493
newsreaders 206
NoRows property 108
Northwind database 54
Nothing values 155
Notification object 541
UserData property 541
notification object 487, 538
Notification.Render 546
Notifications table 487
NULL rendering extension 315
NULL session 264
NULL values 186
dealing with 155
NumericalLanguage property 177
NumericalVariant property 177
 
O
 
Object Browser 293
object collections 144
object-oriented programming 518
model 12
observer design patter 484
ODBC-compliant databases 64
Office Web Components 174, 176, 443
as ad-hoc tool 444
how they work 446
implementing custom actions 452
installing 447
Primary Interop Assemblies 444
Office Web Components 2003 454
OfficeWriter 176, 565
OLAP 2, 64, 418
complexities 418
cube 420
cube processing 423
goals 417
integrating with Reporting Services 441
overview 417
Sample Reports 454
solutions 422
storage model 419
vs. OLTP 417
OLE Automation 469
OLE DB-compliant databases 64
on-demand delivery 9, 20, 299, 483
access options 300
overview 300
Online Transaction Processing 64
OpenForecast
migrating to .NET 193
overview 192
supported forecasting models 192
Oracle data extension 90
OutputDebugString 201
OutputFormat
device setting 306
OverwriteDataSources
setting 77
OWC. See Office Web Components
OWC11 library 448
OWCConfiguration section 175
 
P
 
page body 104
Page Break property 109
page breaks 109, 121
Page Footer 104
menu 103
section 103
Page Header 104
menu 103
section 103
page size property 104
PageBreakAtEnd element 120
PageBreakAtEnd property 109
PageNumber 55, 159
PageNumber property 159
pages per second 570
paging
explicit 109
using hyperlinks 170
parameter available values 363
parameter default values
URL access 305
parameter limitatinos 101
parameter lookup values 113
Parameter object 157
parameter placeholders 310
parameter type validation 100
parameter validation
URL access 305
parameter-driven queries 90
parameter-driven reports 89
and subscriptions 499
parameterized reports
and multiple datasets 83
parameters
and snapshots 502
and subscriptions 488
custom parameters 359
data type 94
database-driven approach 361
default values 94
handing with HTTP-POST 391
non-queried available values 95
prompt 94
query-based available values 98
validating 366
validating custom parameters 365
Parameters collection 157
defined 157
labels and values 157
Parameters command 311, 396
Parameters page 229
Parameters tab 82, 91, 97
ParameterTypeEnum 363
ParameterValue object 320, 395, 488
Parent Group setting 166
PDF export format 19
performance
bottleneck defined 576
bottlenecks, identifying and eliminating 572, 576
defined 567
scalability white paper 590
WinForm clients 370
Performance Console 73
performance counter 572
ASP.NET Applications/Requests Queued 576
memory: available bytes 576
network interface: Bytes Total/ sec 576
Process(aspnet_wp)\% Processor Time 572
Process(sqlservr)\% Processor Time 572, 576
Processor(_Total)\% Processor Time 572
Processor: % Processor Time/ Total 576
performance counters 572
performance metrics 580
performance testing 584
permission set 267
creating 287
defined 284
PermView utility 288
persisted to files datasets 524
personalizing subscriptions 491, 503
PIA. See Primary Interop Assemblies
pivot reports 129
PivotTable 425, 444, 450
determining user selection 451
Selection property 451
vs. matrix region 130
PNG 176
Policies table 267
policy inheritance 271, 277
PollingInterval setting 487
polymorphism 521
PolynomialRegressionModel model 196
POP3 513
POP3 service 494
Preview tab 45, 48, 95, 147
and custom security 48
Preview window 49, 197, 203–204, 285
advantages 49
and CAS 286
and custom security 49
how to use 49
simulating Report Server environment 49
previewing reports 47
for unit testing 42
how it works 47
preview tab 47
preview window 47
Previous() function 165, 167
Primary Interop Assemblies 444, 470
installing 447
primary UI thread 374
principal 261
printing reports 312
printing reports programmatically 312
PrintOnFirstPage
property 104
PrintOnLastPage property 104
private assembly deployment 188
private data source
and custom dataset extension 527
Processes dialog 202
processModel
model 266
Process.Start 369, 372
method 316, 320
production configuration 52–53
profile store 549
project configurations 49, 52
Properties dialog 144
Properties window 144
pseudo events 145, 280
publisher 485
Publisher role 220, 269
pushing reports 484
Put() WMI method 252
 
Q
 
QA testing 42
query hints, using to prevent locks 329
query parameters and custom dataset extension 529
Query tab 79
query timeout 80
Queue Listener Service 470
queuing 470
 
R
 
raw report 18
RDL. See Report Definition Language
read-only parameters 94, 311
recipient data store 504
recipient query 505
rectangle report item 106, 115, 121, 128
used to enclose fields 121
using to enclose other items 106
recursive hierarchies 165
RedirectFromLoginPage method
Forms Authentication 411
References tab 188
Refresh meta tag 174
Refresh Report button 308
refreshing fields 81
Release configuration 52–53
RemoteCall property 358
Render command 306
rendering extensions 563
defined 10
rendering formats 18
rendering page 230
rendering reports
first report 33
rendering stage 17–18
RenderReport web method 464
Replication Services 6
report 103
anatomy 103
archiving 484
catalog 8, 51, 216
construction phases 42
consumer 13, 461
datasets and scope 163
defined 2
definition 39, 65, 184, 226
delivery 20, 22, 32, 216
elements 103
execution 230, 234
execution caching and its effect on performance 589
execution options 358
files copying 46
footer 104
forecasting 191
header 104, 114
image 105
interactive features and SOAP 326
intermediate format 18, 74, 589
lifecycle 22, 39, 215
line 105
management 15, 22, 32, 215–216
overview 105
paging 109
properties 104
prototype 41
providers 461
rectangle 105
rendering 173
rendering commands 306–307
repository 8
response times 578
sections 103–104
selecting 122
subreport 105
textbox 105
types 3
report authoring 22, 40
analysis 41
construction 42
deployment 42
options 43
testing 42
Report Borders
toolbar 46
report caching 230, 576
and ExecutionTime 159
using to minimize RS latencies 569
Report Configuration Store 462
schema for enterprise reporting 461–462
Report Definition Language 7–8, 184, 450
advantages 55
extend 56
generating programatically 55
main advantages 8
making changes 46
schema 55
specification 62
used for ad hoc reporting 61
viewing 46
Report Delivery Options screen 490
Report Designer 102, 104, 107–108, 115–116, 122, 140, 286
folder 188, 196
introducing 7
tabbed user interface 45
vs. Report Server 47
report execution log 569, 574, 577–579, 581
analyzing 578
determining the number of report requests 577
finding out the most popular reports 581
Report Execution timeout setting 219
report exporting commands 306
Report Formatting toolbar 46
Report item dropdown
using for visible on-demand groups 117
Report Items toolbar 103
Report Items toolbox 46
Report Manager 15
and Client-to-Server model 263
and impersonating the user 266
and subscriptions 486
configuring 217
deployment 217
how it works 216
implementation 216
installing 217
main tasks 15, 216
overview 216
session state 217
using for report delivery 218
Report menu 46, 92
Report Object Model
limitations 148
overview 148
report parameters
creating 92
data-driven subscriptions 508
role of 89
using for dynamic sorting 158
Report Parameters submenu 92
Report processing 17
execution stage 18
Report Processor 13
Report Properties dialog 109, 140
report request 13
and custom reporting framework 461
explained 571
submitting 464
vs. page requests 571
report sample
Alphabetical List of Products 54
AW Report Wizard 343
Catalog 475
Corporate Hierarchy 165, 273, 499
Customer Orders 412, 509
Customer Orders Custom Auth 551
Employee Sales by Territory 161
Employee Sales by Territory Advanced 161
Employee Sales by Territory Freeform 121
Employee Sales by Territory with Summary 123, 151
Employee Sales by Territory with Summary Advanced 146, 156, 162
Employee Sales by Territory with Summary Chart 126, 170
Employee Sales Freeform 119, 244, 291, 293, 358, 385
Employee Sales Freeform Secured 291
Employee Sales Freeform with Chart 127, 497
Employee Sales Tabular Interactive 117, 307
Inventory Levels 412
Monthly Sales by Product Category 164
My Orders 409, 552
Product Catalog 207
Product Catalog Localized 177, 179
Purchase Orders 358, 360
Report Picker 393
ReportsExecutedByDay 256, 579
ReportsExecutedByHour 579
Sales by Category 475
Sales by Product 187, 191
Sales by Product Category 49, 199–200, 282
Sales by Territory 24, 45, 78, 103, 109, 301, 385
Sales by Territory Crosstab 326
Sales by Territory for Product Category for 2004 448
Sales by Territory Interactive 110, 157
Sales by Territory with Chart 385
Sales by Territory with Sorting 157
Sales Order Details 388
Sales Order Writeback 389
Sales Orders 391
Sales Promotion 206, 226, 327
Salesperson Summary 408
Show Security Policy 267, 277, 293
Territory Sales 160
Territory Sales by Quarter 234, 237, 241, 499, 501
Territory Sales by Store with Map 171
Territory Sales Crosstab 130, 157, 185, 386, 421, 441
Territory Sales Drillthrough 168–169, 385
Territory Sales OLAP 420, 443
TestDS 526
The Employee Sales Tabular 113
Report Selector 104, 174
Report Server
binary folder 13, 188, 196, 523
communication facades 14
configuring for e-mail delivery 494
implementation 13
introduced 13
main tasks 13
Report Server Configuration Database 357–358
Report Server Database 14
Report Server Email element 494
Report Server Temporary Database 14, 308
Report Server Web service
introduced 14
Report Server Windows Service 544–545
and the Report Server 22
introduced 21
Report Services partners 62
report session caching 308, 325, 583
affect on database connections 74
and matrix regions 135
clearing the session 308
report sessions 321
and images 321
and SOAP 324
correlating with SOAP 325
definition 231
report specific data source
advantages of 65
creating 65
report toolbar 94, 120, 305
and rendering formats 173
Report Wizard 43, 102–103, 107
and first report 28
limitations 44
report types 43
styles 43
ReportFolder 159
ReportHost 49
Reporting Fa?ade 380, 461
reporting fa?ade layer
implementing 458
Reporting Services
architecture 11
data limitations 100
defined 2
editions 4
evaluating 33
extensibility 518
partners 60
service-oriented architecture 12
Reporting Services (continued)
shortcoming 34
software dependencies 4
top ten favorite features 33
vision 1
why it is needed 2
Reporting Services Web service 21
Reporting Services Windows Service 546
running scheduled tasks 221
ReportItem class 151
ReportItems collection 151
defined 151
limitations 154
ReportItems element 58
report-level parameter 92, 534
and custom dataset extension 530
creating manually 93
orphaned 93
removing 93
using for passing data 92
ReportMagic 577, 593
ReportName property 159
ReportParameter object 364
ReportParameters property 104
ReportRequest entity 465, 467
Reports
table 581
Reports folder 46
Reports menu 103
ReportServer database 14
ReportServerTempDB 14
ReportServerUrl 159, 498
setting 243
ReportServerUrl setting 217, 556
ReportService.asmx 246, 317, 319
ReportServiceHttpHandler 301
ReportViewer
and URL access 398
configuring 396
how it works 397
limitations 399
overview 396
server-side configurable options 396
ReportViewer control
configuring 398
overview 396
request distribution 578
requesting reports by SOAP 318
requesting reports by URL 305
requests per second 570, 574
resources
and the report catalog 226
response time 574
retrieving reports 354
Revert to Parent Security button 277
rich client
advantages 338
deployment model 338
overview 338
role
and custom security 551
defined 268
role-based authorization
overview 266
role-based security 261, 340, 354
and the Web service 277
defined 270
managing with Report Manager 272
overview 261
purpose 261
Roles table 267–268
Root Member If
property 437
Rosetta 592
Rosetta Stone xxi
row groups 132
RowNumber() function 109, 161
ROWS dimension 442
RPS 584
RS Catalog Explorer 244, 333
RS Windows Service
subscribed report delivery 487
rsactivate 254
rsconfig 254
rs.exe 253
RSExecutionLog database 578
rskeymgmt utility
purpose 254
rsmgrpolicy.config 286
rspreviewpolicy.config 197, 204, 286
RSReportServer.config 494, 510
SMTP 494
RSS 327, 484
RSS feed 205
RSS schema 207
RSS specification 207, 211
rssrvpolicy.config 197, 286
running jobs 223
cancelling 223
types of 223
running totals 163
RunningJobs table 223
RunningRequestsDbCycle setting 223
RunningValue() function 164
using for running totals 164
 
S
 
sample report
Sales by Territory Interactive 90, 92
sample, RS management console 251
scalability 470, 567
defined 567
features 10
scalability linear
achieving by scaling out 591
scaling out 591
scaling up 590
Schedule page 221
schedules
overview 220
report-specific 220
shared 221
script host 253
scripting 253
with Authorization Manager 477
securable items 269
securable resources 277
SecureConnectionLevel setting 294–295
securing presentation layer 465
securing reports 290
filtering data 291
hiding data 294
with dynamic queries 292
security
evaluating requirements 290
features 10
overriding policy 277
security extension 261
defined 10, 262
Security Manager 467, 478
SecurityException 281
SecurityManager.PolicyLevelFromFile 283
securityPolicy element 283, 288
SelectionChanged event 451
SendEmailToUserAlias setting 489, 497
server-side generated 384
hyperlinks 387
server-side report generation 383, 399
ServerXMLHTTP 302
component 301
Service Pack 1 106
service-oriented architecture 11, 89, 149
benefits for integrating 89
session caching
configuring 232
how it works 231
overview 230
using cookies 232
session cookie and custom security 547–548, 554
session identifier 232
SessionData table 325
SessionHeader proxy class 325
SessionHeaderValue proxy class 233
SessionId member 325
SessionID property 233, 370
SessionTimeout setting 73, 232
setting
PollingInterval 221
TargetFolder 25
TargetServerURL 25
UnderDebugger 546
UseSessionCookies 232
Settings object 541
setup logs 255
SETUSER system function 72
shaking reports 138
shared class-level fields 189
shared connection 65
shared data source 46, 65, 226, 228
advantages of 66
creating 27–28, 66
definition 304
requesting by URL 304
Shared Data Sources folder 46
shared methods
calling 189
defined 184
vs. instance methods 189
shared queries 78
shared schedules
advantages 221
using for subscriptions 501
SharePoint Portal Server 6
Show Details button 228
Show/hide Document Map 310
ShowHideToggle command 307
side-by-side data regions 108, 123
site settings 219, 268
Site Settings menu 274
Site Settings page 219
SMTP 513
SMTP service 494
SMTPServer setting 494
snapshot caching 230, 236, 307, 345, 358
advantages 236
limitations 237
vs. execution caching 236
Snapshot command 307
snapshot execution 345
snapshot history 220, 237, 307, 345
Snapshot refreshes 486
snapshot reports 240, 359, 486
and subscriptions 500
SnapshotData table 236
snapshots 220
SnapshotUpdated status 503
snowflake dimensions 431
SOAP
defined 11
overhead 569, 586
role of 317
SOAP API 357–358
calling from client-side script 392
CancelBatch() 249
CancelJob() 223
CreateDataDrivenSubscription() 488, 490
CreateReport() 248, 254
CreateSubscription() 486, 488, 490
ExecuteBatch() 249
FireEvent() 222, 509–510
FlushCache() 236
GetDataDrivenSubscriptionProperties() 512
GetPermissions() 248, 267, 278
GetPolicies() 278–279, 293
GetProperties() 357
GetReportDefinition 61
GetReportParameters() 363–364, 390
GetSubscriptionProperties() 512
ListChildren() 243, 272, 351, 354, 371–372, 466
ListExensions() 314, 368, 538
ListReportHistory() 359
ListSubscription() 512
LogonUser() 548, 552, 555, 557
Render() 319, 370, 395
RenderReport() 466
RenderStream() 322–324
SetProperties() 357–358
UpdateReportExecutionSnapshot() 237
SOAP exceptions
dealing with when using ACT 583
SOAP requests 582
SOAP Toolkit 259
SOAP Trace 243, 247, 310
SOAPAction header 562
SoapException 320
SoapException.Detail property 320
SoftArtisans OfficeWriter 563
Solution Explorer 137
sorting 592
Sorting tab 158
source control 52
Source property
image report item 105
Spreadsheet 450
SQL Agent, subscribed report delivery 487
SQL Data Adapter 527
SQL Injection attacks 88, 97
preventing 88
SQL Server 2005 controls 56
SQL Server Agent 21, 485
used for scheduled tasks 221
SQL Server benchmarks 423
SQL Server Query Analyzer 569
SqlClient, Current # pooled connections counter 75
SSL 550
SSL connection 294, 556
stand-alone Report Designer 45
stand-alone reporting 56
standard database authentication 71
standard edition 4
standard e-mail subscription
example 497
standard OLAP reports
authoring 440
standard report toolbar
preview tab 48
standard reports 453
standard subscriptions 490
Standard toolbar 46
star dimensions
creating 429
StartItem property 49
StartItem setting 537
stateless architecture 185
static groups 132
static hyperlinks 384–385
storage configuration
cubes 439
Storage Design Wizard 439
stored credentials 488
Stored data source credentials 487
stored procedures
advantages 96
calling web services from 329
creating 97
used for data sources 96
using 199
using for queries 97
StreamIds argument 322
StreamRoot device setting 322–323, 405
StreamRootPath
device setting 370
strong-named assemblies 188
style templates 43
subreport item 106
subreport report item
Properties dialog 137
subreports
configuring 137
designing 135
synchronizing with master 137
when to use 135
subscribed delivery 21, 299
and shared schedules 220
triggering programatically 509
subscribed report delivery 9
and Internet applications 503
configuring 488
events 486
how it works 485
overview 484
restrictions 487
scenarios 484
subscriber 485
subscriber-publisher design pattern 484
subscription events 508
Subscription Wizard 492, 505
subscriptions 486
creating 488
creating with Report Manager 489
deactivated 488
managing with Report Manager 495–496
Subscriptions tab 490
Subscriptions table 496
Subtotal menu 133
Sum() function 84, 147, 161, 163
Switch() function 153
System Administrator role 268–269
system jobs 223
System User role 268
System.Convert namespace 160
System.Data.Odbc 68
System.Data.OleDb 68
System.Data.SqlClient 68
system-level roles 268
system-level tasks 268
System.Math namespace 160
 
T
 
Table Footer property 112
table region 55, 115
creating groups 116
generating columns and cells programmatically 60
limitations 119
RDL definition 59
table region groups
creating 110
creating totals 112
details grouping 112
table region selector 116
table triggers
used to call web services 327
tabular reports 43, 107
defined xxviii, xxx, 2–3
designing 109
parameterized 113
with interactive features 117
TargetFolder setting 52, 226
TargetServerURL setting 52
Task List 51
Task table 268
tasks
creating with Authorization Manager 476
tcpTrace 243, 247, 259, 310, 583
test scripts 575
creating 581
test use cases 575, 580
testing environment
for performance testing 575, 580
the Generic Query Designer
executing multiple statements 86
The Report Designer
overview 44
third-party tools 60
thread culture 181
throughput 570, 573, 575
and virtual users 571
concurrent users 570
establishing benchmark 574
establishing benchmark empirically 574
establishing benchmark theoretically 574
finding the peak 570
requests per second 570
TIFF 176
tight coupling 89
time dimension 433
time to last byte 568, 585
Time-based events, 486
TimeDataRetrieval time 578
TimeProcessing time 578
TimeRendering time 578
Toggled visibility
and rendering formats 173
toolbar 48
Toolbar command 311, 396
Tooltip property 169
TotalPages 159, 498
TotalPages property 159
trace log files
analyzing 257
managing 257
trace logs 255
tracing
DebugView 258
utilities 243
web methods 242
Transaction Processing Council 423
transactions 80
triggering subscriptions 545
trusted subsystem 265–266, 331, 370, 380
TTLB 568
typed datasets 464
advantages 349
and custom dataset extension 525
clients limitations 350
TypeOf operator 521
 
U
 
unattended report requesting 327
UNC 495
UnderDebugger setting 546
Uniform Naming Convention
definition 500
UnionCodeGroup 284
unit testing 42
up-level browsers 173
uploading report definition files 58
uploading reports 51
uploading resources 226
URL access 20, 300, 339
and custom security extensions 547
and Internet reporting 379
and security 326
commands 306
cons 333
disabling 301
evaluating 332
integration techiniques 301
overview 301
passing parameters 305
performance advantages 333
programming techniques 301
pros 332
report session management 308
requesting images 303
requesting resources 303
security considerations 379
shelling out to the browser 316
syntax 302
url encoding 302
using LinkLabel 302
URL length limitations 333
URL munging 232
Use single transaction option 80
User CAS policy 282
User collection 159, 487
user identity 261
user job 223
definition 223
user principal 478
user-defined aggregate functions 165
UserEntity entity 466
UserID property 159, 234
User.Language property 177
Users Folders 220
Users table 267, 496
User.UserID 291
UseSessionCookies setting 232, 309
utilization 572, 575
 
V
 
Value property
Field object 155
ReportItem 154
View Code command 78
View Data Sources task 304
ViewReport button 537
virtual users 575
visible-on-demand groups 117
Visual SourceSafe 52
 
W
 
web access 334
web behaviors 318
Web Browser control 301, 303, 312–313, 316
referencing 314
web farm 591
web log 206
web method
FireEvent 221
invoking asynchronously 374
web method (continued)
LogonUser 547
Render 318
RenderReport 408
web reporting
client-side 384
overview 378
server-side 395
using HTTP POST 390
web server logs 577
Web service 21
creating a reference to 318
delivering reports to 543
evaluating 334
referencing 246
Web service access 300
integration scenarios 317
integration techniques 317
overview 317
report session management 324
Web service behavior 318
Web service proxy 246, 317
and report sessions 324
setting 246
Web service report delivery 537
Web Services Enhancements 415
WebBrowser control
documentation 336
Navigate method 316
WebRequest object 301–302
WebService Behavior
download location 415
webservice.htc 393
Whidbey 338
Windows
authentication 159, 218, 234, 261–262, 330
event logs 255
Forms DataGrid control 355
group membership
      determining 292
Management Instrumentation
      defined 250
NT Integrated Security option
      effect on connection pooling 75
WindowsPrincipal.IsInRole 292
WinForm clients
and Client-to-Report Server model 339
and the Client-to-Fa?ade-to-Report Server model 341
recommended reporting model 339
security 340
WinForm control 592
WMF 176
WMI provider 249–250
advantages for management 250
write-back reports 388
WSE 415