Re: Free reporting s/w that works with apache+tomcat
Thank you for the suggestion. Laxmi --- Gurumoorthy [EMAIL PROTECTED] wrote: use jasper reports with ireports ( GUI ) for jasper ... very nice :o) - Original Message - From: U K Laxmi [EMAIL PROTECTED] To: Tomcat Users List tomcat-user@jakarta.apache.org Sent: Wednesday, May 11, 2005 3:47 AM Subject: Re: Free reporting s/w that works with apache+tomcat Guess, this is more suiting to my problem. Thanks for the information. Laxmi --- Joe Plautz [EMAIL PROTECTED] wrote: 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 === message truncated === Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Free reporting s/w that works with apache+tomcat
They are unlikely to ever look exactly alike. But, you can use a java-ActiveX bridge (there are several) to build and manipulate an excel spreadsheet as an object. I have successfully used a library from IBM AlphaWorks to do exactly this. Sadly, the library I used was a precursor to a commercial product so it is no longer free. Good luck! On Mon, 2005-05-09 at 23:57 -0700, 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]
Re: Free reporting s/w that works with apache+tomcat
Thanks for your information. I got one open source product called jasper reports adviced by one of the active member in this list. I'm planning to use it for my project. Thanks, Laxmi --- David Johnson [EMAIL PROTECTED] wrote: They are unlikely to ever look exactly alike. But, you can use a java-ActiveX bridge (there are several) to build and manipulate an excel spreadsheet as an object. I have successfully used a library from IBM AlphaWorks to do exactly this. Sadly, the library I used was a precursor to a commercial product so it is no longer free. Good luck! On Mon, 2005-05-09 at 23:57 -0700, 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] Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Free reporting s/w that works with apache+tomcat
May be DisplayTag and its export functionality can help you with formating. http://displaytag.sourceforge.net/ regards, Marco http://www.druckerpatronen--preisvergleich.de http://www.tuxoo.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Free reporting s/w that works with apache+tomcat
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]
Re: Free reporting s/w that works with apache+tomcat
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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Free reporting s/w that works with apache+tomcat
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]
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]
RE: Free reporting s/w that works with apache+tomcat
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
Re: Free reporting s/w that works with apache+tomcat
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
Re: Free reporting s/w that works with apache+tomcat
This is not a solution - but a recommendation. If you output your Excel files in the XML format - then you can specify whatever you like (excluding charts). A simple way to determine what XML you need is to create a test Excel file 1st and then save it as XML and paramterise it. You can set Page size, document headers, footers, hide gridlines, define styles - anything you want. There is a Perl module (Spreadsheet::WriteExcelXML) which I use for this - rather than writing the XML myself. But the Excel XML is reasonably simple. I'm afraid I don't know if there are any corresponding Java utilities. HTH Mike U K Laxmi wrote: 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, -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Free reporting s/w that works with apache+tomcat
Sure. It's a good pointer to me to look into. Sure to do more study on this. Thank you. Laxmi --- Mike Trotman [EMAIL PROTECTED] wrote: This is not a solution - but a recommendation. If you output your Excel files in the XML format - then you can specify whatever you like (excluding charts). A simple way to determine what XML you need is to create a test Excel file 1st and then save it as XML and paramterise it. You can set Page size, document headers, footers, hide gridlines, define styles - anything you want. There is a Perl module (Spreadsheet::WriteExcelXML) which I use for this - rather than writing the XML myself. But the Excel XML is reasonably simple. I'm afraid I don't know if there are any corresponding Java utilities. HTH Mike U K Laxmi wrote: 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, -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Discover Yahoo! Get on-the-go sports scores, stock quotes, news and more. Check it out! http://discover.yahoo.com/mobile.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Free reporting s/w that works with apache+tomcat
Thanks for the info. I will read on this. --- Mike Curwen [EMAIL PROTECTED] 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. === message truncated === __ 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]
Re: Free reporting s/w that works with apache+tomcat
Guess, this is more suiting to my problem. Thanks for the information. Laxmi --- Joe Plautz [EMAIL PROTECTED] wrote: 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 === message truncated === Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Free reporting s/w that works with apache+tomcat
use jasper reports with ireports ( GUI ) for jasper ... very nice :o) - Original Message - From: U K Laxmi [EMAIL PROTECTED] To: Tomcat Users List tomcat-user@jakarta.apache.org Sent: Wednesday, May 11, 2005 3:47 AM Subject: Re: Free reporting s/w that works with apache+tomcat Guess, this is more suiting to my problem. Thanks for the information. Laxmi --- Joe Plautz [EMAIL PROTECTED] wrote: 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 === message truncated === Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail
