Rate Sheet Report, 245–253
RDL (Report Definition Language), 309–312
code sample, 310, 311
default values, 688
described, 14, 309, 580
editing code, 311–312
reference, 687–694
structure, 688–694
viewing RDL code, 309–312
XML and, 309, 402
.RDL extension, 14
RDL files, 421, 442–443, 688
records, 73.
See also rows
recovering installation, 541
Rectangle item, 588
Rectangle report item, 207–208, 248–253
rectangles, 365–366
RecurrencePattern class, 678
RecycleTime setting, 546
References property, 614
Refresh button, browser, 430
Refresh Report button, 430, 431
relations, 76–80
cardinality of, 78–80
described, 78
entity relationship diagram, 704
many-to-many, 79–80, 84–85
one-to-many, 78–80, 176
one-to-one, 78–79
parent/subsidiary, 85–87
rows, 76–80
tables, 76–80
remote administration, 26
RemoveAllModelItemPolicies method, 655
Render method, 629
renderers, 19
rendering
formats for, 384–387.
See also exporting reports
RenderStream method, 629–630
unattended, 61–62
RenderingTest report
exporting to CSV files, 402
exporting to Excel files, 397–398
exporting to HTML files, 400–401
exporting to PDF files, 393
exporting to TIFF files, 390–391
exporting to web archive files, 395
exporting to XML files, 403
previewing, 388–389
RenderStream method, 629–630
Repair Count By Type Report, 188–196
RepairID field, 191
RepeatFooterOnNewPage property, 614
RepeatHeaderOnNewPage property, 615
RepeatOnNewPage property, 615
RepeatWith property, 615
report author installation, 32
Report Builder
advantages of, 10
basics, 715–720
chart reports, 734–736
clickthrough reports, 720, 729–732
creating reports with, 715–736
described, 8, 30
formatting reports with, 727–729
launching, 716–717
matrix report, 732–734
modifying reports, 724–729
program interface, 717–720
saving reports, 729–732
table layout reports, 720–732
users of, 10
vs. Report Designer, 10–11
report caching. See caching
Report Catalog
connection information, 58
credentials, 57
database setup, 56–58
described, 18, 410
linked reports, 466–468
Report Server database and, 27
role assignments, 554
report creation
with Add New Item command, 170, 172, 189
with Add New Report command, 139, 151
Customer List Report, 117–136
Customer-Invoice Report, 136–150
Invoice-Batch Number Report, 150–156
list reports, 196–208
local reports, 536–538
manual, 165–208
with New Project button, 118–120
overview, 4–5
Parameterized Invoice-Batch Number Report, 156–164
programming and, 8
with Report Builder, 715–736
in Report Viewer, 536–538
in Visual Studio, 536–538
with Wizard. See Report Wizard
Report Definition Language. See RDL
report definitions
checking in/out, 313
described, 689
downloading, 442–443
editing, 443–444
structure, 689
updating, 490–491
uploading, 444
version, 313
report delivery, 471–512.
See also subscriptions
overview, 9, 20–21
Report Manager website, 9, 20–21
subscription delivery, 21
via e-mail, 9
via Internet, 9
web service interface, 21
report deployment
caching and, 480
described, 17
folder creation during, 416
to folders, 419, 467
multiple configurations, 419–420
practices, 574–576
with Report Designer, 414–421
shared data sources, 416–419
single report, 416
through web service, 415–416
Report Designer
advantages of, 11
basic features, 15–17
datasets, 16
described, 8, 11
Design window, 15–16
exporting reports, 385–399, 402–405
installation issues, 28
Properties window, 16
Solution Explorer, 17
Toolbox, 16
vs. Report Builder, 10–11
report display.
See also previews
exported reports, 386
local reports, 536–538
from report cache, 477–478
Report Server, 532–535
Report Viewer, 536–538
uploading supporting materials for, 431–433
Report element, 689
report execution
caching and, 27, 472–481
logging, 506–507
permissions, 436
settings, 506–507
snapshots, 481–484, 495
timeouts, 506
with web service call, 527–531
report history, 484–491
creating snapshots, 485–488
default settings, 505–506
deleting snapshots, 489–490
disabling, 490
enabling, 484–488
managing snapshots, 488–490
report definitions, 490–491
report parameters, 487
Report item, 583
report items
adding to projects, 265
deleting, 445
hiding, 425–427
managing in folders, 444–447
names, 259
Report Items item, 588
report layouts.
See also formatting
choosing, 130–136, 144–156
creating, 303–308
described, 13, 14
local reports, 537
renderers and, 19
report objects, 582–583
table, 720–732
templates, 262–264
Report Manager, 409–470
accessing, 411
exporting reports to HTML, 400–401
managing report parameters in, 469–470
overview, 411–413
printing from, 449–450
security in, 451–466
shared data sources, 423–425
uploading reports with, 421–430
using Reporting Services without, 514–551
virtual directory, 54–55
Report Manager website, 9, 20–21
Report Model, 696–716
cleaning up, 704–712
components, 701–704
creating, 699–701
deploying, 712
described, 696
passwords, 698–699
securing, 712–715
Report Model Project, 12
report objects, 581–622
borders, 238–240
data regions, 583–589
layout areas, 582–583
properties, 589–622
reference, 581–589
report parameters
caching and, 480
creation of, 285
grouping and, 285–288
history snapshots and, 487
managing in Report Manager, 469–470
Report Parameters dialog box, 162–164
Report Processor, 19
Report Project template, 12
Report Project Wizard, 12
report projects.
See also reports
adding templates to, 264–265
creating in Visual Studio, 117–120, 532–533
described, 13
location for, 119–120
naming, 119–120
running, 420–421
Report Server
caching, 576
copying .NET assembly to, 433–434
credentials, 428–429
data providers, 19
deploying supporting items, 576
described, 472
displaying reports from, 532–538
images and, 233
installation issues, 25–26, 52–63
instances, 52–53
local reports, 536–538
managing reports on, 450–466
modifying configuration, 52–63
modifying reports from, 442–444
number of reports on, 575
overview, 18–19, 25
renderers, 19
Report Catalog, 18
report processor, 19
request handler, 19
security configuration, 436–439
snapshots, 576
Report Server Configuration Manager, 26, 52–63, 542
Report Server database, 27, 37, 58, 543
Report Server Database Connection Information setting, 543
Report Server Installation Options page, 50–51
Report Server parameters, 519–525
Report Server service login account for database server, 41–42
Report Server service login account for Windows, 40, 55–56
Report Server Temp DB database, 27
Report Server web service, 28, 531–538
Report Server web service login account for Windows, 40, 56, 57
Report Server Windows service, 25
report subscriptions, 21
report templates. See templates
Report Viewer
configuring, 533–535
controlling, 518–525
described, 8
displaying reports in, 536–538
instances of, 532–533
Report Viewer controls, 519, 531–538
Report Wizard
creating reports, 118–120, 139, 151
Customer List Report creation, 117–136
Customer-Invoice Report creation, 136–150
Invoice-Batch Number Report, 150–156
Parameterized Invoice-Batch Number Report, 156–164
report parameters, 156–164
starting, 120
report-authoring practices, 573–574
ReportExecution2005 web service
classes, 663–686
methods, 626–631
properties, 626
ReportHistorySnapshot class, 679
reporting environments, 7
Reporting Services
advantages of, 8–10
best practices, 572–576
command-line utilities, 540–551
components, 24–29, 43–48
configuration, 52–63, 566–570
cost of, 9
described, 4
Developer Edition, 30
documentation, 29
editions of, 29–30
help screens, 29
HTML format and, 400
Initialization of, 60, 61
installing. See installing Reporting Services
learning about, 65
license, 29
managing through web services, 531
new features, 4
programming and, 8
report authoring architecture, 10–17
report serving architecture, 17–21, 472–474
scenarios. See scenarios
Standard Edition, 29
using without Report Manager, 514–551
Reporting Services Books Online, 32
Reporting Services report author installation, 46–47
Reporting Services server, 31, 37, 44–46
Reporting Services utilities, 540–551
ReportingServices style sheet, 511
ReportItems element, 690–691
ReportName property, 615
ReportParameter class, 679–680
ReportParameters property, 615–616
reports.
See also GDS reports;
report projects
Access, 379–381
ad hoc, 696–716
annotated, 389, 390
attached, 496
authoring architecture, 10–17
basic, 165–208
“canned,” 696
chart, 734–736
choosing data file for, 121, 123
choosing database for, 121, 123
clickthrough, 720, 729–732
closing, 137
considerations for, 113
creating. See report creation
credit information update, 5–6, 10
daily company information, 5
delivering. See report delivery
deploying. See report deployment
descriptions, 575
designing. See Report Designer
displaying. See report display
drilldown, 136, 149, 368–370
embedded, 492–494, 496
errors in. See errors
executing. See report execution
expiration, 474–475, 478–479
exporting. See exporting reports
footers, 260–264, 582
headers, 257–259, 264, 288–292, 583
hiding, 425–427
history. See report history
imported. See importing
interaction with, 370–379
interactive table report, 136–150
inventory reports, 5, 9
linked, 466–470, 494–495, 575
list, 196–208
local, 536–538
managing on Report Server, 450–466
matrix. See matrix reports
modifying from Report Server, 442–444
names, 133, 259, 505, 575
navigation. See navigation
page breaks in, 284, 400–401, 611
previewing, 133–135, 147–148, 386–387
printing. See printing
programming and, 8
properties. See properties
refreshing, 430, 431
within reports, 357–370
sample. See sample reports
saving, 135
scenarios. See scenarios
searching for. See searching
serving architecture, 17–21, 472–474
structure, 13–14
subreports. See subreports
subscription delivery, 21
table. See table reports;
tables
tabular, 150
templates. See templates
unattended rendering, 61–62
uploading. See uploading reports
versions, 313
viewing. See report display;
Report Viewer
Reports folder, 17
Reports website, 28
ReportServer log file, 550
ReportServerService log file, 550
ReportServerWebApp log file, 550
ReportService2005 web service
classes, 663–686
methods, 632–663
properties, 631–632
ReportUtil.dll assembly, 441–442
Report Viewer controls, 534
ReportViewer Tasks dialog box, 533–534
request handler
delivering reports. See report delivery
described, 19
ResetExecution method, 630
resources, viewing contents of, 515–516, 517
result sets
columns included in, 96–98
displaying, 130
keeping in memory, 130
schema, 129
sort order, 87–88
results pane, 128
ResumeSchedule method, 655–656
rights
administrative, 63–64
local administrator, 451–453
tasks and, 453–454
user, 563–564, 576
role assignments
creating, 456–465
described, 554
for folders, 457–458, 575, 706–707
inherited, 458–459
managing, 460–465
storage of, 554
with Windows groups, 465–466
Role class, 681
role-based authorization, 554
roles
adding descriptions to, 709
domain groups, 576
folders, 575, 706–707
item-level role definitions, 509
names, 706
order of, 707–708
organizing, 706–707
predefined, 454–456
purpose of, 703, 717–718
security management, 454–456, 575
system-level role definitions, 509
Rosetta project, 4
rotation
HorizontalRotation property, 602
text boxes, 245
VerticalRotation property, 621
rows.
See also records
organization, 71–74
relations, 76–80
retrieving, 95–96
sorting, 87–88, 104–105
vs. records, 73
RS. See Reporting Services
RS utility, 547–550
RSConfig utility, 542
rsmgrpolicy.config file, 566
RSReportServer.config file, 25–26, 567
RSReportServer.Config utility, 542–547
rssrvpolicy.config file, 431–439, 568
rstest.rss file, 547
RSWebApplication.config file, 567
RSWebParts.cab file, 538
running aggregates, 280
RunningRequestAge setting, 544
RunningRequestsDbCycle setting, 544
RunningRequestsScavengerCycle setting, 544