none
Report Builder 2.0 Released!

    General discussion

  • 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


     

    Sunday, October 19, 2008 9:38 PM

All replies

  • 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!

    Sunday, October 19, 2008 10:19 PM
  • 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 / SharePoint is something we are working on separately. 

     

    -- Robert

    Monday, October 20, 2008 12:16 AM
  • Can this be used with Reporting Services 2005?

     

    Monday, October 20, 2008 1:41 PM
  • 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

     

    Monday, October 20, 2008 4:11 PM
  • Is it possible to remove the Report Builder 1.0 link from Report Manager?

     

    Tuesday, October 21, 2008 11:54 PM
  • Not at the moment.

    We are looking at enabling Report builder 2.0 as a Click-Once for SQL Server 2008 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.

     

    Wednesday, October 22, 2008 4:24 AM

  • Do you have a timeframe when we can expect SQL-Server 2008 SP1
    Wednesday, October 22, 2008 8:24 AM
  • Hi,

       I have installed Reporting builder 2.0, every thing was fine. When I 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 the C 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 which I think when I 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

    Wednesday, October 22, 2008 11:47 AM
  • How does this differ from the report builder in Visual Studio 2008?

     

    Monday, October 27, 2008 8:22 PM
  • Report Builder 2.0 is a small, stand-alone application.  Other differences to BIDS 2008 include new 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

    Monday, October 27, 2008 11:29 PM
  •  azharullah m wrote:

    Hi,

       I have installed Reporting builder 2.0, every thing was fine. When I 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 the C 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 which I think when I 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.

    Thursday, October 30, 2008 3:34 AM
  • 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.
    Friday, October 31, 2008 6:25 PM
  •  

    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,

    Friday, October 31, 2008 9:42 PM
  • 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 layout editing and rendering them when running in server mode.

    We will reconsider the extensibility in the next release.
    Friday, October 31, 2008 10:27 PM
  • 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 with a possible complex query within BIDS, deploying it and let some other users refining 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,

    Friday, October 31, 2008 11:03 PM
  • 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 allow customers to extract data from complex xml fields. Those functions seems to perform better than 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

    Sunday, November 02, 2008 7:30 PM
  • IMHO Report Builder is very important and demanded tool. So I decided to leave some feedback describing what makes RB unusable for me. I would be really happy, to be able to provide RB to our customers as a convenient 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 to do 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 customers would be forced to write INNER JOIN by hand - in BIDS they do not need to do this - they can relate tables manually.

     

    Regards,

    Marcin Kosieradzki

    Sunday, November 02, 2008 8:06 PM
  •  

    Hello, Thierry,

    Do you know how to configure the server to make the link launch RB2.0 instead of RB1.0?  thanks.

    sherry

    Tuesday, November 04, 2008 9:15 PM
  • We are working on an update package for a future SQL Server 2008 cumulative update that will enable configuring whether the link launches RB 1.0 or RB 2.0.

     

    -- Robert

     

    Friday, November 07, 2008 5:12 PM
  • 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.


    Monday, November 10, 2008 12:08 PM
  • 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!
    Tuesday, November 11, 2008 3:49 PM
  • Hi
    I 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>
          <rdBig SmileataSourceID>d1e2cee2-a695-4e5c-a2f0-9c560e993654</rdBig SmileataSourceID>
          <rdTongue TiedecurityType>Windows</rdTongue TiedecurityType>
        </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 RB

    Is there anything I do wrong?

    There must be a way to use embedded credentials not only for sql server, but also for oracle

    Any help is really appreciated
    Klaus Wiesel
    Wednesday, November 12, 2008 9:21 AM
  •  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 layout editing and rendering them when running in server mode.

    We will reconsider the extensibility in the next release.

     

    is it possible to have an example . I am trying here to connect to my shared datasource in the server that consumes custom Datextension but i am not able to connect. My datasource is working.

    Thursday, November 20, 2008 8:29 PM
  • Is Report Builder 2.0 backward compatible?  Will it connect to a Reporting Services 2005 server?

     

    Tuesday, November 25, 2008 7:36 PM
  • 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
    Thursday, November 27, 2008 11:45 PM
  • 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.

     

    Wednesday, December 03, 2008 10:18 AM
  • 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

    Wednesday, December 03, 2008 7:26 PM
  • 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

    Monday, December 08, 2008 12:18 AM
  • Hi,

    Please be serious : this is not a v2.0.

    This is a beta version.

    For example, with RB2.0 v10.0.1600.60
    1)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 is useless when you get a list of letters without names...

    In my opinion, when a software does not  have at least the abilities of its prior version it is still a BETA version.

    a+, =)
    -=Clement=-
    Tuesday, December 30, 2008 3:40 PM
  • 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
    Wednesday, January 14, 2009 9:57 PM
  • 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
    Monday, January 19, 2009 8:36 PM
  •  Hi,

    I understand from Robert's post in November 2008 that MS is working on this issue:

    "We are working on an update package for a future SQL 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

    Friday, January 30, 2009 2:27 PM
  •  Manish,

    The link launched the RB 1.0 because RB 2.0 is not currently available as a ClickOnce application. RB 2.0 is available in an MSI installer.

    Progress has been made on the ClickOnce deployment of its successor and the "Report Builder" link will change in the future.

    Friday, January 30, 2009 6:20 PM
  • Gus,

    Try 'http://[server]/ReportServer_MSSQLSERVER2008/' instead of 'http://[server]/Reports_MSSQLSERVER2008/'.

    Friday, January 30, 2009 6:37 PM
  • 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

     

    • Edited by Manish Pathak Monday, February 02, 2009 11:14 AM Highlighting
    Friday, January 30, 2009 7:22 PM
  • In RB 2.0 property editor, valid values for BackgroundRepeat property are:
    Default, Repeat, RepeatX, RepeatY, Clip

    Shouldn'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?


    Regards
    Mario Mantese

    Saturday, January 31, 2009 7:56 PM
  • To the various post on 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 within 2-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.

    Thanks
    Thierry D'hers [MS], This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, February 02, 2009 6:02 AM
  • Thierry Dhers said:

    Not at the moment.

    We are looking at enabling Report builder 2.0 as a Click-Once for SQL Server 2008 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

    Monday, February 02, 2009 11:09 AM
  • 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.
    Tuesday, February 03, 2009 7:11 AM
  • 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
    Tuesday, February 03, 2009 1:27 PM
  • 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
    Tuesday, February 03, 2009 1:43 PM
  • I am also not able to connect to the report server.
    I can browse to http://devhome.abc123.com/reportserver and see the folders and list of reports as expected.
    But I 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
    Tuesday, February 03, 2009 3:32 PM
  • Try to use the port number along with the server name.

    http://devhome.abc123.com:8080/reportserver



    Tuesday, February 03, 2009 3:34 PM
  • It is on port 80. I did try that but still no connection.
    Thanks for the suggestion.
    Any more? ;)

    Neil
    Tuesday, February 03, 2009 3:47 PM
  • 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 volunteers to join and to 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.
    Wednesday, February 04, 2009 6:45 AM
  • Hi,

    thank you very much for the clear answer! And keep on the good work!

    Wednesday, February 04, 2009 6:56 AM
  • 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.
    Thursday, February 05, 2009 10:44 PM
  • Maybe you could try hiding it via CSS, Visible = false or similar ?
    Monday, February 09, 2009 12:01 AM
  • Do you have a rough timescale to when click and launch will be  incorporated into report manager for report builder 2.0?

    Many thanks,
    Tanya

    Monday, February 23, 2009 4:38 PM
  • 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 regarding Kilimanjaro.

    Please contact me at Coskun [at] captare [dot] com

    Thank you,
    Coskun Cavusoglu

    Coskun Cavusoglu "http://www.sharepointblogs.com/gnarus"
    Monday, March 02, 2009 8:55 AM
  • 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 RB2 is still cannot be used in SQL 2008 Sharepoint Integration ClickOnce.

    My Question are : 
    1. What version of SQL 2008 SP1 that currently can be downloaded!?
    2. When will this SP that fix RB2 clickonce be released!?

    Please help.

    Thanks,
    Bing
    Tuesday, March 10, 2009 7:49 AM
  • Bing :

    1. Sql Server 2008 SP1 CTP is currently available. It includes RB2 ClickOnce for 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.
    Tuesday, March 10, 2009 5:46 PM
  • 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

    Thursday, March 12, 2009 2:48 AM
  • Bing :

    1. Sql Server 2008 SP1 CTP is currently available. It includes RB2 ClickOnce for 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!?
    Wednesday, April 08, 2009 7:40 AM
  • 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.
    Wednesday, April 08, 2009 3:35 PM
  • 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
    Thursday, April 09, 2009 8:24 AM
  • 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/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, April 10, 2009 5:40 AM
  • 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.

    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
    Friday, April 17, 2009 4:09 AM
  • 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 want the 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-13f62901b0d5

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, April 20, 2009 1:34 AM
  • I got an error when I tried to "Open with Report Builder"

    Here is the error details:

    ERROR DETAILS
     Following 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 DETAILS
     No transaction information is available.

    Please help.

    Friday, April 24, 2009 6:05 AM
  • Please help, I couldn't find any solution by googling...
    Monday, April 27, 2009 2:36 AM
  • 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 want the 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-13f62901b0d5

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Please help... I got an error message..
    Monday, April 27, 2009 2:37 AM
  • 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/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Please help.. I got an error
    Wednesday, May 13, 2009 3:05 AM
  • 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 want the 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-13f62901b0d5

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Please Help.. I got an error... urgent
    Wednesday, May 13, 2009 3:05 AM
  • 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\Data

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, May 22, 2009 1:06 AM
  • 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\Data

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.

    I cant find C:\users folder in my local computer
    Monday, May 25, 2009 3:45 AM
  • 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
    Wednesday, June 03, 2009 5:03 PM
  • Is there a way to use Report Builder 2.0 against Report Models hosted on SSRS 2005?
    Tuesday, June 16, 2009 4:14 PM
  • 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.
    Tuesday, June 16, 2009 9:26 PM
  • 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\Data

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This 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 report builder 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 INFO
     Windows    : 5.1.2600.131072 (Win32NT)
     Common Language Runtime  : 2.0.50727.3082
     System.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)

    SOURCES
     Deployment url   : http://localhost:8080/ReportServer_SQL2008/ReportBuilder/ReportBuilder_2_0_0_0.application
          Server  : Microsoft-HTTPAPI/1.0
          X-AspNet-Version: 2.0.50727
     Application url   : http://localhost:8080/ReportServer_SQL2008/ReportBuilder/RptBuilder_2/MSReportBuilder.exe.manifest
          Server  : Microsoft-HTTPAPI/1.0
          X-AspNet-Version: 2.0.50727

    IDENTITIES
     Deployment Identity  : ReportBuilder_2_0_0_0.application, Version=10.0.2734.0, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=x86
     Application 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 SUMMARY
     Below 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 SUMMARY
     No transaction error was detected.

    WARNINGS
     There 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 DETAILS
     Following 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 DETAILS
     No transaction information is available.

     


    Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)
    Wednesday, September 30, 2009 7:18 PM
  • @Adam My error also like yours

    @Moderator

    Please help us, I have tried to solve this error, but fail

    Monday, October 12, 2009 3:16 AM
  • 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)
    Monday, October 12, 2009 11:08 AM
  • Can report builder 2 use access 2 database for its data source, & if so how. I have been googling everywhere to find out
    Wednesday, February 03, 2010 7:04 PM
  • Hello larikn,

    yes, in Report Builder 2.0 you can create reports with multiple database connections and multiple queries.

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, February 09, 2010 4:03 AM