473,670 Members | 2,419 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to create a report

Hi all!

How can I create a report from a Java application?
I've been developing a (small) JDBC app that retrieves invoice data giving
its number.
(I'm using a Swing GUI)
The app works fine so I can get all info I need from my network database.

I just don't know how to create a formatted output report!
The report should be viewed and/or printed.

I've been looking in huge Sun's Tutorials - no luck!
Where should I look for? Doesn't Java provides some way to do it? Do I need
additional software?
(I'm using J2SE 5.0 JDK with NetBeans 4.0)
Can someone help?
Thanks in advance,
Jorge Cecilio
Jul 17 '05 #1
3 4502
Jorge Cecílio wrote:
Hi all!

How can I create a report from a Java application?
I've been developing a (small) JDBC app that retrieves invoice data giving
its number.
(I'm using a Swing GUI)
The app works fine so I can get all info I need from my network database.

I just don't know how to create a formatted output report!
The report should be viewed and/or printed.

I've been looking in huge Sun's Tutorials - no luck!
Where should I look for? Doesn't Java provides some way to do it? Do I need
additional software?
(I'm using J2SE 5.0 JDK with NetBeans 4.0)
Can someone help?
Thanks in advance,
Jorge Cecilio


I'd look into converting the ResultSets to XML, then use a parser to
transform the data via XSLT. A bit cumbersome, it would seem, but you
may end up liking the ease of use and ease of changing the output using
a simple tool like VI. I don't know if there is a HTML viever component
in Java these days, but if there is, transform the XML to XHTML for
viewing. Printing should then also be a breeze.

Cheers,
Jul 17 '05 #2
Have a look at Scribe: www.reportgenerator.org.

The Enterprise version comes with the API library to let your app run
reports programmaticall y. The reports can be PDF or HTML formatted, or can
be displayed in your JFrame.

I posted an ad in comp.lang.java. announce yesterday, but it usually takes a
few days before any post shows up there.

Alex Molochnikov
Gestalt Corporation
"Jorge Cecílio" <ce*****@equitu bos.pt> wrote in message
news:cq******** **@news1.stadia .fi...
Hi all!

How can I create a report from a Java application?
I've been developing a (small) JDBC app that retrieves invoice data giving
its number.
(I'm using a Swing GUI)
The app works fine so I can get all info I need from my network database.

I just don't know how to create a formatted output report!
The report should be viewed and/or printed.

I've been looking in huge Sun's Tutorials - no luck!
Where should I look for? Doesn't Java provides some way to do it? Do I need additional software?
(I'm using J2SE 5.0 JDK with NetBeans 4.0)
Can someone help?
Thanks in advance,
Jorge Cecilio

Jul 17 '05 #3
Jorge Cecílio wrote:
Hi all!

How can I create a report from a Java application?
I've been developing a (small) JDBC app that retrieves invoice data giving
its number.
(I'm using a Swing GUI)
The app works fine so I can get all info I need from my network database.

I just don't know how to create a formatted output report!
The report should be viewed and/or printed.

I've been looking in huge Sun's Tutorials - no luck!
Where should I look for? Doesn't Java provides some way to do it? Do I need
additional software?
(I'm using J2SE 5.0 JDK with NetBeans 4.0)
Can someone help?
Thanks in advance,
Jorge Cecilio

You may look at the Jasper reports. For more information, visit
http://jasperreports.sourceforge.net/

Hope it helps.

Thanks.

--
Hiren
Jul 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
7564
by: Donna Sabol | last post by:
First, I should start by saying I am creating a database to be used by some very impatient, non-computer literate people. It needs to be seameless in it's operation from their point of view. I want them to do as little as possible when they run their reports. I have a crosstab query that displays usage of items for each month. It looks pretty much like this: ITEM DESC UM 12/02 1/03 2/03 3/03 ...ETC. 1 Solution ...
1
2650
by: intl04 | last post by:
I am getting strange print-related error messages when trying to create (not print!) reports. For example, when I click 'new' to create a report then choose 'design view', I get an error message that says: 'There was a problem retrieving printer information for this object. The object may have been sent to a printer that was unavailable.' When I choose 'report wizard', I can go through all of the steps but then I get an error message...
7
8852
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
7
5588
by: Ross Hamilton | last post by:
I have a Report that creates a Catalogue of Products we sell under various Headings eg: Books, Recordings, Health Food, Diet Foods, etc There are 82 Headings and a total of 6000+ products which makes a big Catalogue. A Printed version of the Catalogue is done every 2 Months and we manually create an Index which takes HOURS, the problem is the Catalogue page numbers change depending on New or Deleted product ranges.
9
2457
by: badboybrown | last post by:
Hello, Is it possible to step through the "Create MDE" process and see what is causing Access to crash? I tried, unsuccessfully, many times to create an MDE from my database. But, randomly, I checked the "Allow Full Menus" in the Startup section. I was then able to create an MDE. That worked once. It has not worked since and I don't particularly
4
5472
by: VMI | last post by:
For my website, I created CrystalReportTest.rpt (through the designer in VS 2005) and I'd like to be able to display it in viewer.aspx (all in the same project). Viewer.aspx has a Crystal Report viewer but for some reason, I can't create an instance of this report. Therefore, I can't set any of its properties. The only way I was able to run it was through: CrystalReportViewer.ReportSource = Server.MapPath("CrystalReportTest.rpt"); ...
9
9413
by: itmags | last post by:
I need to create a couple of reports, invoices, credit reports, etc... My question is: How/what is the best way to go about this using VB2005 / SQL Server 2000 Crystal Reports? MS Reporting? Home brew using print document? (Program to be distributed thoughout this office and possibly to a few other organizations that have expressed an interest). I've taken a couple of stabs at this and either this is more
3
2433
by: Vayse | last post by:
I have a report which has several sub reports. Each sub report starts on its own page, and may be 2 or 3 pages long. I'd like to create an index on the first page of the main report. Something like: Clients..............p1 Sales................p3 Salesmen.........p4
3
18701
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however, working with complex reports is tricky Assumption: Reader of this article have basic knowledge of creating data reports. Creating a Parent-Child Command and create a DataReport Suppose we have a database called company with two tables ...
6
1601
by: Steve | last post by:
I have a 2 unmatched queries Table1_view (records in table1 not in table2) Table2_view (records in table2 not in table1) Both table contain fields ReportID ReportName ReportOwner In_Table1 (True or False) In_Table2 (True or False)
0
8469
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8386
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8903
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8814
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8592
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8661
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7419
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4391
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2800
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.