Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services, including flexible report layout, data visualizations and richly formatted text. The download includes the following functionality above the RC0 release of Report Builder:
- 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.
- Enhancements to the Report Builder 2.0 ribbons.
Microsoft SQL Server 2008 R2 Report Builder 3.0
Microsoft SQL Server 2008 R2 Report Builder 3.0 has two different methods to complete the installation process:
Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.
Un-attend Installation – this is a DOS command Line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.
Abstract courtesy: Microsoft
Reference: Pinal Dave (https://blog.sqlauthority.com)
6 Comments. Leave new
Is there Business Intellegence Studio [For VS 2008] will also be available so that we can develop sql server 2008 BI solutions ?
Hi,
Is there any way in Reportbuilder to load Model data using parameter supplied. Ex: Load Model based on user rights
TIA
We have deployed SSRS 2008 and all testing has proved successfuly with the exception of Report Builder 2.0 when accessed from an Extranet. RB 1.0 works fine, but with 2.0 we are unable to access data sources.
I have been unable to find any documentation showing configuration requirements for authentication. RB 1.0 documentation listed requirements for Basic authentication to allow anonymous access.
Do you know if these are still requirements for 2.0 and if there are any additional requirements?
Thanks.
Hi,
I have an issue regarding Report Builder 2.0
Earlier I was developing my reports in 2005 now I imported these reports in Report Builder 2.0 but while clicking on Run following error appears need you help regarding this.
“The request failed with HTTP status 401: Unauthorized.”
Thanks,
Amol.
Hi,
I have just migrated to Report server 2008 from 2005. I have developed reports in VS 2005 and now I am importing them to Report Builder 2.0. A reports imported and edited in Report Builder works fine on server, but I can’t see results by running report in Report Builder. And I get error as ,
The request failed with HTTP status 401: Unauthorized
Will you please help me to know how Anonymous Access can be set enable in Report Server 2008.
Thanks,
Prathamesh
Hi Pinal,
Its be quite helpfull blog Link that i received from Abhishek And Nachiket ,
I have SQL Report Server 2008 . I want to develop Ad-hoc Query Report , I had developed Data model in Bussiness Inetllignce Studion , is it possible to Use this model in RB 2.0 ? if yes then which version ? and also I get error as ,
The request failed with HTTP status 401: Unauthorized
(Its working fine on Server ) the authorzation error is coming on netwrok acces .
Will you please help me to know how Anonymous Access can be set enable in Report Server 2008.
Environment :
Server : win 2003
SQL Server : MS SQL Server 2008 (SP1)
Report Builder : RB 2.0 and RB 1.0 (Both)
Client Environmet : Windows XP
Waiting for favorable reply.
Thanks,
Shyam Miyatra