Home > Archive > Microsoft SQL Server forum > March 2006 > Sql server report









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Sql server report
Daniel

2006-03-28, 11:29 am

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

Rgds
Daniel

Erland Sommarskog

2006-03-28, 8:26 pm

Daniel (Danieltbt05@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Daniel

2006-03-29, 9:28 am

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

Regards
Daniel

Erland Sommarskog wrote:
> Daniel (Danieltbt05@gmail.com) writes:
>
> 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, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx


Erland Sommarskog

2006-03-29, 8:26 pm

Daniel (Danieltbt05@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/... /> ayLang%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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Daniel

2006-03-30, 9:30 am

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

Rgds
Daniel



Erland Sommarskog wrote:
> Daniel (Danieltbt05@gmail.com) writes:
>
> 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/... /> ayLang%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, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com