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 |
|
bSandler
Starting Member
1 Post |
 Posted - 2007-10-10 : 16:01:32
|
| Hi everyone. I work for a company that uses SQL Server in our product.Recently, our clients have been requesting simple reports based on the data in our databases. We're looking for the cheapest solution that will work for our wide variety of usage situations. We're currently looking at SQL Reporting Services and Crystal Reports, but I would be open to hearing about alternatives, as long as they are cheap and reliable.Each of our clients maintains their own SQL Server, with one using MySQL (we'll ignore them for now) Some clients are using SQL Server 2005, while others are still using 2000. Some clients have 50 people using our software, and others might have as many as 5000. Of course, only a small percentage of these people will be hitting the report files at once. We also maintain a "portal" application, where many smaller customers use our server to interact with a distributed version of our application. This too could have hundreds of customers interacting with reports.I know that SQL reporting services is included free with licenses of SQL Server 2000 and 2k5m but I have also heard that it can be impractical in large scale implementations. Crystal reports has a free version included in VS.net, but reports created with that only allow 3 users at a time to access the reports.What is my best bet to get the ability to generate clean, professional reports with no special features, in a cheap fashion, with a healthy amount of scaleability? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-10 : 22:05:50
|
| Reporting service can generate report from non sql server data source, and it can deliver report to user as email. |
 |
|
|
|
|
|
|
|
Reporting for SQL Server help