Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
From: "Mike Curwen" <g_dev9xq@globallyboundless.com>
To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
Subject: RE: Free reporting s/w that works with apache+tomcat
Date: Tue, 10 May 2005 10:23:20 -0500
Message-ID: <00c501c55574$33110d50$4600000a@BALTHAZAR>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-Reply-To: <20050510145320.76521.qmail@web20022.mail.yahoo.com>
Importance: Normal

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:laxmiuk@yahoo.com] 
> Sent: Tuesday, May 10, 2005 9:53 AM
> To: Tomcat Users List; fzlists@omnytex.com
> 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" <fzlists@omnytex.com> 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" <fzlists@omnytex.com>
> > 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:
> > >>
> > >>tomcat-user-unsubscribe@jakarta.apache.org
> > >>
> > >>>For additional commands, e-mail:
> > >>
> > >>tomcat-user-help@jakarta.apache.org
> > >>
> > >>>
> > >>>
> > >>>
> > >>>.
> > >>>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >
> >
> ---------------------------------------------------------------------
> > > 
> > >>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > >>For additional commands, e-mail:
> > >>tomcat-user-help@jakarta.apache.org
> > >>
> > >>
> > > 
> > > 
> > > 
> > > 		
> > > 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: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > tomcat-user-help@jakarta.apache.org
> > 
> > 
> 
> 
> 
> 		
> 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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org