R

ragged-right format, 198

range operator in Excel, 387–388, 389

Raw Count transformation, 226–227

Raw File destination, 242

raw file format, 202, 203

RDL (Report Definition Language)

about, 559

RDL files, 561, 603

real-time HOLAP data storage, 362

real-time ROLAP data storage, 361–362

Rebuild Index task, 168–169

Recordset destination, 242

recovery mode for nontransactional databases, 116

rectangles in reports, 601

red asterisk in Cube Wizard, 136

reference dimensions, 314

Reference Table tab (Fuzzy Lookup Transformation Editor dialog box), 219

referencing

ADOMDB.NET implementation in projects, 678

Reporting Services in project, 702–703

Registered Servers window, 85–87, 88

regression

about, 464–465

Microsoft Clustering algorithm for, 474–476

Microsoft Decision Trees algorithm for, 472–473

Microsoft Neural Network algorithm for, 480–481

Microsoft Sequence Clustering algorithm for, 477–478,517

Microsoft Time Series algorithm for, 479–480,517

regular identifiers, 247

Relational OLAP systems. See ROLAP systems

relative navigation, 395–402

distant relative position between hierarchy levels, 401–402

finding relative position within hierarchy level, 397–399

immediate relative position between hierarchy levels, 399–400

returning current member of hierarchy or dimension, 397

remote administration of Report Server, 564

renderer control parameters, 693

renderers in Report Server, 561, 562

rendering formats for URL-rendered reports

Report Server parameters for, 692

suppressing parts of Report Viewer interface, 693–694

Reorganize Index task, 169, 170

report actions

about, 350

creating, 352

Report Builder

about, 557

clickthrough reports in, 671

entities, roles, and fields in, 668–669

features of, 657

illustrated, 669

launching, 666–668

layouts available in, 565–566

Report Model and, 657

roles in, 668–669

report caching, 648–653

about, 648–649

cached report expiration, 650

changing report properties for, 653

data source credentials and, 650–651

deployment of new report instance to cache, 651–652

enabling, 651, 652

storing parameter values used to create cached instance, 652

Report Catalog

component of Report Server, 560–561

folders, 628

linked reports, 648, 649

Security page for each item in, 640–641

Report Definition Language. See RDL

report definitions, 654

Report Designer

about, 557, 558, 565

data regions for reports, 569

deploying reports to Report Server with, 629–631

determining fields returned by stored procedures, 613

features of, 657

reports saved with .RDL extension, 559

table data region, 569

types installations of, 565–568

report history, 653–654

Report Manager web application

as component working with Report Server, 561

creating shared data source with, 633–636

deploying reports to Report Server from, 627–628

hiding report details with, 636–637

illustrated, 629

launching Report Builder from, 666

printing from, 637–639

report printing without using, 683

as Reporting Services component, 563

requesting reports from, 559

setting content manager privileges for, 628–629

sorting data in, 636–637

subscriptions, 654–656

uploading items to Report Server folders with, 637

uploading reports with, 631–633, 634

URL for, 628

Report Model

about, 657

creating, 657–660

deploying, 663

refining reports from wizard, 662–663

security and, 663–665

selecting generation rules for, 659, 660

use of # in, 661, 662

Report Model Properties dialog box, 665, 666

Report Model Wizard, 659, 660

Report Parameters dialog box, 614–616

report processor component of Report Server, 561

Report Properties dialog box, 605, 606

Report Server, 560–565. See also Report Server web service

about, 560

administration utilities for, 563–564

data providers for, 561–562

databases used by, 564

deploying Report Model to, 623

deploying reports from Report Manager to, 627–628

execution snapshots, 653

illustrated, 560

Manufacturing Data Mart Report Model deployed to, 664

moving reports with Report Designer to, 629–631

parameters for URL-rendered report formats, 692

renderers in, 561, 562

report caching, 648–653

Report Catalog's role with, 560–561

report history in, 653–654

report processor component of, 561

Report Server web service and, 562–563, 565

as Reporting Services component, 562–563

request handlers in, 561, 562

security rights for, 639–648

storing parameter values used to create cached instance, 652

types installations of, 565–568

uploading reports with Report Manager, 631–633, 634, 637

Report Server Configuration Manager, 563–564

Report Server database, 564, 566, 567, 568

Report Server TempDB database, 564

Report Server web service

about, 562–563, 565

alternative report methods to, 710

displaying report from, 707–710

URL syntax for, 683–684

Report Viewer

alternative report formatting methods than, 691

configuring, 709–710

displaying local reports with, 715–716

placing control on windows form for, 708

suppressing parts of interface, 693–694

viewing local reports in, 710–716

Report Wizard

Choose the Table Layout page, 575

Completing the Wizard page, 576

creating reports with, 571, 573–574

creating table data region, 574, 577

Design the Table page, 574

opening, 570

Reporting Services. See also Report Manager web application; Report Server

adding command parameters to URL for, 686–687

capabilities of, 674

component parts of, 563

creating project with reference to, 702–703

data definitions for reports, 557–558

delivering business intelligence with, 718

distributed installations of, 566–567

documentation for, 565

Execution Properties page, 651, 652

expressions in Visual Basic.NET, 579

extending report access with linked reports, 648, 649

formatting reports with, 691–700

function of, 556–557

integration with Windows security, 640

location on computer, 684

managing through web services, 707

matrix reports, 588–598

New Data Source page, 635

performance of report caching, 649

printing from Report Manager, 637–639

report creation in, 568

Report Designer and, 557, 558, 565

Report Server as part of, 562–563

Report Server web service and, 563, 565

report subscriptions, 559–560

Report Wizard for creating reports, 570, 571, 573–574

Reports website and, 563, 564

roles for, 643

security rights and tasks for, 639, 640, 642–643

setting navigation options for, 608–610

structure of reports, 557

using without Report Manager, 683

web farm installations of, 567–568

reports. See also charts; pivot charts; Reporting Services; URL-rendered reports

adjusting page size of, 605–607

cached report expiration, 650

chart, 612–627

configuring Report Viewer to display, 709–710

creating in Reporting Services, 568

creating web form for, 703–706

customizing properties for report items, 575

data definitions for Reporting Services, 557–558

data source credentials for cached, 650–651

defining grouping on, 582, 585

deploying from Report Designer, 629–631

deploying to Report Server from Report Manager, 627–628

displaying from Report Server web service, 707–710

embedding images in, 602–604

enabling drilldown for, 573, 575, 591

errors executing through URL, access, 684

executing via web services, 701–707

formatting URI,-rendered, 691–700

function of Reporting Services in creating, 556–557

hiding from nonadministrative users, 684

HTML, 638

including charts in body of, 616–618, 619

linked, 648, 649

list, 598–611

local, 710–716

local administrator privileges for, 640–641

matrix, 588–598, 668

page numbers for, 607–608

parameters added to, 614–616

parameters passed for URL rendered, 687–691

printing from Report Manager, 637–639

.RDL extension for, 559, 561

rectangles and borders in, 601

refining Report Model Wizard, 662–663

Report Builder clickthrough, 671

report history feature in Report Server, 653–654

requesting from Report Manager, 559

setting text properties for, 606–607

specifying @Year query parameters, 573

subscribing to, 559–560, 654–656

subtotals on, 573

uploading with Report Manager, 631–633, 634

URL-rendered, 683–701

viewing local reports in Report Viewer, 710–716

widening table columns, 574, 577

without parameter area, 689

Reports website

about, 563, 564

server location with types of Reporting Services installations, 566, 567, 568

request handlers in Report Server, 561, 562

result sets

disconnected, 676

reading from query with AdomdDataReader, 675

result view, 542

rights. See privileges; roles

RMUpload folder, 635, 637

ROLAP (Relational OLAP) systems

about, 50–51, 56

setting partitions storage options for, 360, 361–362

Role Design tab

Browser page, 411, 412, 414

Cell Data page, 405–406, 408

Cubes page, 405, 407

Data Sources page, 405, 406

Dimension Data page, 408-409,410-412

Dimensions page, 409

displaying, 404

General page, 404

Membership page, 405

Mining Structures page, 410

role playing dimensions, 313–314

roles

assignments on Security page, 640–641

Browser, 643

Content Manager, 628–629, 644–645

creating role assignments, 645–647

inherited assignments, 647

My Reports, 644

Publisher, 644

in Report Builder, 668–669

Reporting Services, 643

subscriptions and security, 655

System Administrator, 645

System User, 645

using Windows groups to assign, 647–648

Row Sampling transformation, 227, 230

rows

counting number in data flow, 226–227

executing OLE DB command for each, 223–224

grouping table, 585–586

removing those with duplicate sort keys, 236

repeating on report pages, 582, 585

selecting Fuzzy Grouping model, 213–214

sorting in data flow, 235–236

splitting data based on number desired, 227, 230

viewing in Browse window, 328, 329

ROWS query dimension

slicer dimension with, 432

using with MDX SELECT statement, 444

using, 445–446

rs: prefixes, 692

RSReportServer.config file, 563

Rules viewer for Microsoft Association algorithm, 514–515, 516