Report Builder 2.0 released
Typical, you spend a day off line at a team building exercise and then you find that the SQL Server team have released Report Builder 2.0 to a fanfare of silence.
To rewind a bit Report Builder 2.0 sort of replaces Report Builder 1.0 that came with SQL Server 2005. The two tools are as different as black and white TV to a bluray DVD, partly due to the Office like UI…
and partly due to all the good stuff you now have in Reporting Services 2008 like charts and the new tablix data control (replacing tables and matrix).
There are two puzzling things about Report Builder 2.0, one is that Report Builder 1 still ships with SQL Server 2008, as a click once application from Report Manager and the other is that this isn’t (as yet) a click once application.
Anyway if you have been using this at RC0 or RC1 stage then please replace those betas with this as there’s more to it than the fact that the start logo top left is no longer the office logo.
If you haven’t tried this before then you can deploy it to your users for them to write their reports or at least collaborate in the report design process. Needless to say it will only allow you to deploy reports to a SQL Server 2008 reporting services installation (although the data can from any database you can get a .Net provider for).
Technorati Tags: Report Builder 2.0 release,reporting services,sql server 2008
Comments
Anonymous
October 20, 2008
Just found out that Report Builder 2.0 was released over the weekend. I've played with the lab...Anonymous
October 22, 2008
Andrew, Thanks for this. The link for Report Builder 2.0 doesn't work. I found it here though:http://www.microsoft.com/downloads/details.aspx?FamilyID=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=enAnonymous
November 24, 2008
Also realize that Report Builder 2.0 just lost the possibility to use Data Models that was possible to use while in beta version... I dont know why but this is a very disapointing item.Anonymous
November 25, 2008
Luis RB2 does support the use of models, so ping me (afryer@Micrsoft.com) if you are having trouble with that) AndrewAnonymous
November 26, 2008
Please, could you shortly describe me how to work in Report Builder 2.0. with models? Thanks PepaAnonymous
November 27, 2008
Pepa(?) I'm going to post on this separately as I can then show exactly what you need to do. AndrewAnonymous
November 28, 2008
Dear Andrew, I want to use smdl model definition file in Report Builder 2.0 and create reports based on it. I was not succesfull in opening smdl file (created with BIDS 2008). Please let me know how to use prepared smdl file in Report Builder. If you like, you can send email to jker@centrum.cz. Many thanks Josef KernerAnonymous
December 01, 2008
You need to publish the model, and then browse for it in the connections in Report Builder. Report builder needs to be configured to look at the report server for this to work by opening the icon top left and selecting options (if you didn't do this when you installed it)Anonymous
December 03, 2008
Andrew, thanks a lot. I had not correctly set the report server. After reinstalling and setting it properly during next installation it works fine. Thanks again. Josef KernerAnonymous
January 07, 2009
Andrew, please give me an advice: how to define datetime parameter in my OLAP report? When I define the parameter as datetime type, I get runtime parser error 'The syntax for .2008 is incorrect'. I tried to use CStr, Format and FormatDateTime function in Query parameters, but I wasn't successfull. Probably the trick is to properly convert the datetime value to a string, but I don't know how to do it. Thanks a lot for your advice. PepaAnonymous
January 23, 2009
How can I use Report paramters together with reports based on a report model?Anonymous
February 11, 2009
The comment has been removedAnonymous
February 23, 2009
You don't need to license RB1 or 2 separately, jst the server that the reports are published to. I have more dtail on this post.. http://blogs.technet.com/andrew/archive/2009/02/03/licensing-and-scaling-up-sql-server-bi.aspx and the offical FAQs are here.. http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspxAnonymous
April 26, 2009
deVbug’ s Blog is powered by Textcube 1. 7. 7:Anonymous
May 26, 2009
I have WSS 3.0 integrated with SQL Server 2008. I deployed the Report Builder 2.0 and all seems to work fine. Although, when I publish a Report Model and choose "Load In Report Builder" it opens RB 2.0 but the model is not preloaded. Any ideas?Anonymous
July 02, 2009
Hi, I have designed a report with report builder1.0 using a report model. I would like to use a date parameter in this report. This date parameter will always get first day of last month as StartDate and first day of this month as EndDate. How can do this with report builder1.0 ? thanks Sedat Duztas sedat.duztas@bdh.com.trAnonymous
July 03, 2009
Sedat I don't think you can, but to be honest I am not an expert on report builder 1 having only used it for one project. AndrewAnonymous
February 03, 2010
I'm having a problem on uploading reports created in RB 2.0 in a SSRS 2005 reportserverAnonymous
February 03, 2010
Should just be "save as.." from RB2 file dialog to the http://[myserver]/reportserver. My guess would be security and/or reportng services setup. However I am not really a suport guy, so I suggest testing that you can deploy a report form BI Dev Studio, that other reports are running OK first. if all else fails use one of your suport calls with your TechNet subscription/ support agreement. AndrewAnonymous
February 03, 2010
Should just be "save as.." from RB2 file dialog to the http://[myserver]/reportserver. My guess would be security and/or reportng services setup. However I am not really a suport guy, so I suggest testing that you can deploy a report form BI Dev Studio, that other reports are running OK first. if all else fails use one of your suport calls with your TechNet subscription/ support agreement. Andrew