| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2004-10-22 : 09:25:18
|
| I've done crystal reports in the past but not over the web.Anyone have a crystal tutorial for opening crystal reports in asp.netor even how to use the viewer control. Or anything for that matter.Jon |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-10-22 : 12:41:57
|
| Crystal Reports are the root of all Evil. Check the licensing for web projects. Last I looked, it would have cost us around $20K to have Crystal on our webserversI use Active Reports .Net for all of my .Net needs both desktop and web. It cost us about $400 methinks, and that's for all licensing that we needed. They have a good support community, but they do have their share of issues. I've not run into very many of said issues, but read their forums so that you know what you are getting into.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
jhermiz
3564 Posts |
Posted - 2004-10-22 : 13:54:32
|
| :(Darn reporting it is always such a big hassle :(20k ????? Why ????If I installed Crystal 9 on our web server I think the cost is 99.00 bucks..how did you get 20k ?The viewers job is to display the report. The reports should sit on the server. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-10-22 : 14:22:23
|
| I think they've changed how their licensing is, but it used to be $10k PER SERVER to run Crystal on a webserver to generate reports.This is when .Net first came out. I think since so many people got upset about it and dumped Crystal, they changed their licensing.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-22 : 17:41:53
|
quote:
I think they've changed how their licensing is, but it used to be $10k PER SERVER to run Crystal on a webserver to generate reports
We paid more than that where I work now. Worst investment we've ever made.Jon, if you don't know FOR CERTAIN that your current license allows you to publish web reports, DO NOT PUBLISH THEM until you find out. If you try to sneak it and Crystal finds out, you'll be hurting. We are fully licensed here and they STILL screw with us, especially support. Crystal has THE WORST support. And if you have ANY opportunity to move to something besides Crystal (like Reporting Services) DO IT NOW, and save yourself a lot of money and grief. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-10-22 : 18:03:51
|
| Reporting Services might be a good way to go too.There's a good bit of community support for that as well AFAIK.With Active Reports, they give you a fully functional demo if you want to try it out. You can develop an entire solution around it without paying anything. Then, once you pay it gets rid of an "evaluation" message at the bottom of every page of teh report.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-10-22 : 20:09:02
|
quote:
Originally posted by robvolk
quote:
I think they've changed how their licensing is, but it used to be $10k PER SERVER to run Crystal on a webserver to generate reports
We paid more than that where I work now. Worst investment we've ever made.Jon, if you don't know FOR CERTAIN that your current license allows you to publish web reports, DO NOT PUBLISH THEM until you find out. If you try to sneak it and Crystal finds out, you'll be hurting. We are fully licensed here and they STILL screw with us, especially support. Crystal has THE WORST support. And if you have ANY opportunity to move to something besides Crystal (like Reporting Services) DO IT NOW, and save yourself a lot of money and grief.
Hmm reporting services ? Dont I have to move to Yukon for that ?If not how does that integrate into the web? Do they got a viewer much like crystal? I honestly love writing reports in access cause it was so simple. Crystal is a pain in the ass, I used it for a previous project and just hated it...If I get some more info on reporting services, I can prolly convince management.I should work in sales =)Thanks,Jon |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-23 : 01:46:25
|
| Reporting Services works with SQL Server 2000, it was released in January of this year. The only reason you'd need Yukon is if you wanted to use it with Analysis Services. You need SQL 2000 to host the RS database, but you can still write reports using any source of data imaginable. It's totally web based and SOAP-accessible, and it is fully integrated with Visual Studio .Net. It is also much easier to configure the web service than Crystal server is. You can use the RS viewer or have it completely HTML compatible without using extra controls. The programming team that worked on the RS designer interface mostly came from the Access report programming unit, so there's a lot of crossover there. You can export reports to pretty much any format (Excel, PDF, XML, HTML). Data sources can be changed on the fly, and reports can be pieced together or partitioned up to be embedded within other reports or web pages. The best thing is that RS is free if you already have a SQL 2000 license, and the reports themselves are based on an open specification that you can extend and program in any language you like.Go to Microsoft's SQL Server site and look up Reporting Services, you'll get tons of information. |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-10-23 : 12:40:06
|
| Ok,So what it sounds like is not many like Crystal (including myself) especially due to costs on a web based project. I dont like crystal because it is so jumbled, there is just way too much there...maybe too many buttons ??? But ive noticed you can do the same darn thing in 4 different ways in Crystal, which to me confuses the heck out of the user in a User Interface.Rob's tempting me to look into reporting services, if it is much like Access reporting that is great news. I know I might be a wimp, but access reporting just made a lot of sense to me ....Thanks Rob.Jon |
|
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-10-23 : 13:45:29
|
| Report Services can also import Access reports, so if you are converting from Access it makes the job easier. (I have seen it fail to properly import complex nested reports but it's better than nothing.) The price is right too. I would like more control over the layout of paramater input text boxes etc. but that is comming in SP2 I believe.--KenI want to die in my sleep like my grandfather, not screaming in terror like his passengers. |
|
|
|
|
Crystal Reports