Skip to articles

PROLOGIKA BLOG · IDEAS FROM THE FIELD

Making sense of data.
Sharing what we learn.

Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.

Explore the latest articles

SQL Server R2 Forums Available

The SQL Server R2 (Kilimanjaro) discussion forums went live today. Your humble correspondent is the moderator of the Reporting Services forum. SQL Server R2 CTP 2 should be out on connect.microsoft.com shortly. Looking forward to your feedback!

Read article

SharePoint Integrated with Reporting Services on Windows Vista

So, how's this not cool? Running SharePoint integrated with Reporting Services on Windows Vista! I've always had a grudge with SharePoint that it doesn't run on a desktop OS. This forces you to install Windows Server or use a virtual image, both options far from ideal. When I went to TechEd I blurted by disappointment to a couple of SharePoint gurus who clued me in…

Read article

Nevron Charting for Reporting Services

Reporting Services charting not enough? Nevron Software has released a Nevron Charting for Reporting Services which I haven't personally tested yet. According to the vendor, here are the major features where Nevron excels in comparison with Reporting Services charting: - Speed - Nevron Chart for SSRS is the fastest rendering chart inside Reporting Services - in both 2D and 3D modes. - 3D Charting -…

Read article

Applied Reporting Services 2008 Online Training Class with Teo Lachev

Some of you shared with us your frustration with training budgets cut in half. Many of you couldn't attend industry conferences this year. Many of you asked how we can help. 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. This three-day intensive…

Read article

Excel Page Numbering Issue

An issue was reported about page numbering and exporting reports to Excel with Reporting Services 2008. Specifically, if the page header or footer uses a placeholder for the page number, when exported and previewed in Excel, the report will show Page 1 on all pages. Page [&PageNumber] of [&TotalPages] While waiting for Microsoft to fix this, use an expression that concatenates the PageNumber member of…

Read article

Google – The Best Thing that Ever Happened to Microsoft

On a different subject, you've probably heard the news: Google will release an operating system called Google Chrome OS which will challenge Windows and instill fear into the Microsoft camp. To the contrary, I think Google is the best thing that ever happened to Microsoft. How come? I remember reading somewhere that after the perestroika, Mikhail Gorbachev had supposedly told Ronald Reagan "we'll now do…

Read article

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, SSMS doesn't support parameterized MDX queries so you have to resort to the following technique: Capturing MDX Queries The easiest…

Read article

Maintaining State in Reporting Services 2008

Sometimes, more advanced reporting needs may require maintaining state using custom code. Recently I had to implement a rather involved report consisting of two sections: a detail section that used a recursive sum, Sum(Fields!SomeField.Value, , True), and a summary section with additional calculations which would reference some of the aggregated values in the detail section. Since Reporting Services is not Excel, you cannot reference arbitrary…

Read article