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
Do you know what is blocking?
Difference between report and query parameter. Why do we need different type of parameter?
How to test values returned by a subquery with the in operator?
Explain ms sql server reporting services vs crystal reports?
Explain transaction server explicit transaction?
How to generate create function script on an existing function?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are the built in functions in sql server?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is system stored procedures?
Explain about system database?
What are the disadvantages of primary key and foreign key in SQL?
How to create new table with "create table" statements?
How to create indexed view?
How to recover from sql injection? : sql server security