Sql server report

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

Rgds
Daniel

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

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

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

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