Microsoft SQL Server 2005 Reporting Services

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

RAM (random access memory), SQL Server 2005 installation requirements

rc parameter prefix

RDL (Report Definition Language) 2nd 3rd 4th

        charts

        data regions

        DataSet elements

        declarative programming

        images

        rectangles

        Report element

        ReportItem elements

        ReportParameters

        tables

       templates

                converting

                creating

                deploying

                editing

                example of

                ReportService2005 namespace

                System.Data.SqlClient namespace

                System.IO namespace

                System.Web.Services.Protocols namespace

                System.XML namespace

        tutorial website

RDL (Report Definition Language) files

        downloading

        saving

        storing

        Visual Studio

Reconnect button (Solution Explorer)

RecordDelimiter parameter

rectangle RDL

Rectangle report items 2nd

References tab (Report Properties menu)

relational query designer (Report Designer)

RemoveSpace parameter

Render command 2nd 3rd

Render Format drop-down list (Report Manager, Subscriptions tab)

rendering extensions 2nd

rendering formats ( reports ), switching between

Report Builder 2nd 3rd 4th

        accessing

        ad hoc reports

       data

                exporting

                formatting

                templates, adding to

       data sources

                click-through data sources, creating

                matrix data sources, creating

                pivot data sources, creating

                previewing

                publishing

                report models as

                saving

                selecting

                tabular data sources, creating

        Report Designer versus

        templates

Report Builder role

Report class

Report Control parameters

Report Definition Language (RDL) [See RDL (Report Definition Language).]

Report Design window (Visual Studio)

        Datasets view

        Properties window

                formatting tables

                grouping/sorting properties

        Report Layout view

Report Designer 2nd

       Business Intelligence Developer Studio

                Graphical Query Builder

                Visual Studio versus

        Data tab

        DMX query designer

        Grouping and Sorting Properties dialog

        Image Wizard, Image Source window

        Import Access reports feature

        IntelliSense

        interface

        Layout tab

        MDX (Multidimensional Expressions) query designer

        Model Builder

        Preview mode

        Preview tab 2nd

        relational query designer

        Report Builder 2nd

        Report Wizard 2nd

       Visual Studio

                authentication for reports

                Business Intelligence Developer Studio versus

                choosing data sources for reports

                creating connection strings for reports

                creating reports 2nd

                creating shared data sources for reports

                data sets

                Datasets view

                DSV files

                formatting queries

                formatting tables

                generating reports

                Generic Query Designer

                naming reports

                previewing reports

                Properties window

                queries

                RDL files

                Report Layout view

                Report Server Projects

                storing reports

                Templates section

                testing connection strings for reports

                Visual Query Builder

Report Designer Toolbox

report development

        authoring stage

        delivery stage

        managing stage

Report element (RDL)

report execution properties, linked reports

Report Execution Timeout property

report history

        configuring

        properties, linked reports

        viewing

report items

        chart items 2nd

        containers 2nd

        custom items

        data regions 2nd

        image items 2nd

        independent report items 2nd

        line items 2nd

        list items 2nd

        matrix items 2nd 3rd

        rectangle items 2nd

        reports, adding to

        subreport items

        table items 2nd

        text box items 2nd

        usage example

Report Layout view (Visual Studio)

Report Manager

        A Shared Data Source option

        built-in roles, assigning

        custom roles, creating/deleting

        customizing

        data source properties window, Custom Data Source option

       data sources

                configuring

                modifying

        data-driven subscriptions, creating

        default URLs

        Description field

        Enable My Reports to Support User -Owned Folders for Publishing and Running Personalized Reports check box

        folders, creating

        History tab

        interface

        Internet access

        linked reports, creating

        My Reports folder

        My Subscriptions page

        Name field

        New Data Source button

        New Role button

        Properties tab

       reports

                deploying

                models

                properties

                uploading

        shared schedules

        snapshots

       subscriptions

                deleting from

                email-based subscriptions, creating

                file share subscriptions, creating

                managing

                modifying

                standard subscriptions

                viewing

       Subscriptions tab

                Do Not Overwrite the File if a Previous Version Exists option

                New Data Driven Subscription button

                New Subscription button

                Render Format drop-down list

                Report Server Email in the Delivered By drop-down list

                Report Server File Share in the Delivered By drop-down list

                Scheduled Report Run Is Complete option

                Validate button

        Upload File button

Report Model Designer

Report Model menu (Model Designer)

Report Model Project templates

report models [See also DS (Data Sources) files.]

        as data sources

        attributes, adding/removing

        bindings 2nd

        creating

        Data Source views 2nd

        deploying

        ds files

        entities 2nd

        folders 2nd

        Model Designer

       model projects, creating

                Data Source views, creating

                ds files, creating

                report models, creating

        modifying

        perspectives 2nd

        physical models

        publishing

        Report Manager, creating from

        required information

        roles 2nd

        SDML

        security

        semantic models 2nd

        source fields 2nd

report parameters

        configuring

        data source expressions, defining

        data sources

        data-driven parameters

        dependencies

        DynamicSQL

        expressions

        hiding

        MultiSelect usage example

        naming

        presentation options

        properties

Report Processor

Report Properties dialog

        Code tab, editing embedded code

        References tab

Report Server

        anonymous access

        custom extensions

        data-processing extensions

        delivery extensions

        parameters

        rendering extensions

        report history, configuring

        ReportServer database

        ReportServerTempDB database

        security extensions

        SSRS scale-out deployments, initializing for

        subscriptions, monitoring

        Visual Studio, DS files

        Windows authentication

Report Server Email in the Delivered By drop-down list (Report Manager, Subscriptions tab)

Report Server File Share in the Delivered By drop-down list (Report Manager, Subscriptions tab)

Report Server has encountered a configuration error message, The

Report Server Projects

Report Summary.rdl reports

Report Viewer 2nd

Report Wizard 2nd

        Design the Query screen

        mining structures, querying

        OLAP reports, troubleshooting

        opening

        Query Builder

        Select the Data Source screen

        Select the Report Type screen

        Table Style screen

report-specific data sources [See embedded data sources.]

report-specific schedules versus shared schedules

ReportExecution2005 web service

ReportExecution2005.asmx

reporting controls features (SSRS)

Reporting Services

        architecture diagram

        Chart Properties dialog

        charts, support for

        component summary table

        Configuration Manager

        Configuration tool 2nd

        CPU/user requirements table

        extensions 2nd

       installing

                advanced install options

                AutoPlay

                configuration checks

                default configurations

                license agreements

                prerequisites

                recommendations

                requirements

        programmatic interfaces

        registering

        Report Builder

        Report Designer

        Report Manager, customizing

        Report Model Designer

        Report Processor

        Report Server

        rs.exe command-line utility

        rsconfig.exe command-line utility

        rskeymgmt.exe command-line utility

        RSPrintClient ActiveX control

        Scheduling and Delivery Processor

        security model

        SQL Server Management Studio

        web service

                accessing

                credentials

                HTTP 401 Error: Access Denied error messages

                ListChildren command

                methods with code snippets

                naming endpoints

                ParameterValue class parameters

                paths

                performance monitoring objects

                references

                registered extensions list

                Render command 2nd

                report paths

                ReportExecution2005 web service

                ReportParameter class parameters

                ReportServerEdition property

                ReportServerVersionNumber property

                ReportService web service

                ReportService2005 web service

                security

                URL Access

                usage example

                WISDL

                XML output

        Windows Service 2nd

        WMI provider

ReportingServices.asmx

ReportingServicesService.exe

ReportingServicesService.exe.config files

ReportItem elements (RDL)

ReportItems collections

ReportParameter class parameters

ReportParameters (RDL)

reports

        ad hoc

        bodies versus page headers/footers

        charts

        deleting

       deploying

                Report Manager

                SQL Server Management Studio

                Visual Studio

        descriptions, modifying

        document maps

        email delivery

       executing

                data-gathering process

                execution logs

                large reports

                layout processing process

                rendering process

                timeouts

        free-form

        images, adding

       linking

                creating

                deleting

                descriptions

                locations

                names

                parameters

                properties, modifying

                security

                subscriptions

        matrix

        moving

        navigating

        presentation formats, switching between

        processing

        properties, modifying

        renaming

        report items, adding

        security

        tabular

       uploading

                Report Manager

                SQL Server Management Studio

        viewing online

        visual effects, creating

       Visual Studio

                authentication

                choosing data sources

                creating 2nd

                creating connection strings

                creating shared data sources

                data sets

                formatting queries

                formatting tables

                generating in

                naming in

                previewing

                queries

                storing in

                testing connection strings

ReportServer database

ReportServerEdition property

ReportServerInformation

ReportServerTempDB database

ReportServerVersionNumber property

ReportService web service

ReportService.asmx

ReportService2005 namespace, RDL templates

ReportService2005 web service

ReportService2005.asmx

ReportViewer control 2nd

        local processing mode

        remote processing mode

restoring symmetric keys

Result pane (Graphical Query Designer)

Revert to Parent Security button (Report Manager, Properties tab)

Right property

ROLAP (Relational OLAP)

roles

        assigning 2nd

        authorization

        bindings, assigning

        Browser

       built-in roles

                item-level roles

                Report Manager, assigning via

                SQL Server Management Studio, assigning via

                system-level roles

        Content Manager 2nd

       custom roles, creating/deleting

                Report Manager

                SQL Server Management Studio

        item-level roles

        My Reports

        permissions

        policies

        Publisher

        removing

        Report Builder

        System Administrator 2nd

        System User

        system-level roles

        tasks

        users/groups, assigning to

        View Only roles

RowNumber functions 2nd

rows (tables)

        colors, alternating

        deleting

        group header rows

        static row headers

        subtotals, creating

rs /? command

rs parameter prefix

RS utility

rs.exe command-line utility

rsactivate.exe command-line utility

rsCompilerErrorInClassInstanceDeclaration errors

rsCompilerErrorInExpression errors

rsconfig.exe command-line utility

rsErrorLoadingCodeModule errors

RSExecutionLog database

rskeymgmt.exe command-line utility 2nd

RSMgrPolicy.config files 2nd

RSPreviewPolicy.config files 2nd 3rd

RSPrintClient ActiveX control 2nd

RSReportDesigner.config files 2nd

RSReportServer.config files 2nd

rssrvpolicy.conf files, granting custom assembly permissions

RsSrvPolicy.config files 2nd

RSWebApplication.config files 2nd

RunningValue functions 2nd

runtime functions (Visual Basic) 2nd

        conversion functions

        date and time functions

        financial functions

        information functions

        math functions

        program flow functions

        string manipulation functions

Категории