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 ...