S


sample charts

Business Type Distribution Chart, 221–225

Days in Maintenance Chart, 225–231

Fuel Price Chart, 211–221

sample code, 556–557, 625

sample projects

charts. See sample charts

conference nametags, 233–240

conference place cards, 240–245

reports. See sample reports

sample reports

See also reports

AdventureWorks database, 27

Customer List Report, 117–136, 334–338

Customer-Invoice Report, 136–150

Delivery Analysis Report, 350–357

Delivery Status Report, 317–327

downloading database for, 116

Employee Evaluation Report, 358–366

Lost Delivery Report, 327–334

Paid Invoices Report, 379–381

Parameterized Invoice-Batch Number Report, 156–164

Payroll Checks Report, 338–344

Transport Monitor Report, 374–379

Weather Report, 345–350

Save All button, 135

Save As dialog box, 385

saving reports, 135, 729–732

scalability, 33

scenarios

credit information update reports, 5–6, 10

daily company information reports, 5

inventory reports, 5, 9

Schedule class, 681

scheduled items

execution snapshots, 495

Manage Jobs page, 510

shared schedules, 510

ScheduleDefinition class, 682

ScheduleDefinitionOrReference class, 682

ScheduleExpiration class, 683

ScheduleReference class, 683

schema, 129

scope, 278–280, 291

Search Function, 447–448

SearchCondition class, 683

searching

with Find Function, 447, 448–449

FindItems method, 639

on Report Manager website, 20

for reports, 447–448

with Search function, 447–448

SearchCondition class, 683

for text within reports, 447, 448–449

Secure Sockets Layer. See SSL

SecureConnectionLevel setting, 543

security

best practices, 572–576

caching and, 481

code access, 434–436

custom, 551–572

data-driven subscriptions and, 498–505

domain groups, 576

extensions. See custom security extensions

folders, 21, 575

history snapshots and, 488

Kerberos, 429

My Reports folder, 507–508

passwords. See passwords

Report Manager, 451–466

Report Model, 712–715

roles. See roles

site-wide, 509

snapshots and, 484

subscriptions, 496

web forms, 556

Windows. See Windows integrated security

security APIs, 30, 572

security classes, 434, 435–436

security code, 571

Security Extension API, 30

security management roles, 454–456

security models, 555–556

security role assignments, 575

security tasks, 453

SELECT query, 94–113

SELECT statement, 94–113

calculated fields, 106–109

FROM clause, 95–96

constant fields, 106–109

FIELD LIST, 95, 96–98

GROUP BY clause, 95, 109–112

HAVING clause, 95, 112–113

JOIN clause, 98–101

ORDER BY clause, 95, 104–105

WHERE clause, 95, 101–104

self-joins, 85–87

SeriesLabel property, 616

server certificates, 38

server installation, 31, 37

Server Status page, 52–53

ServerInfoHeader class, 684

ServerInfoHeaderValue property, 626, 632

servers.

See also database servers;

Report Server

e-mail, 37–38

IIS. See Internet Information Services

Report Server. See Report Server

SMTP, 60

SQL. See SQL Server

Terminal Server, 64

virtual, 538–539

Windows 2003, 40

Service Account page, 49–50

service pack, 36

SessionTimeout property, 548

SetCacheOptions method, 656

SetConfiguration method, 563

SetDataDrivenSubscriptionProperties method, 656–657

SetDataSourceContents method, 657

SetExecutionCredentials method, 630

SetExecutionOptions method, 657

SetItemDataSources method, 657

SetModelDefinition method, 658

SetModelDrillthroughReports method, 658

SetModelItemPolicies method, 658

SetPolicies method, 658–659

SetProperties method, 659

SetReportDefinition method, 659

SetReportHistoryLimit method, 659–660

SetReportHistoryOptions method, 660

SetReportLink method, 660

SetReportParameters method, 660–661

SetResourceContents method, 661

SetRoleProperties method, 661

SetScheduleProperties method, 661–662

SetSubscriptionProperties method, 662

SetSystemPolicies method, 662

SetSystemProperties method, 663

Shading property, 616

Shared Data Source button, 124–125, 139

shared data sources

advantages of, 573–574

creating, 168, 423–425

deploying, 416–419

modifying, 425

number of, 440

overview, 124–125

selecting, 139, 189

storage of, 124

using, 573–574

Shared Data Sources folder, 17

shared items.

See also shared data sources

business intelligence, 5–10

images, 232, 233

schedules, 510

SharePoint virtual server, 538–539

SharePoint web parts, 538–539

ShowLegend property, 616

ShowMarkers property, 616

ShowPointLabels property, 617

Simple Mail Transfer Protocol. See SMTP

Simple Object Access Protocol (SOAP), 21

site settings, 505–510

Site Settings page, 505–510

SiteName property, 549

site-wide security, 509

Size property, 617

Sizing property, 617

SMTP (Simple Mail Transfer Protocol), 37–38

SMTP server, 60

SnapshotCompression property, 549

snapshots, 481–491

report execution, 481–484

report history, 485–491

Report Server, 576

subscriptions and, 495

SnapToGrid property, 617

SOAP (Simple Object Access Protocol), 21

software requirements, 36

Solution Configurations drop-down list, 419–421

Solution Explorer, 17, 138, 139

Sort method, 630–631

sorting

columns, 87–88, 104–105, 142

data, 87–88, 727–729

groups, 284–288

interactive, 288–291

labels, 291–299

ORDER BY clause, 95, 104–105

purpose of, 80

query results, 87–88

result sets, 87–88

rows, 87–88, 104–105

Sorting element, 694

Sorting property, 618

source code.

See also code

multiple versions of, 312

reusing, 358–365

sample, 556–557, 625

Visual SourceSafe (VSS), 312–313, 573

Source property, 618

sources. See data sources

special characters, 120, 555

“specified” properties, 664

spreadsheet format, 8–9, 397–399

SQL Agent, 510

SQL GROUP BY clause, 186

SQL pane, 127

SQL Server 2000

installing, 26, 42

Report Catalog database compatibility, 18

system requirements, 36, 37

SQL Server 2000 Reporting Services. See Reporting Services

SQL Server 2005

installing, 26, 42–52

Report Catalog database compatibility, 18

system requirements, 36, 37

SQL Server 2005 setup program, 42

SQL Server Agent, 26–27, 49

SQL Server Books Online, 29

SQL Server Installation Wizard, 43–52

SQL Server login, 41–42

SQL Server Management Studio, 713–715

SQL Server Personal Edition, 37

SQL Server versions, 37

SQLCommandTimeoutSeconds setting, 543

SSL (Secure Sockets Layer), 38, 54, 555

SSL connection, 555

stacked column charts, 225–231

stored procedures, 129, 301–303

StoreRSLogon project, 556–564, 570–571

string constants, 102

string literals, 102

strings, 308, 515

StrongNameMembershipCondition security class, 435, 436

Stsadm utility, 538–539

Style element, 694

style sheets, 510–511

styles

borders, 239, 592

cascading style sheets, 510–511

fonts, 180–181

lines, 608

table, 131–132, 136, 145

Subreport item, 589

subreports.

See also reports

drilling down with, 366, 368–370

as reusable code, 358–365

in tables, 366–367

Subscription class, 684

subscription delivery, 21

subscriptions, 491–505.

See also report delivery

attached reports, 496

data-driven, 30, 498–505

described, 491–492

e-mail option, 21, 492–505

embedded reports, 492–494, 496

file share option, 492

managing, 496–498

multiple, 495–496

My Subscriptions page, 496–498

report links, 494–495

report update notification, 495, 504

scheduled execution snapshots, 495

security, 496

standard, 492–496

web archive format, 493, 496

Subtype property, 618

SUM() function, 111, 230–231

Sum() function, 274–275, 278–279

summary properties, 589

syntax errors, 266

System Administrator role, 456

system properties, 548–550, 649, 663

System User role, 456

system-level role definitions, 509

SystemReportTimeout property, 549, 550

SystemSnapshotLimit property, 549




Microsoft SQL Server 2005 Reporting Services
MicrosoftВ® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))
ISBN: 0735622507
EAN: 2147483647
Year: 2007
Pages: 115

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net