O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Reports with BIDS

To get started developing our first report, we’ll use BIDS. As mentioned previously, we’ll start by building reports from OLTP data sources so that we can first focus on learning how to use the report designer in BIDS. In the next chapter, we’ll look at how BIDS is used to design reports for cubes and mining models.

To get started, in the New Project dialog box, select the Business Intelligence Projects project type and then choose Report Server Project in the Templates area, as shown in Figure 20-4. This gives you a blank structure of two folders in Object Explorer: one folder for shared data sources, and one folder for reports.

Figure 20-4. BIDS contains two SSRS development templates.

Developing a report for SSRS consists ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required