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.
- Report Builder vs. Reporting Services - Differences (this blog)
- Report Builder Difference 1 - Look and Feel
- Difference 2 - Report Builder 3.0 has more wizards
- Difference 3 - Creating Datasets in Report Builder
- Difference 4 - Expression Intellisense in Report Builder
- Difference 5 - Using Report Parts in Report Builder
- Other Differences for Report Builder
Posted by Andy Brown on 07 November 2011 | 2 comments
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.
Report Builder vs. Reporting Services - Differences
You can create reports in two ways in SQL Server Reporting Services:
- By using BIDS (Business Intelligence Development Studio), a subset of Microsoft's Visual Studio development environment; or
- By using Report Builder, a standalone application downloadable from the Internet.
This blog explores the differences between the two ways of creating a report.
A note on versions
This blog is specific to SQL Server Reporting Services 2008 R2 and Report Builder 3.0. At the time of writing (November 2011) these are the latest versions of both applications.
The Underlying Philosophy
Microsoft's intention seems to be this:
- Developers and programmers creating reports within an IT department for use elsewhere within a company or organisation should be using BIDS.
- Those developing reports for their own use - perhaps having less technical ability - should use Report Builder.
I'm not sure I agree with this philosophy: I think that the two applications are so similar beneath the hood that they might as well be integrated into a single application, and I personally find the wizards in Report Builder confusing. But that's just me!
With the above in mind, let's look at the differences! I've put each one in a separate page to make the article clearer to read. Although this may seem a long blog, in fact there are very few differences.
This blog has 2 comments
A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.