Category Archives: SSRS

Microsoft BI tools: How they use data sources

Posted on April 2, 2013 by

A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (multidimensional-based): Report Builder – Using “SQL Server”, auto-detects joins if source system has foreign-key relationships (by selected “Auto … Continue reading →

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

Visual Studio 2012 now supports BI!

Posted on March 6, 2013 by

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

Posted on July 25, 2012 by

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 | 30 Comments

SSRS does not require IIS

Posted on July 18, 2012 by

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

Posted on March 30, 2012 by

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 | Leave a comment

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

Posted on March 7, 2012 by

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

Posted on March 5, 2012 by

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

Posted on February 27, 2012 by

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 View/Project Crescent, PowerPivot, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | 2 Comments

Complex reporting off a SSAS cube

Posted on January 30, 2012 by

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 | 8 Comments

BIDSHelper 1.5 for SSAS, SSIS, SSRS released

Posted on June 9, 2011 by

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.  Version 1.5 can be downloaded here, and read up on the new features. It’s a must-have … Continue reading →

Posted in SQLServerPedia Syndication, SSAS, SSIS, SSRS, Tools, Visual Studio 2008 | Leave a comment