Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint
    Share this Page URL
    Help

    Chapter 14. Building a Management Dashbo... > Creating a Reporting Services Report...

    Creating a Reporting Services Report with Report Builder 3.0

    Report Builder 3.0 is a user-friendly tool for developing reports. It is a component that was released along with SQL Server 2008 R2 and is available for download from the SQL Server 2008 R2 Feature Pack website. A report developed with Report Builder 3.0 can be rendered on a PerformancePoint Services dashboard. This is a convenient way of reusing existing reports while packaging them up as a component within a dashboard. To create a report from scratch using Report Builder 3.0, follow these steps:

    1.
    Create a data source, which defines where the data for the report will be retrieved (for example, a SQL Server Analysis Services cube or a SQL Server relational database).

    2.
    Create a dataset, which defines the query used to retrieve the report data from the data source.

    3.
    Create a report that renders the dataset.


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial


      
    • Safari Books Online
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint