As I stressed out in one of my previous posts and my book, it is an absolute must that you back up the RS encryption key as one of the first steps after you install RS and lock it up in a safe place. You can back up the encryption key this by using the rskeymgmt utility as follows: rskeymgmt -e -f <filename> -p <password>…
Read articleWhile we still have to wait for a couple of more months to get the official release, Santa is giving us a Beta preview of the forthcoming RS 2000 SP2. Key new features include: Reporting Services SharePoint Web Parts enable you to explore and view reports located on a report server by using Microsoft Windows SharePoint Services or SharePoint Portal Server. A set of Reporting…
Read articleAn interesting trend has been building momentum recently which has caught my attention. More and more authors are choosing self-publishing as a viable option to commercial publishing. Interestingly, I haven’t come across a technical author who is happy with commercial publishers and has good things to say about them. Although I am not excluding the probability that there may be a few enlighten commercial publishers,…
Read articleBrian Welcker, Group Program Manager for Reporting Services, will do awebcast on RS 2005 tomorrow at 10 am pacific time. Don't miss this opportunity to learn about the new features in RS 2005 from the ultimate authority on this subject. You can subscribe to the event by following this link https://msevents.microsoft.com/cui/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=5154053. There are more webcasts scheduled for tomorrow later during the day including Integration Services…
Read articleMany folks have been asking me about the book authoring process. “Oh, you’ve authored a book” they will gasp. Once the awe evaporates, questions start. How did you do it, how long it took, what’s the royalty fee (the most popular but usually asked last question for courtesy reasons I suppose :-). For there reasons, I would like to start a new blog category devoted…
Read articlePinnacle Publications published this article in the November issue of the Visual Basic Developer magazine. The article demonstrates how to leverage Reporting Services to generate reports on the server side of ASP.NET applications. You need a paid subscription to read it and download the code. I hope MSDN will pick it up as well in the next month or so.
Read articleI would like to share my excitment with you that Microsoft has recognized my contribution and peer support around Microsoft SQL Server Reporting Services. Today, I received the valuable Microsoft Most Valuable Professional (MVP) award for Windows Server System - SQL Server. This represents a major milestone in my professional career as a consultant and trainer. Thank you for helping me to achieve this status!
Read articleIf you liked my book “Microsoft Reporting Services in Action” please take a moment to vote for it at the Second Annual .NETDJ Readers' Choice Awards website. Thank you in advance for your support!
Read articleVersion 1.0 of Reporting Services doesn't support exporting reports to Microsoft Word format. It does support exporting to Excel but developers have limited control over the Excel renderer. For example, you may need provide placeholders (bookmarks in Word or markers in Excel) which will be populated during runtime with fields from your report query. SoftArtisians will release soon an RS version of their flagship product OfficeWriter…
Read articleIn this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features. Read the full article here ...
Read article
