Category Archives: SSRS

Book: Reporting with Microsoft SQL Server 2012

I am happy to say I have published my first book!  It is called Reporting with Microsoft SQL Server 2012 (order).  Much thanks goes to my co-author and friend Bill Anton.  Below is a brief overview or check out the … Continue reading

Posted in Power View/Project Crescent, SQLServerPedia Syndication, SSRS | Leave a comment

Microsoft BI tools: How they use data sources

A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (cubed-based, which can be the multidimensional model or the tabular model).  Note that any reporting tool that supports the … Continue reading

Posted in Excel, PerformancePoint, Power Pivot, Power View/Project Crescent, Report Builder, SQLServerPedia Syndication, SSRS | 1 Comment

Visual Studio 2012 now supports BI!

My most popular blog has been Visual Studio 2012 does not support BI.  In short, this means VS 2012 does not support SSAS, SSIS, or SSRS.  Well, not anymore!  Just released is Microsoft SQL Server Data Tools – Business Intelligence for … Continue reading

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2012 | 8 Comments

Visual Studio 2012 does not support BI

UPDATE 3/6/13: VS 2012 now supports BI!  Check out Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does … Continue reading

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2010, Visual Studio 2012 | 33 Comments

SSRS does not require IIS

Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do not need to install IIS on the machine that you will install SSRS.  This only applies when you configure it … Continue reading

Posted in SQLServerPedia Syndication, SSRS | Leave a comment

BIDS Helper 1.6 for SQL Server 2012 released

BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT).  Version 1.6 … Continue reading

Posted in SQLServerPedia Syndication, SSAS, SSIS, SSRS, Tools, Visual Studio 2008, Visual Studio 2010 | 1 Comment

SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode

In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took (see How to: Install and Configure SharePoint Integration on a Stand-alone Server): Install SQL Server 2008 and on the on the Feature … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication, SSRS | 4 Comments

SQL Server 2012 (“Denali”): Details on the next version of SSRS

SQL Server 2012 contains six new features for SSRS: Excel Renderer for Microsoft Excel 2003, 2007 & 2010 - Excel renderer will support the Excel 2007 XLSX format.  To enable this feature, Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint must be … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication, SSRS | 1 Comment

End-User Microsoft BI Tools – Clearing up the confusion

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles.  There is a … Continue reading

Posted in Excel, PerformancePoint, Power Pivot, Power View/Project Crescent, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | 2 Comments

Complex reporting off a SSAS cube

While using a cube in SSAS is usually a great source for reporting, it is not always the best choice.  Sometimes it is better to report off of the data warehouse that the cube is built from. For example, say … Continue reading

Posted in Data warehouse, SQLServerPedia Syndication, SSAS, SSRS | 10 Comments