Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

Insufficient Data

News

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…

clip_image001

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).

Posted: Monday, October 20, 2008 5:15 PM by Andrew_Fryer

Comments

Mei's BI Blog said:

Just found out that Report Builder 2.0 was released over the weekend. I've played with the lab...

# October 20, 2008 5:51 PM

Sean O'Regan said:

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=en

# October 22, 2008 5:26 AM

Luis Simoes said:

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.

# November 24, 2008 5:13 PM

Andrew_Fryer said:

Luis

RB2 does support the use of models, so ping me (afryer@Micrsoft.com) if you are having trouble with that)

Andrew

# November 25, 2008 6:11 AM

Josef Kerner said:

Please, could you shortly describe me how to work in Report Builder 2.0. with models? Thanks Pepa

# November 26, 2008 7:59 AM

Andrew_Fryer said:

Pepa(?) I'm going to post on this separately as I can then show exactly what you need to do.

Andrew

# November 27, 2008 3:00 AM

Josef Kerner said:

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 Kerner

# November 28, 2008 6:11 AM

Andrew_Fryer said:

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)

# December 1, 2008 3:51 AM

Josef Kerner said:

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 Kerner

# December 3, 2008 6:21 AM

Josef Kerner said:

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. Pepa

# January 7, 2009 7:51 AM

Meinrad Weiss said:

How can I use Report paramters together with reports based on a report model?

# January 23, 2009 7:48 AM

MarkFergusonTN said:

Andrew,  I've been tasked with getting a high level understanding of licensing of SQL Server, particularly SSRS.  As a newbie to SQL Server I'm somewhat lost.  Our company is already implementing SS2008 including SSRS but we are not using it for any "ad-hoc" reporting, only "canned" reports.  Do you know if we'll need to get licenses/CALS for all users of Report Builder 1.0 or 2.0?  Thanks!

# February 11, 2009 10:03 PM

Andrew_Fryer said:

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.aspx

# February 23, 2009 5:38 AM

Windows 7 RC1 gets special Features said:

deVbug’ s Blog is powered by Textcube 1. 7. 7:

# April 26, 2009 9:42 PM

Anthony said:

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?

# May 26, 2009 4:33 PM

Sedat Duztas said:

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.tr

# July 2, 2009 8:32 AM

Andrew_Fryer said:

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.

Andrew

# July 3, 2009 3:48 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker