Entries by Prologika - Teo Lachev

Excel Add-in for SQL Server Analysis Services

I have recently discovered the Excel Add-in for SQL Server Analysis Services. If Office Web Components are overkill for your Analysis Services smart client deployment or dev requirements, check out this toy. It requires Excel 2002 and higher installed on the user machine. Once connected to Analysis Services (standard, offline and HTTP connectivity is supported) you […]

Dynamic Query Data Extension Available

One of the limitations of RS version 1.0 is that it doesn’t allow you set the connnection string (a.k.a. data source) during runtime. For example, you may need to support separate databases per client and based on the logged on client you may need to redirect the user to the appropriate database. To address this issue, […]

URL addressability vs. RS Web service

Judging by the questions post on the RS newsgroup, many developers are often confused about which implementation choice will best meet their integration requirements. I hope the following comparison will help you evaluate them:   URL addressability  (HTTP-GET)                                     ·          Implementation–The report request is submitted on the client side of the application directly to the Report Server. For […]

Time to migrate

Recently I had to migrate a Report Server installation from one server to another by keeping the Report Server catalog intact. If you find yourself in the same situation, here are the steps (hope I recall them right ): If you haven’t done this already, back up the encryption key of the old RS installation. […]

School is here…and so is my book

My book “Reporting Services in Action” is finally available in print format. For time being, it can be purchased only from the publisher’s website (http://www.manning.com/lachev). It will probably take a couple of weeks before the book reaches other outlets such as Amazon.com.   Many thanks to those of you that will purchase my book. I […]

New RS features in SQL Server 2005 Beta 2

For those of you who would like to know what new RS features have made it to SQL Server 2005 Beta 2, here is the list: Ability to load report projects in the new SQL Server 2005 Intelligence Development Studio IDE. The consequence of this is important. You don’t have to purchase VS.NET anymore just […]

TechEd Europe 2004

Well, I have to admit that I will miss the echo of the drums and buzz surrounding TechEd Europe 2004. There are many new and exciting things coming for developers next year which means a lot of reading too J   My favorite session (besides DAT354 which I presented of course) was Scott Guthrie’s one […]