Blogs

Training

We are excited to offer online Business Intelligence classes – no travel, no hotel expenses, just 100% content delivered right to your desktop! We currently offer Analysis Services and Reporting Services online classes!

For more information or to register click here!

Books

Announcing our latest book Applied Microsoft SQL Server 2008 Reporting Services. It is designed as an easy-to-follow guide for navigating safely the most intricate aspects of the leading reporting platform - SQL Server Reporting Services.

Blogs

Sort By: Most Recent | Most Viewed | Most Commented

SSRS-SharePoint Integration in SP2 (the Good, the Bad, and the Ugly)

As noted before, a major SSRS enhancement in the SQL Server 2005 Service Pack 2 is integration with SharePoint v3.0 and Microsoft Office SharePoint Server. After the RTM release of SQL Server 2005, the SSRS team has been hard at work to implement this...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Sat, Nov 25 2006

Filed under: Reporting Services
Black Preview

An unfortunate bug that was discovered late in the SQL Server 2005 SP2 design cycle may cause a black report preview in the ReportViewer Windows Form control (see attached file) with some video cards. The RS team is aware of this and they are working...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, Feb 23 2007

Filed under: Reporting Services
Reporting off ADO.NET datasets using the RS 2005 XML Extension

In case you missed this little gem, RS 2005 comes with a brand new XML Extension which allows you to report off an XML data returned from an URL-addressable resource, such as an ASP.NET page or a web service. For example, suppose that you have a web method...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Sun, Nov 20 2005

Filed under: Reporting Services
Report Builder 2.0 ClickOnce

One important change that Service Pack 1 for SQL Server 2008 (public CTP available here ) will bring is ClickOnce deployment of Report Builder 2.0. By default, however, Report Manager or SharePoint (if you have SSRS installed in SharePoint integration...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Wed, Feb 25 2009

Filed under: Reporting Services, SQL Server 2008
Tablix – The Crown Jewel

One of most important enhancements coming up in SQL Server 2008 Reporting Services is the new tablix region. In fact, I dare to predict that many folks will upgrade to SSRS 2008 just to get Tablix. What's tablix anyway? Tablix = Tabl e + Matr ix So...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Sun, Aug 12 2007

Filed under: Reporting Services, SQL Server 2008
Reporting Services Lookup Functions

One new SSRS SQL Server 2008 R2 feature that caught my attention is lookup functions. When reading the Reporting Services discussion list, I come frequently across questions that ask if it is possible to look up a value from a dataset other than the dataset...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Wed, Aug 12 2009

Filed under: Reporting Services, SQL Server 2008 R2
UDM Data Islands

As I mentioned in my TechEd Memoirs post , Microsoft is scaling back from the “super” cube approach in favor of more granular data “islands”. Since this took me by suprise, I approached the SSAS team for clarification. Here are the answers I managed to...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Tue, Jun 27 2006

Filed under: Analysis Services
Hacking MDX Query Designer Parameters

simpleparameters.zip Continuing our intrepid journey in the land of SSRS-SSAS integration, after we've figured out how to retrieve the cube metadata, we are ready to tackle another unchartered territory: query parameters. Issue : You need to parameterize...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Wed, Feb 25 2009

Filed under: Reporting Services, Analysis Services
Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies, April 2009

As I mentioned in a previous blog, one very important SSRS enhancement in the recently released SQL Server 2008 SP1 is Report Builder 2.0 ClickOnce. This lets you reconfigure the native and SharePoint integration modes to let the user use Report Builder...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Mon, Apr 13 2009

Filed under: Reporting Services, SharePoint
SSRS 2008 Variables

As I mentioned in my Under the Hood post , the SSRS 2008 engine has been redesigned to perform on-demand report processing for better scalability. As a result, textbox values are calculated on-demand every time the containing page is rendered. Irrespective...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Sun, Sep 9 2007

Filed under: Reporting Services, SQL Server 2008
Getting Rid of the Vista Credentials Prompt

There could be 1001 reasons why IE asks you for credentials when you access a website configured for Windows Authentication and none of them has to do with Reporting Services itself. Windows Vista and IE 7 add yet another one. IE 7 will prompt you for...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Thu, Dec 6 2007

Filed under: Reporting Services, SQL Server 2008
How to Test SSRS MDX Queries in SQL Server Management Studio

I often need to capture an MDX query that a report sends to Analysis Services and execute it in SQL Server Management Studio (SSMS). I usually do this to understand what parameters the report passes to the query and to troubleshoot the query itself. Unfortunately...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Mon, Jul 6 2009

Filed under: Reporting Services, Analysis Services
Where is my ecryption key gone?

As I stressed out in one of my previous posts and my book, it is an absolute must that you back up the RS encryption key as one of the first steps after you install RS and lock it up in a safe place. You can back up the encryption key this by using the...

Posted to Prologika (Teo Lachev's Weblog) by admin on Fri, Dec 31 2004

Filed under: Reporting Services
Nasty SSAS 2008 Bug

There is a nasty known bug with SSAS 2008, where if a query that requests two measures with Sum and LastNonEmpty aggregate functions side by side and the query uses NON EMPTY (which all OLAP clients use by default), the server forces the measure with...

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, Aug 15 2008

Filed under: Analysis Services, SQL Server 2008
Cumulative Update Package 5 for SQL Server 2008 Service Pack 1

Microsoft released Cumulative Update Package 5 for SQL Server 2008 Service Pack 1 (build 10.00.2746). Among other things, if fixes an SSRS issue with printing and conditional visibility of recursive groups which I reported.

Posted to Prologika (Teo Lachev's Weblog) by Teo Lachev on Fri, Nov 20 2009

Filed under: SQL Server 2008

1 2 3 4 5 Next > ... Last »

Powered by Community Server (Commercial Edition), by Telligent Systems

3DZL:andrewbelon.com

Blogs

Training

Books

Tags

Blogs