There is an extremely nasty new exploit that targets a vulnerability in Windows Fax and Picture viewers (WMF). Usually, I don't pay much attention to the latest on spyware since IE always asks you to confirm download. But this one is really bad. No IE warnings or security toolbar. If you havigate to a rogue website that uses the exploit, it will bypass the IE…
Read articleThanks for Marco Russo’s blog, I’ve learned that Microsoft has released an updated version (version 1.5) of the Excel 2002/2003 Add-in for SQL Server Analysis Services. I discussed in details how version 1.0 could be used to generate ad hoc reports from SSAS cubes in my book Applied Microsoft Analysis Services 2005. Although version 1.0 was compatible with SSAS 2005, it was unaware of the…
Read article
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 article
