What is Report Server,Report Manager and Report Builder in
SSRS 2005?

Answer Posted / bruhaspathy medishetty

Report Server is not a tool when you compare it with Report
Manager or Report Builder.

Report Server can be defined as the Server which has SQL
Server Reporting Services Installed. All the reports are
generated and processed before rendering on this Server.

Report Manager is the one tool which is used by SSRS
Admin/Developer to manage the reports, Data Sources, Roles
and Schedules etc. There is a Browser based Report Manager
apart from the one available from the Management Studio.

Report Builder is again a browser based tool that enables
in creation of adhoc reports by end users without really
knowing much about the underlying Database Details.

See SQL Server Books Online for more.

Thanks,
Bruhaspathy
www.learnsqlwithbru.com

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of forms?

496


Define inner join? Explain with an example?

516


Is ssrs support other database except ms sql server?

96


how to control the amount of free space in your index pages? : Sql server database administration

598


When a primary key constraint is included in a table, what other constraints does this imply?

603






What is the purpose of floor function?

541


What is conditional split?

543


What does executeupdate return?

537


How to execute a sql statement using odbc_exec()?

571


What types of replication are supported in sql server?

566


What is user defined stored procedures?

564


How many columns can we include on clustered index ?

511


What is spid in sql server profiler?

538


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3756


Explain about Normalization?

567