PROLOGIKA BLOG · IDEAS FROM THE FIELD
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articles
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 the region is bound to. Excluding getting the first or last value (First and Last functions) or aggregate functions that…
Read article
In this and future blogs I'll cover the most important new features in the forthcoming release of Reporting Services which will be included in SQL Server 2008 R2 (code-named Kilimanjaro or KJ for short). Let's start with the most obvious new feature: the all new Report Manager UI. SharePoint-like UI The moment you open Report Manager, you will notice that significant work was done to…
Read articleIt turned out that for time being the CTP2 of SQL Server 2008 R2 which I announced yesterday is available for TAP participants only. It will be publicly available on Wednesday. Meanwhile, Robert Bruckner listed the new Reporting Services features which got implemented in CTP2. The biggy is the new map region that lets you visualize geospatial and geometry data. In my first book I…
Read articleMicrosoft just pushed CTP2 of SQL Server 2008 R2 build #1092.20 (code-named Kilimanjaro).
Read articleThe 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
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
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
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 article
