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:
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:
|Accessing the ClickOnce application with the URL address||Almost a 50 MB install (1.0 was like a 8 MB download)|
|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 region
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.
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.