-
New Wave of Presentation Delivery – Web Seminars
December 7, 2005 / No Comments »
Yesterday, 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. No travel, hassle, and travel expenses. No cell phones and other annoying sound effects. Enjoy the silence! The questions get logged in an orderly fashion, so you could preview them before you answer (or don’t :-)). You can do polls too. What could be better? The only negative thing about this particular seminar is that I was restricted to static content only and I couldn’t share my desktop for live demos. This was a limitation of the technology WindowsITPro is using, of course. Microsoft...
-
SQL Server 2005 Documentation Refresh
December 7, 2005 / No Comments »
Microsoft 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.
-
Great Plains Report Pack
December 5, 2005 / No Comments »
Microsoft 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.
-
Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider
December 5, 2005 / No Comments »
As 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.
-
KPIUtil Tool Released
December 5, 2005 / No Comments »
Courtesy 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.
-
My Top 10 RS Wish List
December 2, 2005 / No Comments »
In the spirit of the season, I compiled a list of the top 10 things that I would love Santa to implement in the next release of Reporting Services (although it may look like this won't happen next year :-). I purposely excluded enhancements to the RS data regions since it should be relatively easily to compile a list of the feature most folks complain about in the public ng. Exposing the intrinsic RDL object model to manipulate data regions and items programmatically. It will be great if this works similar to the ASP.NET user controls where controls can be added, changed, or removed at runtime. For example, custom code should be able to reference a table region to add, remove, and bind columns at runtime. Server-side events, e.g. OnReportRender, OnBodyRender, OnPrint, OnRegionRender, etc. A supported way to maintain state in custom code. Exposing the report datasets to custom code...
-
Applied Microsoft Analysis Services 2005 is shipping
December 2, 2005 / No Comments »
My book Applied Analysis Services 2005 is printed and shipped to the distributor. The paper copy can be purchased from the distributor website. Hopefully, it will make it to retailers (Amazon, B&N, etc.) by the month’s end. Happy data analyzing!
-
RS 2005 ASP.NET Report Viewer and Custom Assemblies
November 30, 2005 / No Comments »
There was an interesting post on the Reporting Services public newsgroup about an issue with the RS 2005 ASP.NET Report Viewer and custom assemblies. In a nutshell, the issue was that if you want to invoke a custom assembly from the ASP.NET Report Viewer, you need to deploy it to GAC. Because of a bug in the RTM version, copying custom assemblies to the web app bin folder will not work. This bug will be fixed in a service pack. Currently, for web applications, you have to copy custom assemblies to GAC. This issue doesn't apply to the WinForm version of the Report Viewer. In the case of WinForms apps, custom assemblies can be in the same directory as the application's .EXE file; no need to copy to GAC. An example of how the WinForm version of the Report Viewer can be configured to work with custom assemblies can be found...
-
Report Builder and SSAS 2005 Known Issues
November 24, 2005 / No Comments »
The RS 2005 Report Builder can automatically create a semantic model from an SSAS 2005 cube so your end users can generate ad hoc reports. However, it turns out that some of the SSAS 2005 features are not supported by design. More information can be found in this KB article.
-
Configuration error with stylesheets and RS 2005
November 24, 2005 / 1 Comment »
If you install RS 2005 and the default web site has a web.config file that uses the new ASP.NET 2.0 themes feature, when you attempt to run the Report Manager, you will get: Theme <theme name> cannot be found in the application or global theme directories The reason for this error is that the styleSheetTheme element in the root web.config is automatically inherited by the nested web.config files. This error is not RS-specific. It happens with any nested web site because ASP.NET attempts to located that folder and apply it to the nested web site. To fix the error, break the inheritance chain by changing the styleSheeTheme in the nested Report Manager web.config file, as follows: <pages validateRequest="false" styleSheetTheme=""/>
Training
We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.For more information or to register click here!
Books
Learn Power BI at your own pace with our latest book Applied Microsoft Power BI. Targeting information workers, data analysts, pros, and developers, It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.
