Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Report Builder 2.0 ClickOnce and SQL Server 2008 CTP SP1 Experience

Posted by denglishbi on February 27, 2009

Finally, the ClickOnce version of Report Builder 2.0 is available with the CTP release of SQL Server 2008 SP1 (Community Technology Preview (CTP) for Service Pack 1 of SQL Server 2008).  The big changes that have been made now with this service pack are the following:

  • Slipstream – You are now able to integrate the base installation with service packs (or Hotfixes) and install in a single step.
  • Service Pack Uninstall – You are now able to uninstall only the service pack (without removing the whole instance)
  • Report Builder 2.0 ClickOnce capability

    Now the big question is will the support for infinite clickthrough exist?  First thing that we have to do is install SP1.  So I fired up my VPC and went through the process of updating my SQL Server 2008 CU2 release.  Here are some screenshots of the process:














    So after that process was done (took about 20 to 25 minutes on my VPC) I was now on build number 10.0.2520 with CTP SP1 for SQL Server 2008.  The main thing I wanted to check out now was the replacement of Report Builder 1.0 with 2.0 with the ClickOnce deployment.  It turns out that the Report Builder option in Report Manager still points to the 1.0 release, but you can access the 2.0 release through the following URL – http://<servername>/ReportServer/ReportBuilder/ReportBuilder_2_0_0_0.application.  If you want to change the settings for the Report Builder option in the toolbar you can go into the Site Settings and set Custom Report Builder launch URL to this path or you can also access this in the Advanced settings in the Report Server properties if you connect by using SQL Server Management Studio (SSMS) – the property is called ReportBuilderLaunchURL under the Reports section.  Then the fun begins and here are some screenshots of the process:

    Report Builder 2.0 URL application access

    Report Builder 2.0 ClickOnce Install

    Accessing the ClickOnce application with the URL address

    Almost a 50 MB install (1.0 was like a 8 MB download)

    Report Builder 2.0 ClickOnce Splash

    Report Builder 2.0 Application

    The splash screen

    And finally the application

    I went ahead and created a report against the Adventure Works DW SSAS database report model and deployed the report, but unfortunately as of now there is no infinite clickthrough (Enterprise Edition feature) support like there is with Report Builder 1.0.  Plus there wasn’t any interactive sorting capability like with the Report Builder 1.0 reports out-of-the-box.  You can go into the properties though and setup the Interactive Sorting functionality.  Will clickthrough support be available at all with Report Builder 2.0?  Am I just missing something? That was a really nice feature, but maybe Microsoft has decided to stop support for this option.  I guess if you want to stay with that then you have to go with Report Builder 1.0 and stick to a single data regionSad

    For more information about Report Builder 2.0 configuration take a look at Teo’s blog posting here Report Builder 2.0 ClickOnce.  For more information about Report Builder 2.0 take a look at my posting Report Builder 2.0 RTM install and overview.

    UPDATE (3/8/2009):

    Just read this posting, How to build a Clickthrough link in Report Builder 2.0, from Bob Meyers on the MSDN blogs in regards to a couple of different options for setting up clickthrough in Report Builder 2.0.  One option is to create the report in Report Builder 1.0 initially (and then you can modify it with Report Builder 2.0) and the other is to get some information from the Report Model and setup a ‘Go to report’ action.

  • 2 Responses to “Report Builder 2.0 ClickOnce and SQL Server 2008 CTP SP1 Experience”

    1. Dan said

      Saw the posting and added the reference information into the blog posting with the UPDATE at the end. Thanks for the comment:) I had done the first option already and tested that after installing CTP SP1, but was unaware of the other option and still haven’t had a chance to test that out yet.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out /  Change )

    Google photo

    You are commenting using your Google account. Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s

    %d bloggers like this: