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
Is resultset an interface?
How to change parameter value inside the report?
What is a functions and types in sql server?
What is master database? : SQL Server Architecture
What is an index in a database?
What is the name of reporting services config file and what’s it’s used for?
How to delete duplicate rows from table except one?
What is difference between Datepart() and Datename() in SqlServer?
Can you always create a cache of a report?
What do you understand by a view? What does the with check option clause for a view do?
Give an example of SQL injection attack ?
Why the trigger fires multiple times in single login?
How to apply cascading referential integrity in place of triggers?
What is read uncmmited?
what's the maximum size of a row? : Sql server database administration