Creating Reports from a SQL Server Database

What software/application offers the fastest performance when reporting from
a SQL Server database. Currently I am using MS-Access with an odbc
connection to the database. Although the tables are indexed, they are
somewhat large and multiple links are needed in queries. The result is that
in some instances reports take quite a while to run. I am trying to find out
if there is a "native" or faster way to produce these reports.
If you're using SQL Server 2000 then Reporting Services would definitely be
a better option.
Michael Otey
"Jim Pockmire" <jpockmire@.cinci.rr.com> wrote in message
news:ulbJc.54361$W6.54088@.fe2.texas.rr.com...
> What software/application offers the fastest performance when reporting
from
> a SQL Server database. Currently I am using MS-Access with an odbc
> connection to the database. Although the tables are indexed, they are
> somewhat large and multiple links are needed in queries. The result is
that
> in some instances reports take quite a while to run. I am trying to find
out
> if there is a "native" or faster way to produce these reports.
>
|||Michael,
Yes this is a SQL Server 2000 database. But being unfamiliar with it, is
"Reporting Services" a component of SQL Server?
Jim
"Michael Otey" <mikeo@.teca.com> wrote in message
news:%23enJXbjaEHA.3804@.TK2MSFTNGP10.phx.gbl...
> If you're using SQL Server 2000 then Reporting Services would definitely
be
> a better option.
> Michael Otey
>
> "Jim Pockmire" <jpockmire@.cinci.rr.com> wrote in message
> news:ulbJc.54361$W6.54088@.fe2.texas.rr.com...
> from
> that
> out
>
|||I am using SQL Server 2000 via Microsoft Office XP Developer Edition. I
can't seem to find out if Reporting Services is included or not. How can I
get more information?
"Michael Otey" <mikeo@.teca.com> wrote in message
news:%23enJXbjaEHA.3804@.TK2MSFTNGP10.phx.gbl...
> If you're using SQL Server 2000 then Reporting Services would definitely
be
> a better option.
> Michael Otey
>
> "Jim Pockmire" <jpockmire@.cinci.rr.com> wrote in message
> news:ulbJc.54361$W6.54088@.fe2.texas.rr.com...
> from
> that
> out
>
|||If you have SQL Server 2000 you are also licensed to use Reporting Services.
Reporting Services is an excellent reporting authoring and deployments tool.
The place to start to find out more information is:
http://www.microsoft.com/sql/reporting/default.asp
and
http://www.microsoft.com/sql/reporti...uy/default.asp
Michael Otey
"Jim Pockmire" <jpockmire@.cinci.rr.com> wrote in message
news:xxxJc.44357$mY2.4728@.fe1.texas.rr.com...
> I am using SQL Server 2000 via Microsoft Office XP Developer Edition. I
> can't seem to find out if Reporting Services is included or not. How can
I[vbcol=seagreen]
> get more information?
>
> "Michael Otey" <mikeo@.teca.com> wrote in message
> news:%23enJXbjaEHA.3804@.TK2MSFTNGP10.phx.gbl...
> be
reporting[vbcol=seagreen]
find
>