Report Builder 2.0 release
I wanted to share Sabrena McBride's recent posting more broadly - the Reporting Services team released Report Builder 2.0 RTM: Unleash the Power of SQL Server 2008 Reporting Services for End Users with Report Builder 2.0! On October 17th, Microsoft SQL Server 2008 Report Builder 2.0 was released as part of the SQL Server 2008 Feature Pack. The download provides a stand-alone installer for Report Builder 2.0. If you have used Report Builder 1.0 in SQL Server 2005, you may have already experienced significant productivity gains using this solution to quickly generate sophisticated reports. Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible data layout, data visualizations, and richly formatted text features. It also delivers an even more intuitive report authoring environment for business and power users with a Microsoft Office look and feel - plus: Easy to use wizards for creating table, matrix and chart data regions Support for directly opening and editing reports stored on the report server Support for using server resources such as shared data sources A query designer for Microsoft SQL Server data sources Ability to read from all SQL Server Reporting Services data sources You can download Reporting Builder 2.0 here: http://www.microsoft.com/downloads/details.aspx?FamilyID=9f783224-9871-4eea-b1d5-f3140a253db6
October 19th, 2008 5:38pm

Hooray! I'm eager to start using 2.0. I've installed it on my report server, but when clients click the Report Builder button, the ClickOnce process is still launching version 1.0. What am I missing? Thanks!
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2008 6:19pm

Hello David, Report Builder 2.0 is currently stand-alone - you can start it directly from the program menu. Click-once install & launch directly from report manager / SharePointis something we are working on separately. -- Robert
October 19th, 2008 8:16pm

Can this be used with Reporting Services 2005?
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2008 9:41am

Hello Dean, Report Builder 2.0 generates 2008-based RDL structures that are not supported by RS 2005. Therefore, you cannot directly publish Report Builder 2.0 generated reports to a RS 2005 server. -- Robert
October 20th, 2008 12:11pm

Is it possible to remove the Report Builder 1.0 link from Report Manager?
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2008 7:54pm

Not at the moment. We are looking at enabling Report builder 2.0 as a Click-Once for SQL Server2008 Sp1. At this point you will be able to configure on the sever whether the link should launch RB1.0 or RB2.0. Hope this helps.
October 22nd, 2008 12:24am

Do you have a timeframe when we can expect SQL-Server 2008 SP1
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2008 4:24am

Hi, I have installed Reporting builder 2.0, every thing was fine. WhenI tried to open It from start->programs->Report Builder2.0 Its showing a Runtime error saying R6034 An application has made an attempt to load theC runtime library incorrectly. Please contact the application's support team for more information. Failed to load the configuration file 'ReportDesigner.config'. Local preview will not be available because of whichI think whenI try to run the report inside the report builder, its saying The definition of the report is invalid. Object reference not set to an instance of an object. Any help regarding this?? Thanks In Advance, Best Regards, Azhar
October 22nd, 2008 7:47am

How does this differ from the report builder in Visual Studio 2008?
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2008 4:22pm

Report Builder 2.0 is a small, stand-alone application. Other differences to BIDS 2008 includenew data region wizards and improved query builders that are not yet available in BIDS. Furthermore, Report Builder 2.0 has the ability to work in a connected server mode, i.e. loading and saving reports directly on a server, as well as running preview in a local mode or by executing the report on the server behind the scenes. Hope this helps, Robert
October 27th, 2008 7:29pm

azharullah m wrote: Hi, I have installed Reporting builder 2.0, every thing was fine. WhenI tried to open It from start->programs->Report Builder2.0 Its showing a Runtime error saying R6034 An application has made an attempt to load theC runtime library incorrectly. Please contact the application's support team for more information. Failed to load the configuration file 'ReportDesigner.config'. Local preview will not be available because of whichI think whenI try to run the report inside the report builder, its saying The definition of the report is invalid. Object reference not set to an instance of an object. Any help regarding this?? Thanks In Advance, Best Regards, Azhar It support local report rdlc? I use local mode in web,thanks.
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2008 11:34pm

Azhar,we have seen this error message when a beta version of .NET 3.5 SP1 is installed. If so, please upgrade to .NET 3.5 SP1 RTM from: http://www.microsoft.com/downloads/details.aspx?FamilyID=ab99342f-5d1a-413d-8319-81da479ab0d7&DisplayLang=en Let me know if this helps.
October 31st, 2008 2:25pm

Hi, Is Report Builder final released supposed to work with custom data processing extensions locally? There's no such thing as a RSReportDesigner.config that will make it possible to configure data extension (used to be a reportdesigner.config in RC1 even though it would not take custom data extension into account). Is there something I'm missing here? Thanks in advance for any info. Regards,
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2008 5:42pm

Hi Frederic, We pulled the configuration file into the app since RC1 for security reasons, so at RTM you will not be able to configure RB 2.0 to provide a design-time experience for custom data processing extensions. The only support will be round-tripping the CRI portion of the RDL, doing basic layoutediting and rendering them when running in server mode. We will reconsiderthe extensibility in the next release.
October 31st, 2008 6:27pm

Hi, Thanks for the prompt answer. Indeed we had already noted in the RC1 that it was possible to run and mody the layout of reports relying on custom data extension at the report level. We had written an article with a video showing how to use RB 2 for modifying a report based on our extension (http://www.enesyssoftware.com/Blogs/tabid/62/EntryID/35/language/en-US/Default.aspx). That is already a very nice feature and we can see the advantage of preparing some report witha possible complexquery within BIDS, deploying itand let some other usersrefining the overall design directly from the server. Obviously the possibility to create a report from scratch within RB2 would be a plus. Thanks for clarifying. Regards,
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2008 7:03pm

Hello, This report builder might be really a good help for our customers, BUT there is one thing I can't understand. There is support for Tables, Views, even Stored Procedures but there is no support for Functions... Why? It's a problem for our application because we store lots of data in XML columns and we have database functions which allowcustomers to extract data from complex xml fields. Those functions seems to performbetterthan views from performance point of view. Is there a chance that Function support will be added or should we move to Views? Regards, Marcin Kosieradzki
November 2nd, 2008 2:30pm

IMHOReport Builder is very importantand demanded tool. So I decided to leave some feedback describingwhat makes RB unusable for me. I would be really happy, to beable to provide RB to our customers as aconvenient replacement for BIDS which is extremally powerful, but quite difficult to use for non-developers. A serious issue is relationships feature in query designer. Even if I use views instead of functions,it is impossible (or I am unable todo this)to join two views in the designer: -Relationships view does not allow creating custom relationships, there is also no way to hint designer to generate view-based relationship. - Filters do not allow to reference another column as value I'm not happy to say this, but in our scenario (views extracting data from xml columns)query designer in BIDS is much easier to use for our customers than Query designer in RB. In RB our customerswould beforced to write INNER JOIN by hand - in BIDS they do not need to do this - they can relate tables manually. Regards, Marcin Kosieradzki
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2008 3:06pm

Hello, Thierry, Do you know how to configure the server to make the link launch RB2.0 instead of RB1.0? thanks. sherry
November 4th, 2008 4:15pm

We are working on an update package fora futureSQL Server 2008 cumulative update that will enable configuring whether the link launches RB 1.0 or RB 2.0. -- Robert
Free Windows Admin Tool Kit Click here and download it now
November 7th, 2008 12:12pm

What are the resr of us using VS2005 supposed to do wait for the Corporate to upgrade to SQl 2008. That might be years away. So we loose out on the tool update.
November 10th, 2008 7:08am

I am working on a solution at a green-field site where no users currently use BIDS or RB. Is there no way to repackage the RB2 MSI for click-once deployment - we have no need to retain RB1 so don't need any new 'functionality' just a different application deployed.It will be confusing for our new users if they by default get RB1 when trying to edit reports via Sharepoint. It is because of RB2 that I have advocated the use of SQL Server 2008 over SQL Server 2005.Any workaround would be greatly appreciated!
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2008 10:49am

HiI have a question regarding credentials.I have a little app that creates a rdl file and calls the RB 2.0 to render it. I can have a sql server 2008 and a oracle 11 as possible datasource systems.As I do not have RS installed, I like to run the rdls locally. As we are targeting customers who do not own sql server, this is not subject to change.My problem are the credentials for the datasource.For sql server I can enter the credentials in the rdl like this:<?xml version="1.0" encoding="utf-8"?><Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"> <DataSources> <DataSource Name="DataSource1"> <ConnectionProperties> <DataProvider>SQL</DataProvider> <ConnectString>Data Source=DEHBNKWIESEL1; Initial Catalog=mydb;mypwd</ConnectString> <IntegratedSecurity>false</IntegratedSecurity> </ConnectionProperties> <rdataSourceID>d1e2cee2-a695-4e5c-a2f0-9c560e993654</rdataSourceID> <rdecurityType>Windows</rdecurityType> </DataSource> </DataSources>...When the rdl loads I can run it without beeing asked for credentials.Now I like to do the same thing for oracle. But it does not work.I tried some variations like <DataSource Name="DataSource1"> <ConnectionProperties> <DataProvider>ORACLE</DataProvider> <ConnectString>Data Source=mysource; User ID=myuser; Password=mypwd</ConnectString> <IntegratedSecurity>false</IntegratedSecurity> </ConnectionProperties> </DataSource>but this ends in being asked for credentials after hitting F5 (run) in RBIs there anything I do wrong?There must be a way to use embedded credentials not only for sql server, but also for oracleAny help is really appreciatedKlaus Wiesel
November 12th, 2008 4:21am

QiL wrote: Hi Frederic, We pulled the configuration file into the app since RC1 for security reasons, so at RTM you will not be able to configure RB 2.0 to provide a design-time experience for custom data processing extensions. The only support will be round-tripping the CRI portion of the RDL, doing basic layoutediting and rendering them when running in server mode. We will reconsiderthe extensibility in the next release. is it possible to have an example . I am trying here toconnect to my shared datasourcein the server that consumes custom Datextension but i am not able to connect. My datasource is working.
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2008 3:29pm

Is Report Builder 2.0 backward compatible? Will it connect to a Reporting Services 2005 server?
November 25th, 2008 2:36pm

My understanding is that for data sources, there is some backward compatability, but you can only PUBLISH RB2.0 reports to a SQL 2008 report server
Free Windows Admin Tool Kit Click here and download it now
November 27th, 2008 6:45pm

Hy. Was wondering if there was any way of restricting the access to the database ferom RB 2.0, because since you can make querys, you can pretty much have free access to all the data base. Is it possible to use a model in RB 2.0, so that the user can only change the layout, and not be able to change the query ? I am new to the Reports business, so if there is a security answer to this question I would apreciate some help. Thank you.
December 3rd, 2008 5:18am

Yes, SMDL models are usable on RB2. The design experience using such a model is not as seamless as it was in RB1, though. Instead of the RB1 integrated query/layout experience, RB2 requires the user to define a dataset off of the SMDL model, then lay out the report. The upside is that you can have multiple dataregions based on a single SMDL dataset, and you have the full RDL available to you, unlike RB1. Regards. Mike
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2008 2:26pm

Am I using and understanding how Report Builder 2.0 can be used? I have already worked with the MS support team and thought that I had a clear understanding of what I was able to do. Unfortunately, RDLC's with 2008 is a key component for us that hopefully will be out soon. 1. SQL 2005 reports will automatically be upgraded to SQL 2008 reports when opened or run in SQL2008 2. SQL 2005 reports are visible on web pages using the report viewer. 3. SQL 2008 reports are NOT visible on web pages using the report viewer (at this time until an upgraded viewer is released). 4. SQL 2008 Report Builder can created reports based on SQL 2008 or SQL 2005 databases. 5. SQL 2008 and SQL 2005 can coexist on the same server without issues. So, I have written a report using Report Builder 2.0 that will access a SQL 2005 Workgroup edition database. To do this, I thought the proper approach was to install SQL 2008 Express w/Reporting Services which I have done at the client site however I get either an error that says the Report database instance is the wrong version or I get a login failure with the data source. I have now loaded all of SQL 2008 Express interface tools so that I can set permissions, etc. What have I missed here trying to use the Report Builder 2.0 or event SQL 2008 Reporting Services? Thanks, Chris
December 7th, 2008 7:18pm

Hi,Pleasebe serious : this is not a v2.0.This is a beta version.For example, with RB2.0 v10.0.1600.601)open RB1.0, in the Open section, select Open From File, select Workstation.You will see the name of a drive followed by its letter e.g. System (C:).2)open RB2.0, click on the top left button, select Open, select Workstation. You will only see the letters, which isuselesswhen you get a list of letters without names...In my opinion, when a software does nothave at least the abilities of its prior version it is still a BETA version.a+, =)-=Clement=-
Free Windows Admin Tool Kit Click here and download it now
December 30th, 2008 10:40am

I too need the ability to define models ahead of time that users can then query against. IMO this tool is most useful for ad-hoc reporting by people who are not experts on the underlying data structure.So... I've been trying to find out where you can report against a model. I assume you need to be connected to a SSRS server. Is that correct?Unfortunately, I am unable to connect to my SSRS server. When trying to connect to the SSRS server from within RB2, I get this error:Connection failed.Unable to connect to the server that is specified in the URL, 'http://[server]/Reports_MSSQLSERVER2008/'.Make sure the server is running, the URL is... [the rest is cut off]If I put that URL in the browser, I get to the Reporting Services Home.Any idea what the problem is?Thanks,-Gus
January 14th, 2009 4:57pm

I use a lot of local reports in a .net windows client application. It's a hassle to build and run the application everytime you made some adjustments on a report. Is there a way to save a report developed with tb 2.0 to .rdlc?Marel
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2009 3:36pm

Hi, I understand from Robert's post in November 2008 that MS is working on this issue: "We are working on an update package fora futureSQL Server 2008 cumulative update that will enable configuring whether the link launches RB 1.0 or RB 2.0." Is there any progress made? I have just started working on Reporting Services and started using SQL Server 2008 with RB 2.0. Yesterday I had this demo and I could not give proper explaination as why from client browser the Report Manager launches RB 1.0? This is crucial !! It's fine if you can tell us about approximately when will this be ready? Regards, Manish
January 30th, 2009 9:27am

Manish, The link launched the RB 1.0 because RB 2.0 is not currently available as a ClickOnce application. RB 2.0 is availableinan MSI installer. Progress has been made on the ClickOnce deployment of its successor and the "Report Builder" link will change in the future.
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2009 1:20pm

Gus, Try'http://[server]/ReportServer_MSSQLSERVER2008/' instead of'http://[server]/Reports_MSSQLSERVER2008/'.
January 30th, 2009 1:37pm

Hi Folks !!!I am migrating my existing SQL server 2000 project to SQL server 2008 and also going to use Reporting Services. I have couple of issues which may be potential roadblocks in this make over. I have my web application which is consumed by different clients across the world. All the clients have there own user base with different access and we are managing it completely inside (not using any windows authorisation and authentication). I configured Reporting Services and now a user can create a report on the model I deployed. Challenges I face are:1. We need this end user to be able to access the data that is related to only him not other clients (basically all clients data are in the same table, normalization fundas :). And in our existing reports we filter the rows from UserID i.e. his login tell us which client/group he belongs to. In existing Report Services I see one can implement Row Level filter and achieve this but this requires one to have windows authentication model. I don't have time and business priority to change entire authorization system. How can I achieve this? Can I still set some row level filters for the user?2. Again on the same lines I want to implement the report services in such a way that different clients/groups do not get to see other clients reports. So in short e.g. HSBC and Delta are clients of my application I don't want them them to see each other's data (Point 1) & Reports (Point 2). Currently all the data is displayed becasue all the clients share same data tables.Pleeeeeeeeeeeeeeease help !!Manish
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2009 2:22pm

In RB 2.0 property editor, valid values for BackgroundRepeat property are:Default, Repeat, RepeatX, RepeatY, ClipShouldn't they be (http://technet.microsoft.com/en-us/library/dd220610.aspx):Repeat, RepeatX, RepeatY, NoRepeat ?If I use the expression ="NoRepeat", it works as expected.What does Clip do?RegardsMario Mantese
January 31st, 2009 2:56pm

To the various poston this thread requesting confirmation for dates for SQL Server 2008 PCU (AKA SP1) where Report Builder 2.0 Click Once will be made available, this is currently targeted at March 31st. A CTP should be available within2-3 of weeks.I would also ask that you post questions not specifically related to RB2.0 per say on separate thread. They will get better visibility from the community and will augment the likelyhood of getting an answer.ThanksThierry D'hers [MS], This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2009 1:02am

Thierry Dhers said:Not at the moment. We are looking at enabling Report builder 2.0 as a Click-Once for SQL Server2008 Sp1. At this point you will be able to configure on the sever whether the link should launch RB1.0 or RB2.0. Hope this helps. Hi Thierry How to configure this on server? Will this (configuring on sever) help me launch RB2.0 on client browsers as well?Regards,Manish
February 2nd, 2009 6:09am

Yes we will let you configure whether RB1.0 or RB2.0 should be launched by default from the Sharepoint or Report manager.This will be set on a per report server basis.The user will not be able to choose between RB1.0 and 2.0. The server administrator will have to make that decision and configuration ahead of time for all users of each server.Hope this helps.Thierry D'hers [MS], This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2009 2:11am

Hello,after reading this the main question is: Is there an timeframe when we can expect Sp1? (i mean - do we speak in weeks,months or quarters ??)I also want to know if we can expect in near future a new Report builder (for example 2.1 or something like that) or is this the final report Builder until the next major SQL Server release?Best regards Martin
February 3rd, 2009 8:27am

Hiii ,Is it possible to pass a key filter parameter to the Model on Report Serve? A parameter like user id, which will be used further to run all the reports in that user session. I don't have active directory integrated to the application hence I can't use something like GetUserId() in row filter.This is critical to implement Reporting Services in our application.With Regards,Manish
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2009 8:43am

I am alsonot able to connect to the report server.I can browse to http://devhome.abc123.com/reportserverand see the folders and list of reports as expected.ButI get the same error, 'Unable to connect...'. I haven't found any specific 'Help' as to the format either.I am trying to connect to a SQL Server 2005 RS. Is this the problem? Does it have to be 2008?I am trying to use a Report Model.Thanks,Neil
February 3rd, 2009 10:32am

Try to use the port number along with the server name.http://devhome.abc123.com:8080/reportserver
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2009 10:34am

It is on port 80. I did try that but still no connection.Thanks for the suggestion.Any more? ;)Neil
February 3rd, 2009 10:47am

I want to address the various questions on this forum regarding timing.SQL 2008 PCU (or SP1) is slated for late in March this year.As to whether it is the final release of Report Builder 2008. the answer we will keep making necessary fixes in the various PCU (AKA SPs), but we are not enhancing it anymore. It is feature complete for 2008.The next release of SQL server was announced last november at the BI conference, SQL Server codename Kilimanjaro is targeted to ship at the same time as Office 14, in the first half of 2010.This release of SQL server is focused on Self Service BI scenario (Gemini, Self Service Reporting)and as a result we are already building more major enhancements to the Kilimanjaro version of the Report Builder. Lots of cool stuff in there, but too soon to talk about it :-) Sorry for the teaser.Soon I will come back to this forums to offer for volunteersto join andto take part to the SQL Server Kilimanjaro TAP customer program. This program will be very limited (less than 20 customers)and will likely start in the April timeframe.As for the next Major release of SQL Server (that includes enhancements to all components, not just the BI ones), it was annouced by our VP Ted Kummert during the BI conference, to be released 36 months after we shipped SQL 2008. And we are definitely planning to keep enhancing Report builder in this release as well.So bottom line, yes, we will keep enhancing Report Builder with every single release that we can from now on and try to get these enhancements released to you as often and quickly as we possibly can...Hope this addresses everyone questions.Thierry D'hers [MS], This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 4th, 2009 1:45am

Hi,thank you very much for the clear answer! And keep on the good work!
February 4th, 2009 1:56am

Demos are good. Some improvements are needed to make it a professional report builder.1. Like Crystal Reports, an option of use saved data will help when switching between design and run.2. Bug: Paper orientation is not persisted in rdl, when exporting to PDF, it always goes back to Portrait.3. Bug: Reports with Expand/Collapse option when exporting to PDF, only persist the current view; could export the outline. Export to Excel is good, persisted the outline.4. General impression: still a baby product; should target real office product level that can replace Crystal Reports.
Free Windows Admin Tool Kit Click here and download it now
February 5th, 2009 5:44pm

Maybe you could try hiding it via CSS, Visible = false or similar ?
February 8th, 2009 7:01pm

Do you have a roughtimescale to when click and launch will be incorporated into report manager for report builder 2.0?Many thanks,Tanya
Free Windows Admin Tool Kit Click here and download it now
February 23rd, 2009 11:38am

Hi Thierry,I currently in the process of co-authoring a book on SQL 2008 Reporting Services and SharePoint Integrated Mode. Some of the things you've posted here are quite intresting. I love to chat with you regardingKilimanjaro. Please contact me at Coskun [at] captare [dot] comThank you,Coskun CavusogluCoskun Cavusoglu "http://www.sharepointblogs.com/gnarus"
March 2nd, 2009 3:55am

Hi,I though the SQL 2008 SP1 that can be downloaded from microsoft.com already fix RB1 to RB2 clickonce problem.But after I read this threat, I just figure out that RB2is still cannot be used in SQL 2008 Sharepoint Integration ClickOnce.My Question are :1. What version ofSQL 2008 SP1 that currently can be downloaded!?2. Whenwill this SP that fix RB2 clickonce be released!?Please help.Thanks,Bing
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2009 3:49am

Bing : 1. Sql Server 2008 SP1 CTP is currently available. It includes RB2 ClickOncefor Native-mode RS deployments.2. RB2 ClickOnce for Sharepoint integrated mode deployments will be released as a separate MSI (similar to the sharepoint integration MSI) very soon.
March 10th, 2009 1:46pm

Hi Sheldon,Thanks for your answer, now I fully understand about current SQL 2008 SP1.Please let us know asap, when the RS2 ClickOnce SP is released. I urgently need it.Thanks,Bing
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2009 10:48pm

Bing : 1. Sql Server 2008 SP1 CTP is currently available. It includes RB2 ClickOncefor Native-mode RS deployments.2. RB2 ClickOnce for Sharepoint integrated mode deployments will be released as a separate MSI (similar to the sharepoint integration MSI) very soon. Any update about point #2 information!?
April 8th, 2009 3:40am

SP1 was released yesterday: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19If you run Reporting Services in SharePoint integrated mode, make sure to also install the updated RS add-in for SharePoint: http://www.microsoft.com/downloads/details.aspx?FamilyID=58edd0e4-255b-4361-bd1e-e530d5aab78fHTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2009 11:35am

SP1 was released yesterday: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19 If you run Reporting Services in SharePoint integrated mode, make sure to also install the updated RS add-in for SharePoint: http://www.microsoft.com/downloads/details.aspx?FamilyID=58edd0e4-255b-4361-bd1e-e530d5aab78f HTH, Robert Robert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights. WOW !!! That's a news we have been waiting for. I already had tried beta version of SP1 though but couldn't dare to install that on production server. So I am hoping the moment I install this SP I must start geting Report Builder 2.0 launched from all the clients? Or I need to do some configuration act in Site Settings or something. Regards, Manish Pathak
April 9th, 2009 4:24am

Hello Manish,after installing SP1, if you are using native mode, you should go to Report Manager -> Site Settings and set the Custom Action URL to: /ReportBuilder/ReportBuilder_2_0_0_0.application HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
April 10th, 2009 1:40am

SP1 was released yesterday: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19If you run Reporting Services in SharePoint integrated mode, make sure to also install the updated RS add-in for SharePoint: http://www.microsoft.com/downloads/details.aspx?FamilyID=58edd0e4-255b-4361-bd1e-e530d5aab78fHTH,Robert Robert Bruckner http://blogs.msdn.com/robertbrucknerThis posting is provided "AS IS" with no warranties, and confers no rights. I'm very glad to hear this good news. May I just install "RB2ClickOnce.msi" or I need to reinstall "rsSharePoint.msi" as well? Thanks, Bing
April 17th, 2009 12:09am

The SharePoint add-in only needs to be installed if you run RS in SharePoint integrated mode.I'm not sure I understand your question regarding RB2ClickOnce.msi - it is installed as part of service pack 1 for RS 2008. If you just wantthe updated stand-alone version of ReportBuilder directly installed (not click once), you can also download it here as msi: http://www.microsoft.com/downloads/details.aspx?FamilyID=dbddc9b6-6e19-4d4b-9309-13f62901b0d5HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2009 9:34pm

I got an error when I tried to "Open with Report Builder"Here is the error details:ERROR DETAILSFollowing errors were detected during this operation.* [4/24/2009 1:14:08 PM] System.Deployment.Application.InvalidDeploymentException (HashValidation)- File, Microsoft.Data.ConnectionUI.Dialog.dll, has a different computed hash than specified in manifest.- Source: System.Deployment- Stack trace:at System.Deployment.Application.ComponentVerifier.VerifyFileHash(String filePath, Hash hash)at System.Deployment.Application.ComponentVerifier.VerifyFileHash(String filePath, HashCollection hashCollection)at System.Deployment.Application.ComponentVerifier.FileComponent.Verify()at System.Deployment.Application.ComponentVerifier.VerifyComponents()at System.Deployment.Application.DownloadManager.DownloadDependencies(SubscriptionState subState, AssemblyManifest deployManifest, AssemblyManifest appManifest, Uri sourceUriBase, String targetDirectory, String group, IDownloadNotification notification, DownloadOptions options)at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) COMPONENT STORE TRANSACTION DETAILSNo transaction information is available.Please help.
April 24th, 2009 2:05am

Please help, I couldn't find any solution by googling...
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2009 10:36pm

The SharePoint add-in only needs to be installed if you run RS in SharePoint integrated mode.I'm not sure I understand your question regarding RB2ClickOnce.msi - it is installed as part of service pack 1 for RS 2008. If you just wantthe updated stand-alone version of ReportBuilder directly installed (not click once), you can also download it here as msi: http://www.microsoft.com/downloads/details.aspx?FamilyID=dbddc9b6-6e19-4d4b-9309-13f62901b0d5HTH,Robert Robert Bruckner http://blogs.msdn.com/robertbrucknerThis posting is provided "AS IS" with no warranties, and confers no rights. Please help... I got an error message..
April 26th, 2009 10:37pm

Hello Manish,after installing SP1, if you are using native mode, you should go to Report Manager -> Site Settings and set the Custom Action URL to: /ReportBuilder/ReportBuilder_2_0_0_0.application HTH,Robert Robert Bruckner http://blogs.msdn.com/robertbrucknerThis posting is provided "AS IS" with no warranties, and confers no rights. Please help.. I got an error
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2009 11:05pm

The SharePoint add-in only needs to be installed if you run RS in SharePoint integrated mode.I'm not sure I understand your question regarding RB2ClickOnce.msi - it is installed as part of service pack 1 for RS 2008. If you just wantthe updated stand-alone version of ReportBuilder directly installed (not click once), you can also download it here as msi: http://www.microsoft.com/downloads/details.aspx?FamilyID=dbddc9b6-6e19-4d4b-9309-13f62901b0d5HTH,Robert Robert Bruckner http://blogs.msdn.com/robertbrucknerThis posting is provided "AS IS" with no warranties, and confers no rights. Please Help.. I got an error... urgent
May 12th, 2009 11:05pm

The error may have to do with your click once application cache (i.e. an older version of the application is already on your local machine).You may wanto to try launching Report Builder from a different / clean machine. If it works there, you may want to try to clean out the click once cache on the affected machine. That cache is typically found under: C:\Users\<username>\AppData\Local\Apps\2.0\DataHTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2009 9:06pm

The error may have to do with your click once application cache (i.e. an older version of the application is already on your local machine).You may wanto to try launching Report Builder from a different / clean machine. If it works there, you may want to try to clean out the click once cache on the affected machine. That cache is typically found under: C:\Users\<username>\AppData\Local\Apps\2.0\DataHTH,Robert Robert Bruckner http://blogs.msdn.com/robertbrucknerThis posting is provided "AS IS" with no warranties, and confers no rights. I cant find C:\users folder in my local computer
May 24th, 2009 11:45pm

Is there a way to modify the "folder" that appears by default when a user - within report builder - goes to "save report"?modifying the default save folder for Report Builder reports
Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2009 1:03pm

Is there a way to use Report Builder 2.0 against Report Models hosted onSSRS 2005?
June 16th, 2009 12:14pm

Report Builder 2.0 produces RDL 2008 format, which only works with SSRS 2008 and later.Robert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2009 5:26pm

The error may have to do with your click once application cache (i.e. an older version of the application is already on your local machine).You may wanto to try launching Report Builder from a different / clean machine. If it works there, you may want to try to clean out the click once cache on the affected machine. That cache is typically found under: C:\Users\<username>\AppData\Local\Apps\2.0\DataHTH,Robert Robert Bruckner http://blogs.msdn.com/robertbrucknerThis posting is provided "AS IS" with no warranties, and confers no rights. Hi Robert,I am experiencing the same issue with using the ClickOnce installation from Report Manager.I previously had reportbuilder installed directly from the April 2009 Feature Pack. I've uninstalled this as well as clearing my clickonce cache as instructed above.I've installed CU4 for SP1 and my error log file the failed installation looks as follows:PLATFORM VERSION INFOWindows : 5.1.2600.131072 (Win32NT)Common Language Runtime : 2.0.50727.3082System.Deployment.dll : 2.0.50727.3053 (netfxsp.050727-3000)mscorwks.dll : 2.0.50727.3082 (QFE.050727-3000)dfdll.dll : 2.0.50727.3053 (netfxsp.050727-3000)dfshim.dll : 2.0.50727.3053 (netfxsp.050727-3000) SOURCESDeployment url: http://localhost:8080/ReportServer_SQL2008/ReportBuilder/ReportBuilder_2_0_0_0.applicationServer: Microsoft-HTTPAPI/1.0X-AspNet-Version: 2.0.50727Application url: http://localhost:8080/ReportServer_SQL2008/ReportBuilder/RptBuilder_2/MSReportBuilder.exe.manifestServer: Microsoft-HTTPAPI/1.0X-AspNet-Version: 2.0.50727 IDENTITIESDeployment Identity: ReportBuilder_2_0_0_0.application, Version=10.0.2734.0, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=x86Application Identity: MSReportBuilder.exe, Version=10.0.2734.0, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=x86, type=win32 APPLICATION SUMMARY* Online only application.* Trust url parameter is set.ERROR SUMMARYBelow is a summary of the errors, details of these errors are listed later in the log.* Activation of http://localhost:8080/ReportServer_SQL2008/ReportBuilder/ReportBuilder_2_0_0_0.application resulted in exception. Following failure messages were detected:+ File, Microsoft.Data.ConnectionUI.Dialog.dll, has a different computed hash than specified in manifest. COMPONENT STORE TRANSACTION FAILURE SUMMARYNo transaction error was detected. WARNINGSThere were no warnings during this operation. OPERATION PROGRESS STATUS* [30/09/2009 20:13:16] : Activation of http://localhost:8080/ReportServer_SQL2008/ReportBuilder/ReportBuilder_2_0_0_0.application has started.* [30/09/2009 20:13:16] : Processing of deployment manifest has successfully completed.* [30/09/2009 20:13:16] : Installation of the application has started.* [30/09/2009 20:13:21] : Processing of application manifest has successfully completed.* [30/09/2009 20:13:26] : Request of trust and detection of platform is complete. ERROR DETAILSFollowing errors were detected during this operation.* [30/09/2009 20:13:36] System.Deployment.Application.InvalidDeploymentException (HashValidation)- File, Microsoft.Data.ConnectionUI.Dialog.dll, has a different computed hash than specified in manifest.- Source: System.Deployment- Stack trace:at System.Deployment.Application.ComponentVerifier.VerifyFileHash(String filePath, Hash hash)at System.Deployment.Application.ComponentVerifier.VerifyFileHash(String filePath, HashCollection hashCollection)at System.Deployment.Application.ComponentVerifier.FileComponent.Verify()at System.Deployment.Application.ComponentVerifier.VerifyComponents()at System.Deployment.Application.DownloadManager.DownloadDependencies(SubscriptionState subState, AssemblyManifest deployManifest, AssemblyManifest appManifest, Uri sourceUriBase, String targetDirectory, String group, IDownloadNotification notification, DownloadOptions options)at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) COMPONENT STORE TRANSACTION DETAILSNo transaction information is available. Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)
September 30th, 2009 3:18pm

@Adam My error also like yours@ModeratorPlease help us, I have tried to solve this error, but fail
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2009 11:16pm

not sure how significant this is (or not) but I also had Report Builder 3.0 installed at the time, although uninstalling it didn't help. My machine was due a re-build anyway and on a clean install all works fine.Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)
October 12th, 2009 7:08am

Can report builder 2 use access 2 database for its data source, & if so how. I have been googling everywhere to find out
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2010 2:04pm

Hello larikn,yes, in Report Builder 2.0 you can create reports with multiple database connections and multiple queries.HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
February 8th, 2010 11:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics