Groups | Blog | Home
all groups > sql server odbc > july 2004 >

sql server odbc : Creating Reports from a SQL Server Database


Jim Pockmire
7/14/2004 2:23:22 PM
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 Otey
7/14/2004 11:30:59 PM
If you're using SQL Server 2000 then Reporting Services would definitely be
a better option.

Michael Otey


[quoted text, click to view]

Jim Pockmire
7/15/2004 3:16:06 PM
Michael,

Yes this is a SQL Server 2000 database. But being unfamiliar with it, is
"Reporting Services" a component of SQL Server?

Jim

[quoted text, click to view]

Jim Pockmire
7/15/2004 3:38:05 PM
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?


[quoted text, click to view]

Michael Otey
7/15/2004 9:53:56 PM
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/reporting/howtobuy/default.asp

Michael Otey

[quoted text, click to view]

AddThis Social Bookmark Button