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.
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.
File too large for the destination file system
Posted by denglishbi on February 15, 2009
I experienced this last year working with external USB drives and Virtual Machine files (vhd). I have seen this come up quite a bit and if you are trying to setup the MS BI VPC then this trick and advice will definitely be helpful.
The reason for this is going to be the file system of the USB or destination that you are copying the file to. The file that you are trying to transfer or extract is greater than 4GB in size and the destination file system is most likely FAT32. FAT32 file system does not support files larger than 4GB in size.
Now in my scenario I had a Western Digital (WD) passport USB drive (default file system setup is FAT32) and I had about 100GB of existing files already on the drive. I really did not want to transfer these files in order to change the file system (and I couldn’t because I am a pack rat and did not have any room to offload the files to). So what can you do? Well luckily I came across a blog posting by Scott Hanselman ‘The Duh Files – The file is too large for the destination file system’. In this posting he provides a very convenient way to convert a file system without having to reformat the drive or move existing files.
If you run into this then you definitely need to check out Scott’s posting above and follow his instructions. The last drive I got, SimpleTech 320GB, came formatted as NTFS, so no issues
Posted in Personal Comments | 1 Comment »