Pinnacle 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 articleMicrosoft has just published my article “Microsoft Reporting Services in Action: Extending Microsoft SQL Server 2000 Reporting Services with Custom Code“ on MSDN. Excerpted from my book Microsoft Reporting Services in Action, this article demonsrates how to implement advanced features in reports by integrating them with .NET assemblies.
Read articlePlease join me at the following events to learn more about Reporting Services: Atlanta.net User Group presentation (ADNUG) on September 27th I will show you how to report-enable WinForm or web applications by integrating them with Reporting Services. Get a sneak preview of the new RS controls that will be included in the next 2005 release of Reporting Services. SQL Pass Community Summit 2004…
Read articleOften, report enabling Internet-facing applications require replacing the default RS Windows-based security with Forms Authentication. This allows clients to request reports by URL with the all the goodies that URL addressability entail, namely support for interactive features and the HTML Viewer toolbar. While RS Forms Authentication is well-documented (see the Forms Authentication whitepaper by Microsoft), something which may not be so obvious is that Forms Authentication can…
Read articleI 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 can create easility pivot-style reports. One cool feature that the…
Read articleMy book is shipping on Amazon.com. It is also available on Barnes & Noble. Hurry up until supplies last :-)
Read article
