Producing Reports from Progress Db

R

restrohl

New Member
Our main Order Entry / Inventory Control application was developed using Progress. I believe it is verion 9 (something) running in the UNIX world on a UNISYS box using SCO UNIX. I would like to access the data in Progress and generate some management reports. I have Crystal Reports ver 9 on my Windows XP workstation. How can I get Crystal to access the data Progress has or is there a tool in Progress which would let me generate Crystal like reports that I could publish in .pdf format?
Any and all help will be appreciated.
Thanks
Ray
 
Progress sells an ODBC driver that would enable access to CR. Disadvantages, cost, setup complexity, overhead (slowing down the database application).

Or you could write some simple "for each" Progress export programs on a daily/weekly basis and load the data into Access or other database engine.

The following will create a comma delimited file that can easily be imported into an access db.

for each order-master
where (date selection etc.)
export order-master delimiter ",".
end.
 
ODBC connectivity (also known as SQL-92) doesn't cost anything.

Version 9."something", however, is too vague. There were big changes in SQL-92 throughout the v9 release cycle that greatly impact what works and how well it works. Today version 9 is ancient, obsolete and unsupported. The only quasi-"supported" release of v9 is 9.1E service pack 4 which was released 5 years ago. (About all the support you are going to get is a shoulder to cry on...)

Unisys and SCO aren't exactly cutting edge either.

If you can compile code I would pick up the whole system, move it to Linux and upgrade to OpenEdge 10. The upgrade is pretty much painless and you would be in a much better place for getting this to work.

If you cannot compile code you can still get to 9.1E without any problems and that would make the best of a bad situation in terms of a viable ODBC setup.
 
Thanks for the information. I just contacted our development group and they tell me that we are now using Progress ver 10.1C running on an IBM box with OS AIX ver 5. Does that make my desired task (Crystal interface to Progress) easier ?
 
You must log in or register to reply here.
Back
Top