September 12, 2007 at 9:43 am
Good Morning everyone,
I have a strong need at my company for a very robust sql database reporting tool. We currently have an in house developed software program that interfaces with our DB very well, however it has it's limitations on fields and tables it can pull from due to security issues.
I am looking for a relatively low cost program that company administrators, operation managers and our executive sales team could use to pull any/all fields from any/all tables within the database preferably using some type of GUI that allows "drag and drop" functionality so as not to confuse these people with having to type out their queries.
I am sure there are numerous products out there that would adhere to my exact need but I have great trust in the opinions of the members in this forum community. Any feedback you could present to me would be greatly appreciated.
I see that SQL reporting services is available for SQL Server 2005 - is this also an option for SQL Server 2000?
Best Regards,
Andrew
September 12, 2007 at 1:34 pm
SQL Server reporting services is available for SQL Server 2000 - I think it's a separate (but free) download on the MS website. There are a number of vendors that provide reporting tools - Business Objects (Crystal Reports) is probably the best known third party tool, but it can be difficult to use even for an experienced SQL DBA. When given the choice, I've always used SSRS.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply