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
What is a benefit of using an after insert trigger over using a before insert trigger?
can any body tell me how to know the password of current user in sql server
If a stored procedure is taking a table data type, how it looks?
What is user defined datatypes and when you should go for them?
How do I view a stored procedure in sql server query?
Can You Use Data Mining Models In Ssrs?
Can you force a query to use a specific index?
What is the use of keyword with encryption.
State the difference between local and global temporary tables?
What is the default server name for sql server?
How many levels of sp nesting is possible?
Do you know what is a linked server in sql server?
What is a database table?
Define cross join in sql server joins?
What is used to replicate sessions between instances in coldfusion clusters?