R


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




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