In the past, I created a lot of reports by using Business Intelligence Development Studio (BIDS) 2005, but now I’m working on a project for a client where I need to use BIDS 2008 R2/SQL Server Data Tools (SSDT). I’m amazed at how backwards BIDS/SSDT has become in this newer version. Why is it so difficult to find basic tools, such as datasets, images, prompts, etc.? For example, in BIDS 2005, using the default window pane layout, the Report Datasets feature was right there on the left side of the screen next to the Toolbox tab. Notice that only datasets are listed there, whereas images and prompts are organized under the Report tab.
In BIDS 2008 R2/SSDT, the datasets are nowhere to be found in the default window pane layout.
To save you from frustration, I’ll show you exactly where you need to enable the Report Data window pane.
Hiding under the View menu, right at the bottom, is Report Data. Once you enable this feature it will appear on the left-hand side of the screen.
On the positive side, once you enable Report Data window pane it will stay enabled until the layout is re-set. As well, all of the datasets, images and prompts are organized in this area which makes it handy. It was unfortunate, though, that report properties such as code, references, and variables weren’t also located here.