468,507 Members | 1,583 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,507 developers. It's quick & easy.

Sql server report

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

Rgds
Daniel

Mar 28 '06 #1
4 1475
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
Mar 28 '06 #2
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


Mar 29 '06 #3
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
Mar 29 '06 #4
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


Mar 30 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Das | last post: by
8 posts views Thread by Woody Splawn | last post: by
1 post views Thread by =?Utf-8?B?Y2hhaXJtYW4=?= | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.