Browse by Tags

• .NET
• Analysis Services
• Articles
• Business Intelligence
• General
• SharePoint
• SQL Server 2008
• Writing

• Reporting Services 2008 Dashboard Goes Live

  Thanks to the Robert Bruckner's blog , I've learned that Microsoft has published the Reporting Services 2008 Information Aggregator. It is a cool dashboard page that aggregates a variety of resources related to Reporting Services, such as training... Posted Jan 05 2009, 12:44 PM by tlachev with | with no comments Filed under: Reporting Services, Business Intelligence

• SQL Server 2005 Service Pack 3 is Out

  Yesterday, Microsoft released SQL Server 2005 Service Pack 3. Reporting Services Report Builder added support with Teradata. Note that some manual configuration is required to turn things 'on' as well as you need to install the .Net provider from... Posted Dec 18 2008, 08:03 AM by tlachev with | with no comments Filed under: General, Reporting Services

• Dimensionalizing Pivoted Measures

  Issue You have a table with pivoted measures, such as: Use the following statement to create and populate the table: CREATE TABLE pvt ( VendorID int , DateID int , MaturityAmount1 int , MaturityAmount2 int , MaturityAmount3 int , RepricingAmount1 int... Posted Dec 15 2008, 07:43 PM by tlachev with | with no comments Filed under: Reporting Services, Analysis Services, Business Intelligence

• Troubleshooting the SharePoint Add-in for Reporting Services

  A common issue when setting up Reporting Services integration with SharePoint is that the SharePoint add-in is not installed properly although the setup program doesn't indicate any issues. More than likely, the culprit is that the person who installed... Posted Nov 19 2008, 05:06 PM by tlachev with | with no comments Filed under: Reporting Services, SharePoint

• Referencing Parameters in SSRS Calculated Members

  Issue : You author an SSRS report that connects to a cube. You want to create a calculated member that uses a report parameter. For example, the Selector calculated member in the following query returns 1 if a given employee has exceeded 1 million in... Posted Nov 09 2008, 07:09 PM by tlachev with | with no comments Filed under: Reporting Services, Analysis Services

• Report Builder 2.0 RTM'ed

  Today, Microsoft released Report Builder 2.0 (build 10.00.1600.60) , as Robert Bruckner announced in his blog. This is a major milestone in the Reporting Services roadmap. In my opinion, Report Builder 2.0 is one of the most important and exciting features... Posted Oct 17 2008, 10:59 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• Extending Report Builder 2.0

  As I mentioned in my previous blog , Report Builder 2.0 RC1 has arrived. Although perhaps too early in the game, you may wonder how you can get the most out of Report Builder 2.0 and extend it when the built-in features are not enough. As Report Designer... Posted Aug 31 2008, 02:20 PM by tlachev with | with 1 comment(s) Filed under: Reporting Services, SQL Server 2008

• Report Builder 2.0 RC1 is Here

  Thanks to Robert Bruckner's blog , I've learned that the Report Builder 2.0 (previously known as Report Designer Preview) Release Candidate 1 is available for download. This should be a feature-complete build of Report Builder 2.0, which is scheduled... Posted Aug 25 2008, 07:12 PM by tlachev with | with 1 comment(s) Filed under: Reporting Services, SQL Server 2008

• Where is Report Builder 2.0?

  With the official release of SQL Server 2008, Microsoft retired the RC0 Feature Pack and added the SQL Server 2008 Feature Pack, August 2008 page . Unfortunately, the Report Builder 2.0 link got dropped along the way. Microsoft is aware of this issue... Posted Aug 13 2008, 09:32 PM by tlachev with | with 2 comment(s) Filed under: Reporting Services, SQL Server 2008

• Rules Have Changed

  An interesting question has pop up on the Katmai RS 2008 discussion list today about how to implement a "green bar" group-level report that alternates background color for all rows in a group instance instead of doing this for each row. I attach... Posted Aug 05 2008, 10:26 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• Yet Another Post About Analysis Services HTTP Connectivity

  With risk to iterate the obvious, here is a lesson learned from the trenches: Scenario : You want to let external users browse an Analysis Services cube over the Internet. Setup : You have followed the steps in the Configuring HTTP Access to SQL Server... Posted Aug 01 2008, 10:30 PM by tlachev with | with 2 comment(s) Filed under: Reporting Services, Analysis Services

• A Must-read Reporting Services Blog

  Robert Bruckner on the Reporting Services team has started a blog . Robert oversees several key areas of Reporting Services, including Report Definition Language (RDL), data processing, report processing, data visualization, and performance/scalability... Posted Jul 21 2008, 03:53 PM by tlachev with | with 2 comment(s) Filed under: Reporting Services

• It's Done

  A quick update on my book Applied Microsoft SQL Server 2008 Reporting Services. I am happy to announce that the work on the manuscript is over and the manuscript RTM'd (released to manufacturing). The paper copy should be available on the reseller... Posted Jul 20 2008, 11:11 PM by tlachev with | with no comments Filed under: Reporting Services, Business Intelligence, SQL Server 2008

• Automating Report Deployment

  Here is an awesome tip courtesy to the Craig Guyer's I Command Thee blog . You probably know that Visual Studio supports project configurations. In BIDS 2008, you can automate report deployment with configurations. For example, the following command... Posted Jul 12 2008, 10:31 AM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008

• Textbox on Steroids

  One of the new features in Reporting Services 2008 that debuted in the SQL Server 2008 RC0 build is the enhanced textbox report item. In previous releases, if you wanted to mix static and dynamic expression-based text, you either needed multiple textboxes... Posted Jun 19 2008, 02:13 PM by tlachev with | with no comments Filed under: Reporting Services, SQL Server 2008