Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
doogie
Starting Member
1 Post |
 Posted - 2012-05-18 : 07:57:30
|
 Hi All, Am completely new to SQL Server of any variety, but am hoping you could point me in the right direction with something.The company I work for has an application DB running on SQL Server 2000. Up until now, the user community have been sent a large daily report (created & run using the inbuilt Crystal Reports bundled version on the server), but due to the size of the data it's pulling back, CR has been struggling.To work around the problem, someone's been manually pulling off the data from the SQL DB, outputting it into xls/csv format, making it pretty, then sending it onto the users (as a workaround).We'd like to run this report automatically once more, so we're not reliant on a 'human being' or the mistakes which can happen as a resuly of doing things 'the old fashioned way'  Someone showed me SSRS running on a SQL Server 2005 instance we have elsewhere, and to be honest, it did everything we needed it to do...only problem is, our legacy application is still running on SQL Server 2000. Upgrading to 2005 isnt an option at this point & as funds are tight, we can't go blowing a fortune on a new reporting system to generate this (+ a few other) reports.My questions are:1) Is SSRS available for SQL Server 2000 (I read online that it was introduced as an add-in, but later incorporated + bettered into SQL Server 2005 + upwards). Is this correct? 2) What other reporting options might there be, which are cost effective? (or better, free!).Hope you're all still awake after reading my life-story above  Cheers Doogie |
|
|
igorkruk.pl
Starting Member
4 Posts |
|
|
mmattson
Starting Member
3 Posts |
Posted - 2012-05-22 : 07:03:18
|
| You can use SSRS to report from SQL 2000. Of course, you need to get the report builder component. when you install SQL 2005 (or greater) you can install Reporting Services.However, I have a feeling your issue is more resources than reporting tool. I have taken a number of SQL 2000 DBs and moved them to new hardware. I bet you would experience huge performance gains doing this. If the server where this DB lives is old(er), you could virtualize the whole server and experience performance gains across the board. |
 |
|
|
chriscairns
Starting Member
2 Posts |
Posted - 2012-05-30 : 03:47:32
|
| Two of the coolest tools that have ever come out from Microsoft are certainly Microsoft SQL Server and Microsoft Access.unspammed |
|
|
|
|
|
|
|
|
SQL Server 2000 - SSRS?