Report Builder 2.0 released

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 Released

Mei's BI Blog — Tue, 21 Oct 2008 00:51:42 GMT

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

Dead link

Sean O'Regan — Wed, 22 Oct 2008 12:26:40 GMT

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

re: Report Builder 2.0 released

Luis Simoes — Tue, 25 Nov 2008 01:13:11 GMT

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.

re: Report Builder 2.0 released

Andrew_Fryer — Tue, 25 Nov 2008 14:11:47 GMT

Luis

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

Andrew

re: Report Builder 2.0 released

Josef Kerner — Wed, 26 Nov 2008 15:59:17 GMT

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

re: Report Builder 2.0 released

Andrew_Fryer — Thu, 27 Nov 2008 11:00:57 GMT

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

Andrew

re: Report Builder 2.0 released

Josef Kerner — Fri, 28 Nov 2008 14:11:29 GMT

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

re: Report Builder 2.0 released

Andrew_Fryer — Mon, 01 Dec 2008 11:51:41 GMT

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)

re: Report Builder 2.0 released

Josef Kerner — Wed, 03 Dec 2008 14:21:16 GMT

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

re: Report Builder 2.0 released

Josef Kerner — Wed, 07 Jan 2009 15:51:03 GMT

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

re: Report Builder 2.0 released

Meinrad Weiss — Fri, 23 Jan 2009 15:48:30 GMT

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

re: Report Builder 2.0 released

MarkFergusonTN — Thu, 12 Feb 2009 06:03:50 GMT

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!

re: Report Builder 2.0 released

Andrew_Fryer — Mon, 23 Feb 2009 13:38:09 GMT

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

Windows 7 RC1 gets special Features

Windows 7 RC1 gets special Features — Mon, 27 Apr 2009 04:42:42 GMT

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

re: Report Builder 2.0 released

Anthony — Tue, 26 May 2009 23:33:44 GMT

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?

re: Report Builder 2.0 released

Sedat Duztas — Thu, 02 Jul 2009 15:32:50 GMT

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

re: Report Builder 2.0 released

Andrew_Fryer — Fri, 03 Jul 2009 10:48:02 GMT

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