Sql server report

[Daniel]

Does SQL server have any build in generated report function ? or like
pivot tables for analysing data ? Pls advise.

Rgds
Daniel

[Erland Sommarskog]

Daniel (Da*********@gmail.com) writes:

Does SQL server have any build in generated report function ? or like
pivot tables for analysing data ? Pls advise.

SQL Server comes with a component called Reporting Services with which
you can create reports.

There is also Analysis Services where you can create cubes and all
that.

I've not used any of these components myself, so I can't give more details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Daniel]

I'm using sql server 2000 personal edition but not seeing this
component ? where is it?

Regards
Daniel

Erland Sommarskog wrote:

Daniel (Da*********@gmail.com) writes:

Does SQL server have any build in generated report function ? or like
pivot tables for analysing data ? Pls advise.

SQL Server comes with a component called Reporting Services with which
you can create reports.

There is also Analysis Services where you can create cubes and all
that.

I've not used any of these components myself, so I can't give more details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Erland Sommarskog]

Daniel (Da*********@gmail.com) writes:

I'm using sql server 2000 personal edition but not seeing this
component ? where is it?

Reporting Services does not come with SQL 2000, of the simple reason that
Reporting Services was not released until 2003.

You can download the Evaluation Edition here
http://www.microsoft.com/downloads/i...splayLang%3den

I don't know the exact procedures to get a copy of Reporting Services
for real, but I am fairly confident that it is include in the regular
license for SQL 2000. Whether it actually runs on Personal Edition, I
don't know.

I would suggest that you contact your local Microsoft representative
for the commercial details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Daniel]

Regular license means standard edition ? can get it to work in sql 2000
personal edition anyway ?

Rgds
Daniel

Erland Sommarskog wrote:

Daniel (Da*********@gmail.com) writes:

I'm using sql server 2000 personal edition but not seeing this
component ? where is it?

Reporting Services does not come with SQL 2000, of the simple reason that
Reporting Services was not released until 2003.

You can download the Evaluation Edition here
http://www.microsoft.com/downloads/i...splayLang%3den

I don't know the exact procedures to get a copy of Reporting Services
for real, but I am fairly confident that it is include in the regular
license for SQL 2000. Whether it actually runs on Personal Edition, I
don't know.

I would suggest that you contact your local Microsoft representative
for the commercial details.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx