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
Can binary strings be used in arithmetical operations?
Explain intellisense for query editing
How can we determine what objects a user-defined function depends upon?
List out a number of the wants to setup a SQL Server failover cluster?
Do you know what is openxml in sql server?
What is the difference between a primary key and a unique key? Are they the same?
can a table be moved to different filegroup? : Sql server administration
How do database indexes work?
What is mssql?
What is replication with database mirroring? : sql server database administration
Difference between report and query parameter. Why do we need different type of parameter?
How to insert and update data into a table with "insert" and "update" statements?
What is page in sql server?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
How to create percentile function?