There are a few ways to skin this cat. The MS SQL server reporting services have a lot of functionality. I have played around with it and took a class on it, but am not using it in production. If you are using SQL Server, you should look into this. It comes with SQL Server, you just need to install it.
I have written a VB app that ties a dedicated robot machine to watch a table in the db for a report being requested along with the parameters it needs, it then picks up the parameters and feeds them to Crystal reports which generates a file (PDF or Excel) and then it sends the report back to the requester. There are a few ways it delivers the report back to the user - e-mail, fax, or delivers back to the screen. To do this requires building reports in Crystal and setting up the parameters that the report needs. Then you have to define that report and its parameters in a control table so the robot knows how to put the parameters into Crystal. This lets you legally generate Crystal reports for your web site w/ a single license of Crystal Crystal reports also has direct web capabilities, but it is not cheep and requires the end user to have the CR plug in. I would not recommend going this route. It seems that CR changes how it works every couple of years w/o back words compatibility. I have not looked at this option reciently. Troy -----Original Message----- From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 9:12 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Reporting with Witango Hi, If you have VB 6.0, there is a Data Report designer included with it. It is similar to the reports in Access. Also, sql server reporting services is free from the microsoft website but you need Microsoft Visual Studio(r) .NET to run it. The reporting services looks promising but I haven't used it. Ted -----Original Message----- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 10:11 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Reporting with Witango MS SQL. Guess I should have stated that up front. -----Original Message----- From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 8:44 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Reporting with Witango Hi, What are you using for a database? Ted -----Original Message----- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 8:38 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Reporting with Witango Is anyone out there using any third party reporting tools either with or without Witango? We're trying to speed up our reporting capability and Witango is just not a reporting tool. We're looking at something like Crystal Reports (complicated), ActiveReports (http://www.datadynamics.com/default.aspx) have not looked at it yet, List & Label 10 (http://www.combit.com/) (can't figure out how to even use it) and others. Ideally what I'd like to be able to do is design a report and call that report from within Witango either through COM objects or even web links. I'm not sure there's anything out there but I suspect there must be. I'd like suggestions as to what anyone else is using and your impressions of it. Thanks for your help! Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce Park Drive Palm Bay, Florida 32905 Phone: 321-309-0685 E-mail: [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
