Browse 540 attributed reviews, viewable separately for our classroom and online training
Differences between Report Builder and Reporting Services
Part four of a seven-part series of blogs

Report Builder and BIDS (the Visual Studio add-in for creating Reporting Services reports) are essentially the same underneath their very different looking skins. This blog lists the small number of differences.

  1. Report Builder vs. Reporting Services - Differences
  2. Report Builder Difference 1 - Look and Feel
  3. Difference 2 - Report Builder 3.0 has more wizards
  4. Difference 3 - Creating Datasets in Report Builder (this blog)
  5. Difference 4 - Expression Intellisense in Report Builder
  6. Difference 5 - Using Report Parts in Report Builder
  7. Other Differences for Report Builder

Posted by Andy Brown on 07 November 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Difference 3 - Creating Datasets

In Report Builder 3.0 the way that you create a dataset by default is very different:

Creating a dataset in Report Builder

The way that you design a query in Report Builder is intended to be easier to use ...

Personally, I'd go for the query designer in BIDS any day:

Example of BIDS query designer

Have I been working with SQL for too long? This query designer seems so much easier to use!


This blog has 0 threads Add post