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 articleMicrosoft released today a Cumulative Update 3 for SQL Server 2008 Service Pack 1. Among other things it fixes the Report Builder 2.0 ClickOnce deployment issue on x64 which I reported here.
Read articleAn 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 articleOn 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 articleI 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
