Report Builder 3.0 in SQL Server 2008 R2 Standard Edition – A few points


Woody Walton

I have been delivering Microsoft SQL Server 2008 R2 familiarization sales training to our various transaction partners over the last few weeks and I wanted to share a a few questions that I think are representative of what many of you may be thinking about or asking yourself.

One of the three key areas of investment in SQL Server 2008 R2 is around Managed Self Service Business Intelligence (BI).  We market the Enterprise Edition of SQL Server as the “best” solution for BI scenarios and the Standard edition for basic BI needs.  This does not mean that the Standard Edition cannot meet the average individual or average company needs around BI.  In fact, in most cases it will do more than nicely!

Reporting Services is included in SQL Server 2008 R2 Standard edition and therefore Report Builder 3.0 is also included in the Standard Edition.

The capabilities of Report Builder 3.0 are not limited in any way in the Standard Edition.  See Malcolm Stewart’s post on the MSDN forums where he he states:

 …There are no differences in ReportBuilder between the Standard and Enterprise Editions. The edition differences only apply to the Report Server itself and not the tools or designers or the ReportViewer controls.

So even though Enterprise edition may be the flagship SKU for business intelligence, the self service BI capabilities are pervasive across all core SKUs of SQL Server 2008 R2!  The common (wo)man can (on a more limited budget! ;-)) create compelling self service reports that drive their own personal business.

So when selling SQL server 2008 R2 Standard, whether an OEM version (Server/CAL only) or through Volume licensing make certain you point out the easy BI tools like PowerPivot and Report Builder 3.0.

These tools can alleviate the need for costly third party reporting solutions and make this…


Midwest South Dakota Home Q4 29 955
West Wyoming Electronics Q4 4 23
South Arkansas Garden Q4 98 639
Midwest Michigan Home Q2 47 977
South South Carolina Toys Q3 9 476
West Idaho Garden Q4 15 22
South Oklahoma Electronics Q1 54 900
Midwest South Dakota Toys Q1 92 340
Midwest Michigan Toys Q4 76 479


Look like this…


or this…


Until next time!



Comments (6)

  1. Drew Reutlinger says:

    Does Report Builder 3.0 open and convert SQL 2005 reports to SQL 2008 R2?

  2. Walter says:

    Can I add slicers into a report in Reporting Services 2008?

  3. nagen says:

    may be its possible for report builder 3.0 open and convert sql server 2005 and 2008.



  5. Catherine says:

    Thank you Woody, very informative

Skip to main content