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 |
|
meishu
Starting Member
10 Posts |
 Posted - 2010-04-27 : 02:07:32
|
| Hello everyone,Our company uses an SQL 2000 Server Database for quite a few years now with a set of old software which occasionally would cause my colleagues to either cringe or silently cry.Basically what we have to do is read some numbers from the Database and issue reports, for example in Excel, or make certain filtering operation on the database according to specific details. Like all items from a certain date, or change all the items names whose color is yellow etc.Now, I've been reading some about reporting but it seems we do not have the Reporting Services installed, nor would the company buy it.So, the purpose of this post would be to ask if there is any software which would enable us to create reports of some sort without the use of any scripting language? Like a friendly interface? At the end of the day we dont need any fancy algorithms just some basic data...Any advice would be highly appreciate.Thanks. |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2010-04-27 : 17:41:33
|
| I thought sql server 2000 reporting services is free if your company has licensed sql server 2000 |
 |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2010-04-27 : 17:42:59
|
| you can also use ms access or export query results to Excel via DTS packages. |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-27 : 18:13:44
|
| Access has a very simple reporting interface, and it's easy to integrate it into SQL Server. I don't think SSRS 2000 is free. MS Offer an Eval version of it.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2010-04-27 : 18:20:22
|
| maybe the offer expired, i remembered it was a big surprise for our company when they offered for free. |
|
|
|
meishu
Starting Member
10 Posts |
Posted - 2010-04-30 : 05:10:22
|
| Thank for the replies guys, I think it's time to change direction and perhaps commission this to someone who can do it for us... |
|
|
|
|
|
|
making reports and forms for sql server 2000