Category Archives: SSRS

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

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

Watch out, Visual Studio 2010 does not support BI

Posted on May 20, 2011 by

When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010.  So I copied … Continue reading →

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSIS, SSRS, Visual Studio 2008, Visual Studio 2010 | 2 Comments