Sorry I'm late to the party.
I've been working with jasperreports from sourceforge the last couple of weeks to create reports in PDF. It also has the ability to create an excel spreadsheet as well, although I haven't used it yet. Using it in conjunction with iReports, also from sourceforge, you can have a report in minutes. I would recommend using it to anyone.
Joe
Mike Curwen wrote:
you should consider using POI, if you need Excel-only features like "footer
repeated on every page".
Specifically:
http://jakarta.apache.org/poi/hssf/quick-guide.html#HeaderFooter
-----Original Message-----
From: U K Laxmi [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 9:53 AM
To: Tomcat Users List; [EMAIL PROTECTED]
Subject: Re: Free reporting s/w that works with apache+tomcat
Thank you for the information.
What i mean by header & footer is, column headers and some information like model number, date and approval signature columns etc.. to appear in every page when they take hard copy of the report. Is such a thing possible? Pls inform.
The end user of the application doesn't want any
manual intervention. When he click on 'Export to
Excel' button in the web application HTML report, he
want the excel file get downloded (file dialog box
appears & he save it to his local disk) which has all
header & footer information set. Currently my
application can provide header once at the top of the
report and footer (approval columns & date) at the
very bottom of the report. THe column headings &
approval columns doesn't appear on every page.
I'm unable to ahcieve this in web (HTML). It i cna do it in web, when i download that in excel, it will show. Do you know any work around for this? Pls inform.
Thank you. Laxmi
--- "Frank W. Zammetti" <[EMAIL PROTECTED]> wrote:
Hi,
CSV files don't generally contain header and footer
information... you
can get column headers in the first row, that's
about it. I don't believe DataVision will export to Excel natively,
but check the docs in case I'm wrong.
Do you really mean header and footer in the sense of
a Word document?
It's a bit unusual to have such a thing in an Excel
document (although not at all unheard of), so I'm wondering if maybe
you mean something a little different, i.e., maybe just column headers
and some sort of totals?
Frank
U K Laxmi wrote:
Thank you for the information. I read your report
and
it looks interesting. I went to DataVision web
site
and found that it can export comma separated files
ie.
CSV file. Will it be possible to retain header and footer information with a .CSV file? I basically
want
excel files as the report output. B'coz the end
user
needs to send to those reports to it's vendors.
Excel
is the most desired format for them. Pls give your feedback on this before i start implementing on
this.
Thank you.
--- "Frank W. Zammetti" <[EMAIL PROTECTED]>
wrote:
Take a look at DataVision. I think you'll like
it.
I wrote an article
a while back specifically dealing with using it in
web applications. Although the article uses servlets and you say
your
using JSPs (just JSP's?) it should still be applicable.
http://www.omnytex.com/articles
Feel free to ping me if you decide to use it and need some help getting going beyond the article and included
documentation.
-- Frank W. Zammetti Founder and Chief Software Architect Omnytex Technologies http://www.omnytex.com
U K Laxmi wrote:
I'm developing a web application using
apache+tomcat
on windows 2000 machine. I'm using Ms Access 2003
as
the backend. I'm using JSP for developing web application. I'm developing some web based
reports
in
HTML. But when i export them to Excel, it doesn't
look
exactly same as that of HTML report. Moreover i
need
some header and footer information appear in the report. That i'm unable to achieve using JSP and
HTML.
So, i'm looking for a free reporting software
that
can
meet above functionality and can work with apache+tomcat. If anyone know any work worunds
for
my
problem, pls inform me. It will be a great help
to
me.
Thank you.
__________________________________
Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your
mobile phone.
http://mobile.yahoo.com/learn/mail
---------------------------------------------------------------------
To unsubscribe, e-mail:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Discover Yahoo! Have fun online with music videos, cool games, IM
and more. Check it out!
http://discover.yahoo.com/online.html
-- Frank W. Zammetti Founder and Chief Software Architect Omnytex Technologies http://www.omnytex.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Discover Yahoo! Find restaurants, movies, travel and more fun for the weekend. Check it out! http://discover.yahoo.com/weekend.html
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]