Crystal Reports on QAD

Chris Kelleher

Administrator
Staff member
Hello,

Is anybody using Crystal Reports for reporting from QAD???

Also, are there are tools or S/w which could convert QAD ascii reports into
spreadsheet or CSV files.


Thanks and Regards,

Sanju
 

Chris Kelleher

Administrator
Staff member
We used Monarch to convert Cincom ascii reports to CSV files. Worked
very well; should work with QAD although we haven't done it yet.
Monarch is very easy to use.

HTH

Jack Kaufman
 

Chris Kelleher

Administrator
Staff member
We are using the Merant ODBC drivers to connect a 5 user site license of
Crystal Reports version 7.0 to QAD. Everything connects up fine - you open
Crystal Reports and see all of the QAD tables, but once you
pick the tables, setup the relationships, etc and go to create the sql
statement, we get an error message. After calling Crystal Reports technical
support, it appears that there is a bug in Crystal Reports which chops off
the sql statement - thus the entire statement cannot be read, so the report
will never run.

We are now using the same Merant ODBC drivers to connect to Microsoft Access
and are running our report that way. Still testing, but at least we have
one remote client up and running.

I will probably return the Crystal Reports program. If anyone has had
better luck with Crystal, I'd be interested to know.

bye,
Arden Evans
 

Chris Kelleher

Administrator
Staff member
I have seen great success with Cyberquery, the report generation tool from
Cyberscience. This tool not only allows you to bring data into excel for
manipulation, but the client version is so strong that many times you do not
even need to move it anywhere to do complex calculations or even sort by
calculated fields. I am not sure what you are looking at, but we have seen
Cyberscience help to pull data from almost any module in QAD for either a
summary report or an extensive listing. The queries can be written or
edited in any text editor without being cut off at any point.

So that my excitement about the product does not start to sound like a
commercial, I will just say that if you would like to know more about it I
would be happy to answer any questions you have.

Gary Grossman


Gary Grossman
Logan Consulting
203 N. LaSalle St. Suite 2100
Chicago, IL 60601
(312) 558-1799
(847) 612-6097 Cellular
(208) 293-8567 Fax
 

tburtovoy

New Member
We are using Transform (www.sprolinux.com) and love it as well. Not as big a name as some others but very nice. QAD reports straight to Excel, email, fax, barcode.. plus printer redirection for GDI/Host-based printers and secondary processing (run a .p when a particular report prints, etc). Written in Progress. Windows or Unix.
 
Top