MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))

cab file, 538

cache, 27

cache file, 280

caching, 472–481.

See also memory

data source credentials, 475

data-driven subscriptions and, 504–505

described, 473

enabling, 476–477

execution snapshots, 481–484

report deployment, 480

report expiration, 474–475, 478–479

report formats, 475–476

report parameters, 480

report previews, 280–309

Report Server, 576

ReportingServices.css file, 511

security and, 481

viewing reports from cache, 477–478

calculated attributes, 708–709

calculated fields, 106–109

calculations

column values, 329–334

NULL values and, 107–109

Calendar property, 593

CancelBatch method, 632

CancelJob method, 632

CanGrow property, 593

“canned” reports, 696

CanShrink property, 593

cardinality of relations, 78–80

cascading style sheets (CSS), 510–511

CatalogItem class, 665–666

CellDataElementName property, 593

CellDataElementOutput property, 594

cells

borders, 178–180

described, 186

Excel, 398–399

merged, 186, 269–271

totalling values, 274–280

certficate authority, 38

Change Data Source dialog box, 123–124

Change Key function, 59

characters, special, 120

Chart Category Group item, 584

chart data region, 187

Chart element, 693–694

Chart item, 583–584

chart report item

creating reports with, 211–213

placing/populating reports, 213–216

chart reports, 734–736

Chart Series Group item, 584

Chart Value item, 584

ChartAreaBorderAndLineStyle property, 594

ChartAreaFillStyle property, 594

charts, 210–231

3-D effect, 224–231

Business Type Distribution Chart, 221–225

creating with chart report item, 210–213

creating with Report Builder, 734–736

Days in Maintenance Chart, 225–231

Fuel Price Chart, 211–221

labels, 223–224, 225

overview, 210

pie, 222–225

placing chart items, 213–216

populating, 213–216

refining, 216–218

sample. See sample charts

stacked column, 225–231

Transport Monitor Report, 374–379

CheckAccess method, 563–564

Chief Executive Officer, 6

child tables, 76–77

classes

ActiveState, 664–665

AllMembershipCondition, 437

AuthenticationExtension, 557–560

AuthorizationExtension, 560–564

BatchHeader, 665

CatalogItem, 665–666

DailyRecurrence, 666

DataRetrievalPlan, 666

DataSetDefinition, 667

DataSource, 668

DataSourceCredentials, 668

DataSourceDefinition, 668–669

DataSourceDefinitionOrReference, 669

DataSourcePrompt, 669–670

DataSourceReference, 670

DaysOfWeekSelector, 670

DocumentMapNode, 670–671

ExecutionInfo, 671

ExpirationDefinition, 672

Extension, 672

ExtensionParameter, 672–673

ExtensionSettings, 673

Field, 673

ItemNameSpaceHeader, 673

MinuteRecurrence, 674

ModelCatalogItem, 674

ModelDrillthroughReport, 674

ModelItem, 674–675

ModelPerspective, 675

MonthlyDOWRecurrence, 675

MonthlyRecurrence, 676

MonthsOf YearSelector, 676

NoSchedule, 676

ParameterFieldReference, 677

ParameterValue, 677

ParameterValueOrFieldReference, 677

Policy, 677

Property, 678

Query Definition, 678

RecurrencePattern, 678

ReportExecution2005, 663–686

ReportHistorySnapshot, 679

ReportParameter, 679–680

Role, 681

Schedule, 681

ScheduleDefinition, 682

ScheduleDefinitionOrReference, 682

ScheduleExpiration, 683

ScheduleReference, 683

SearchCondition, 683

security, 434, 435–436

ServerInfoHeader, 684

StrongNameMembershipCondition security, 435, 436

Subscription, 684

Task, 685

TimeExpiration, 685

UrlMembershipCondition security, 435

ValidValue, 685

Warning, 686

WeeklyRecurrence, 686

ZoneMembershipCondition security, 436, 438

Classes property, 594–595

CleanupCycleMinutes setting, 543

ClickOnce application, 715

clickthrough reports, 720, 729–732

client-side printing, 450

Clustered property, 595

code.

See also source code

HTML, 6–7, 8

RDL, 309–312

sample, 556–557, 625

security, 571

code access groups, 434–435

code access security, 434–436

ColdFusion, 6

color

adding with images, 232

background, 233–239, 590

border, 238, 239, 592

lines, 239, 607

text, 239

Color property, 239, 595

columns.

See also fields

adding, 296–299, 722

aliases, 177

grouping, 193–195

including in result sets, 96–98

multiple, 296–299

NULL values, 101

organization, 71–74

resizing, 134

retrieving, 95–96

sorting, 87–88, 104–105, 142

vs. fields, 73

Columns property, 595

ColumnSpacing property, 595

command parameters, 516–517

command-line utilities, 540–551

comma-separated value. See CSV

company information. See business intelligence

compilation errors, 266

Components to Install page, 44–48

composite primary key, 74

computers

name of, 414

non-Windows, 21

concatenation operator (&), 231

conference nametags, 233–240

conference place cards, 240–245

configuration

deployment, 419–420

Report Server security, 436–439

Reporting Services, 52–63, 566–570

configuration files, 542–547

backing up, 564–565

case sensitivity, 566

modifying, 566–569

permissions, 566

Connect Using options, 427–430

Connection Properties dialog box, 123–124

connection string, 122, 123.

See also data source

connections

authentication, 427–430

Database Connection page, 56–58

database server, 169–170

passwords, 121–124

properties, 170

Report Catalog, 58

SSL, 555

testing, 170

web parts, 539

ConnectionType setting, 543

constant fields, 106–109

constants, string, 102

constraints, 74

content manager privileges, 411

Content Manager role, 456

controls, 16

cookies, 553, 559

corrupt keys, 58–59, 575

COUNT() function, 111

CreateBatch method, 633

CreateDataDrivenSubscription method, 633

CreateDataSource method, 634

CreateFolder method, 634

CreateLinkedReport method, 634

CreateModel method, 635

CreateReport method, 635

CreateReportHistorySnapshot method, 635

CreateResource method, 636

CreateRole method, 636

CreateSchedule method, 636

CreateSubscription method, 637

credentials

data source, 124, 475, 668

encryption, 124, 574

prompting for, 524–525

Report Catalog, 57

Report Server, 428–429

web service, 624–625

Windows, 551

Credentials property, 625, 631

credit information update report, 5–6, 10

criteria pane, 127

crosstab reports. See matrix reports

CSS (cascading style sheets), 510–511

CStr() function, 308

CSV exports, 402

CSV (comma-separated value) format, 402, 520

custom security, 551–572

custom security code, 571

custom security extensions

changing to Windows integrated security, 556

considerations, 554–556

deploying, 564–570

using, 554, 570–572

CustomCode property, 595

Customer List Report, 117–136, 334–338

Customer-Invoice Report, 136–150

Cylinder property, 596