Lately, I’ve run into a few “multi-dimensional” posts in the public SSRS newsgroup. It seems like more and more people target SSAS 2005 cubes as a reporting source. It looks like I am not the only one who have noticed this trend. Brian Welcker has recently commented about the SSRS-SSAS integration in his Fingerpops blog. Here are some notes based on my experiments with the…
Read articleThis weekend, I was working on the second part of my Report Viewers article for DevX. As usual, it all started with an innocent idea which turned out into a whole-day affair. I wanted to demonstrate how to integrate the VS.NET 2005 web ReportViewer with a server report that takes a multi-value parameter. Of course, to save time to lay out the presentation layer, I…
Read articleAt last, my book "Applied Microsoft Analysis Services 2005" is available for purchase from the retail outlets, including Amazon and Barnes & Noble. This completes the arduous and time-consuming book lifecycle which readers are probably unaware of. Here is how it goes... Once the author hands off the final manuscript to the publisher, the publisher sends the electronic copy to the printer. In the case of…
Read articleIn his blog, Brian Welcker (Group Program Manager for Reporting Services) announced yesterday the arrival of the much anticipated RDL 2005 specification.
Read articleThe code samples for my web seminar "Reporting Services 2005 Tips and Tricks" can be found here. They include: Using external images (URL and web service) Expression-based connection strings XML extension to render ADO.NET datasets streamed from a web service OLAP report from SSAS CLR stored procedure integration ASP.NET Handler to echo in the incoming URL and SOAP requests to the Report Server WinReporter demo…
Read articleYesterday, I delivered a web seminar for WindowsITPro (sponsored by Microsoft) about RS 2005. I have to admit that I really enjoy it. I got more than 340 attendees. This broke my previous of record of 300 for my RS presentation at TechEd Europe 2004. The best thing about a web seminar is that you do it from the comfort of your house or office.…
Read articleMicrosoft has released a refresh of the SQL Server 2005 documentation. On the same page, you will find also a link to a SQL Server 2005 Samples and Sample Databases download.
Read articleMicrosoft has come up with a new Report Pack for Great Plains which uses SQL Server Reporting Services and comes with a number of report templates.
Read articleAs you probably know, when the RS Windows-based security doesn’t meet your requirements, you can replace it with custom security. Not many products out there allow you do this. In hist blog, Russell Christopher explains how you can use the Whidbey/2.0 SQLMembershipProvider with custom security.
Read articleCourtesy to the Marco Russo’s blog, I've learned that Microsoft released a KPIUtil tool for Microsoft Office Business Scorecard Manager 2005.The tool allows users to export KPIs from both a Microsoft Office Business Scorecard Manager 2005 server and a Microsoft SQL Server 2005 Analysis Services server.
Read article
