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 buffer cash and log cache in sql server?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is the temp table?
How to sort query output in descending order in ms sql server?
How to delete duplicate records based on single column from a table?
Explain about the command-line tool SQLCMD?
what's the information that can be stored inside a bit column? : Sql server database administration
When would you use a before or after trigger?
what is package and it uses and how can u call a package
What is the process of indexing?
What is an active database?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How to defragment indexes with alter index ... Reorganize?
You want to implement the one-to-one relationship while designing tables. How would you do it?
How to get a list of all tables with "sys.tables" view in ms sql server?