Jocelyn Dagrain
|
| Posted: 03/15/2002, 8:42 AM |
|
Bonjour
Your CC web site is host by an ISP and you want to add printing/reporting capabilities to your Web application.
You can’t use Crystal Reports because you need the server component of Crystal Reports installed by your ISP.
In the community discussion Ken Hardwick came with a good solution.
I would like to propose an other option I found an interesting software to design report 100% Java library.
I try it quickly an I have been able to create basic reports in no time. But it up to you to go deeper to create (group, subtotal etc. ). One more thing it is cheap 20$.
Features
-You can visually design your reports
-Report fields can be populated using (Database JDBC, Arrays, JTables, programatically, user defined data sources)
-Components of the reports (fields (format, alignment), current date, current page number, images, combos, areas, checkbox, background, borders, lines, rectangles, nested areas, page frame, page header/footer, report header/footer, page orientation, areas "Listener)
-Use Java 1 or 2 printing API
-Export to HTML
-Export to PDF
-Source code available
-printer configuration for jdk 1.3
-AWT or Swing preview window
-Preview, zoom and browse
-Sample Servlet for web
You can download it at :
http://www.java4less.com/print_java_e.htm
Please let me know if you like it
|
|
|
 |
marco
|
| Posted: 03/15/2002, 9:19 AM |
|
Hi,
I did read the website and see support of jdbc. DO you have experience if odbc is supported aswell?
Marco
|
|
|
|
Jocelyn Dagrain
|
| Posted: 03/15/2002, 12:41 PM |
|
If your database doesn’t have a JDBC driver you can use the ODBC driver as well.
To do this enter the connection data in the Report's Properties Database URL: if you use a ODBC connection just enter the DSN here. Then Database user and Database password. If needed. Next Activate the database connection. Select YES in the DB Active combo box.
Information about JDBC:
JDBC technology is an API that lets you access virtually any tabular data source from the JavaTM programming language. It provides cross-DBMS connectivity to a wide range of SQL databases, and now, with the new JDBC API, it also provides access to other tabular data sources, such as spreadsheets or flat files.
The JDBC API allows developers to take advantage of the Java platform's "Write Once, Run AnywhereTM" capabilities for industrial strength, cross-platform applications that require access to enterprise data. With a JDBC technology-enabled driver, a developer can easily connect all corporate data even in a heterogeneous environment.
|
|
|
|
|
