Prologika Forums

Making sense of data

November 2009 - Prologika (Teo Lachev's Weblog)

Blogs

Prologika (Teo Lachev's Weblog)

Home

Training

We are excited to offer online Business Intelligence classes – no travel, no hotel expenses, just 100% content delivered right to your desktop! Our first class is Applied Reporting Services 2008. Attend this class for only $799 and get a free paper copy of the book Applied Microsoft SQL Server 2008 Reporting Services by Teo Lachev!

For more information or to register click here!

News

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.

Syndication

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

Sort by: Most Recent | Most Viewed | Most Commented

SharePoint List Data Extension

R2 brings several SharePoint enhancements, including: Support for multiple SharePoint zones – Previously, SSRS supported access from SharePoint URLs in the default zone, as I explained before. Support for the SharePoint Universal Logging service - Reporting...

Published Tue, Nov 24 2009 9:18 AM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
Report Parts

The major new R2 feature that debuts in CTP 3 (November CTP) of SQL Server 2008 R2 Reporting Services is report parts. A report part is a fragment of a report definition that you can publish to the report server to facilitate best practices and reuse...

Published Mon, Nov 23 2009 8:41 PM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
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.

Published Fri, Nov 20 2009 12:58 PM by Teo Lachev

Filed under: SQL Server 2008
Sparklines and Data Bars

Besides indicators , R2 adds sparklines and data bars to the arsenal of data visualization features. Sparklines are small graphics embedded in a context of words, numbers, and images. They help end users visualize simple trends. You could implement sparklines...

Published Fri, Nov 20 2009 8:24 AM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
Indicators

Often, reports need to show images that represent discrete values, such as an image that shows a KPI status. Previously, you didn't have another option but to use images that are dynamically changed based on the field value. Indicators, a new R2 feature...

Published Wed, Nov 18 2009 9:47 PM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
Pagination and Rendering Enhancements

R2 brings more control over pagination and rendering. A question that pops every now and then on the discussion list is how to name Excel worksheets for each instance of a row group. This scenario wasn't supported before R2. In R2, there are addition...

Published Tue, Nov 17 2009 8:52 AM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
Shared Datasets

When the Reporting Service team asked my opinion about shared datasets, a new feature in the forthcoming SQL Server Reporting Services R2, I was somewhat skeptical. I preferred them to focus on more important in my mind features, such as the ability to...

Published Mon, Nov 16 2009 9:15 AM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
Not All Calculated Members Are Born Equal

An interesting issue popped up yesterday regarding the calculated member syntax. I had to multiply negative amounts in a financial cube for certain account categories that had negative amounts. The cube also had a Many:Many relationship between financial...

Published Fri, Nov 13 2009 9:30 AM by Teo Lachev

Filed under: Analysis Services
Aggregates of Aggregates

Aggregates of aggregates is a new feature in SQL Server R2 Reporting Services. It can be better understood by the sample Aggregates.rdl report ( 2474.aggregates.rdl ). It shows sales grouped by year and quarter. The Year group subtotals use the Sum aggregation...

Published Wed, Nov 11 2009 8:54 PM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
Where is the SSAS 2008 Book?

Readers have been asking about a revised edition of my Applied Microsoft Analysis Services book for version 2008. First of all, I'd like to thank all my readers who bought and liked the book. This book has been a great success and it really exceeded...

Published Tue, Nov 10 2009 5:50 PM by Teo Lachev

Filed under: Analysis Services
BIDS 2008 and R2 Project Support

Continuing my intrepid journey in the SQL Server 2008 R2 land, I will discuss the new features of the recently-released CTP3. In this blog, I'll talk about the first new feature that caught my attention – BIDS support for 2008 and R2 projects. After...

Published Tue, Nov 10 2009 3:01 PM by Teo Lachev

Filed under: Reporting Services, SQL Server 2008 R2
SQL Server 2008 R2 November CTP (CTP3)

Microsoft announced release on SQL Server 2008 R2 November CTP (CTP3) with a build number of #1352.12. MSDN, TechNet Subscribers and TAP customers can download the SQL Server 2008 R2 November CTP today. Non-subscribers will be able to access the CTP on...

Published Mon, Nov 9 2009 10:13 PM by Teo Lachev

Filed under: Reporting Services, Analysis Services, SQL Server 2008 R2

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

3DZL:andrewbelon.com

November 2009 - Prologika (Teo Lachev's Weblog)

Blogs

Training

News

Syndication

Recent Posts

Tags

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

SharePoint List Data Extension

Report Parts

Cumulative Update Package 5 for SQL Server 2008 Service Pack 1

Sparklines and Data Bars

Indicators

Pagination and Rendering Enhancements

Shared Datasets

Not All Calculated Members Are Born Equal

Aggregates of Aggregates

Where is the SSAS 2008 Book?

BIDS 2008 and R2 Project Support

SQL Server 2008 R2 November CTP (CTP3)