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).
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 ?
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.
I'm having a problem on uploading reports created in RB 2.0 in a SSRS 2005 reportserver
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.