Crystal Reports

You may have to use C++, Glade and likes to make reports in Linux, I am not aware of any crystal Report type program. I believe Crystal Report basically works with MS Visual Studio products
(we generally used it with VB or VC++). Gtk+ seems to bethe best bet, followed by other programming languages.
Anand


_______________________________________________
LinuxPLC mailing list
[email protected]
http://linuxplc.org/mailman/listinfo/linuxplc
 
Anand:
> You may have to use C++, Glade and likes to make reports in Linux, I
> am not aware of any crystal Report type program.

Hang on, isn't Crystal Reports a web thing?

In which case the corresponding thing would most likely be zope, but I've never used either so I can't really say.

Or you might be able to put together some Perl scripts under Apache and Postgress.


Jiri
<[email protected]>

_______________________________________________
LinuxPLC mailing list
[email protected]
http://linuxplc.org/mailman/listinfo/linuxplc
 
P

Peter Hopfgartner

If I'm right, Crystal reports allows should be a fine tool to read data from a database. Reading and writing should be simplified, but you can't
change the definition of the tables.

Depending on the database you are using (MySQL, PostgreSQL, MSSQL, Oracle) and the desktop environment (KDE, Gnome), there are quite some
tools that you can rely on. If some more information is given, I can try to provide some direction.

Mainly, if a web-based solution is wanted, then I strongly encourage PHP (had excellent results with it and I'm curently involved in a project,
where as much production information as possible is provided to the people on the plant floor through a web interface). And it's truly
multiplatform.

If you want to access to data from a Gnome environment, try out gnome-db and gASQL. I compiled it, but have not started to use it, yet.

For KDE I don't know, but they have had a lot of support for DB access. Anyway you will find enough information on http://www.kde.org

For MySQL there are a lot of specific graphical interfaces. Go to freshmeat and search for MySQL. Or try from the main MySQL site,
http://www.mysql.com.

If you want to script, then try out Python. I use it usually to implement interfaces between different Systems. And it's truly multiplatform, too. For a good Windows implementation go to
http://www.activestate.com. On Linux, your distribution should have the right packages.

I hope this helps,

Peter

_______________________________________________
LinuxPLC mailing list
[email protected]
http://linuxplc.org/mailman/listinfo/linuxplc
 
C

Curt Wuollet

Like these?

CR is QBE is it not?

http://sourceforge.net/projects/repgen/
http://www.gnu.org/software/grg/grg.html
http://www.thekompany.com/projects/kugar/
Regards

cww

--
Free Tools!
Machine Automation Tools (LinuxPLC) Free, Truly Open & Publicly Owned
Industrial Automation Software For Linux. mat.sourceforge.net.
Day Job: Heartland Engineering, Automation & ATE for Automotive
Rebuilders.
Consultancy: Wide Open Technologies: Moving Business & Automation to
Linux.

_______________________________________________
LinuxPLC mailing list
[email protected]
http://linuxplc.org/mailman/listinfo/linuxplc
 
A long time ago I worked with SQL reportwriter on HP-UX. This software is similar to crystal report (not an exact one). The present Crystal report that i worked with (almost 8 months ago) had better formatting, but SQL reportwriter in case it exists till date should have a similar interface.

I believe Crystal report has to do more with formatting the data from a database for good presentation on print and on screen.

Anand

Visit www.smbd.org for
Free Tutorials, Source Codes and Other stuff.

_______________________________________________
LinuxPLC mailing list
[email protected]
http://linuxplc.org/mailman/listinfo/linuxplc
 
Anand:
> I believe Crystal report has to do more with formatting the data from a
> database for good presentation on print and on screen.

BTW, if you're after nice print and you're writing your own script because it's beyond the quick-report things (or easier), I recommend making the output LaTeX.

It's a bit of a pain to learn, but once you know it it's no more difficult to use than any other formatted output, and because it's a DTP package, the output is a class above what people expect from quick'n'dirty Perl scripts.

Neat kerning, digraphs, hyphenation, full justification, 1- or 2-column, proper en and em dashes, the works.


Obviously, if a reporting package can do the job, you should use that because it'll be quicker; but if you need to write your own stuff, you might as well have something nice to show for it :)

Jiri
--
Jiri Baum <[email protected]> http://www.csse.monash.edu.au/~jirib
MAT LinuxPLC project --- http://mat.sf.net --- Machine Automation Tools
_______________________________________________
LinuxPLC mailing list
[email protected]
http://linuxplc.org/mailman/listinfo/linuxplc
 
www.inetsoftware.de
they have a program call i-net crystal clear teh server version to view the reports via http and the designer just like crystal clear but runs in every os that supports java
 
Men, i heard that linux developer are currently developing a package similar to crystal report in windows based... right now, most of the java developers like me who creates a report in linux... are being created manually, i would recommend to write reports written in java, that way, you can customized any type of layout you want. In our case, we do touchscreen POS systems written in java. All of our reporting tools are being done manually, third parties usually has some disadvantages.

Best of Luck,
Lhander
 
K

Koby Peleg Hen

Hello all
We at Mksoft are at the same stage about having reporting tools under linux.
After makeing a lot of searching we made a decision to write a new reporting tools using python.
 
Top