What r sql reporting services and analysis services? how
can we use it.
Answer Posted / selvaraj.v
Sql Server Reporting Services:
------------------------------
SQL Server 2000 Reporting Services relies on several major
components to function correctly.
Report Manager (RM) is used to administer the RS web
service and can be used to serve up reports from a folder /
list interface. RM is actually a web application that calls
the RS web service.
Database Server: This machine hosts the SQL Server 2000
databases required to persist application information.
Reports can be drawn from SQL Server, ODBC or Oracle data
sources.
SQL Server Reporting Services (SSRS) is a server based
report generation environment developed by Microsoft. It
can be used to deliver a variety of interactive and printed
reports. It is administered via a web interface. Reporting
services features a web services interface to support the
development of custom reporting applications.
SSRS is a competitor of Crystal Reports and other Business
intelligence tools, and is included in Express, Workgroup,
Standard, and Enterprise editions of Microsoft SQL Server
as an install option. Reporting Services was first released
in 2004 as an add-on to SQL Server 2000. The current
version was released as a part of SQL Server 2005 in
November 2005.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Can we deploy SSRS reports on our personal website?
Explain cross join or cartesian product in sql?
Explain the difference between functions and stored procedures in sql server?
how to control the amount of free space in your index pages? : Sql server database administration
Where are sql server user names and passwords stored in sql server?
What is the difference between a function and a stored procedure?
What is catalog views?
How to modify the underlying query of an existing view?
What are alternate keys?
How do you size a resultset?
What are the elements of dbms?
How to loop through result set objects using odbc_fetch_row()?
What is difference between aggregate and analytic function?
If we delete pack Spec what will be the status of pack Body ?