October 2008 - Posts
My colleagues Sean Boon and Alex Gorev recently started their own blogs with focus on data visualization. You can expect to see more postings on their blogs in future on how to effectively utilize Reporting Services 2008 charts and gauges to make your
Read More...
You may have been in this situation before - you designed a chart based on a particular dataset and everything looks great. However, later the data volume increases, or new categories dynamically show up in your data source, and there is not enough horizontal/vertical
Read More...
One of the demos shown at Monday's PDC keynote by Ray Ozzie and Bob Muglia was Reporting Services with data stored in SQL Data Services (SDS) in the cloud. Besides the keynote, there are several more sessions throughout PDC featuring Reporting Services
Read More...
One of the changes we included in Cumulative Update #1 for SQL Server 2008 ( CU1 download link ) is automatic full font embedding and subsetting for Unicode characters in Reporting Services 2008 PDF rendering . While a similar code change is now available
Read More...
One of the small new features in Reporting Services 2008 that has not been widely publicized, is the ability to directly reference dataset fields and dataset aggregations from expressions in the page header and page footer. You can accomplish this by simply dragging a dataset field directly into the page header/footer area of the report, or by manually writing expressions.
Read More...
One of the projects the data visualization group within the Reporting Services team has been working on is building stand-alone ASP.NET and Windows Forms Chart Controls for the .NET Framework 3.5 and Visual Studio 2008, similar to what has been already
Read More...
In a previous posting, I discussed dataset execution order in Reporting Services. In this posting, I will provide a few tips for situations where you or your report users are wondering what is the actual query executed by Reporting Services. While you
Read More...
Microsoft SQL Server 2008 Report Builder 2.0 RTM (build 10.00.1600.60) is now available on Microsoft Download Center as stand-alone installer in more than 20 languages. Report Builder 2.0 provides an intuitive report authoring environment for business
Read More...
One of the questions that I answer somewhat frequently, is about recursive groupings in Reporting Services and how to utilize parent-child hierarchies from an Analysis Services cube. The attachment of this posting contains a small report example I put
Read More...
The Reporting Services demo during the " BI Power Hour " session at the Microsoft Business Intelligence Conference was a lot of fun and well received. My colleague Carolyn Chau did great on stage presenting the demo we had put together. In my chalk talk
Read More...
You selected "Repeat header rows on each page" or "Keep header rows visible while scrolling" in the tablix properties dialog, but it doesn't seem to work as expected? You might want to try the following four steps if you are using a "table"-style layout:
Read More...