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