[jasperreports-questions] Problem with single page excel Report

2008-01-22 Thread SomunNabble

Hi Everyone,
I have a report that needs to be exported to xls format in a single page.
Through iReport, I'm able to generate a single page continuous xls
report(with no empty lines in-between). I have two problems with this
report.
Pbm 1:
First problem is that the same report comes bad when generated through the
application. Many empty lines appear randomly after some set of rows
throughout the report. Infact the number of empty lines increases as we go
down the report. Please give me some suggestions for this issue.

Pbm 2:
We want to be able to have exactly the same number of rows as in the table
in the generated report. Currently some extra 30 lines appear in the report
due to the over flow of text.
Please note that for some column of  a row, the data is over 100 lines(when 
put in a doc file).

Note:
I have set the foll. parameters in the code:
1. JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE
2. 
JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
Boolean.TRUE

Also, I have enabled the  'stretch with over-flow' property of the Text
fields in iReport. I have attached the genereted excel report for your
reference.

I feel that both the problems have the same cause ie text over flow. If
there is way so that the text of a column, does not over flow to the next
row, this issue can be resolved. I looked in to the previous forum
questions, but still trying to fiqure out the solution.


Thank you very much for your time!

-Somu
http://www.nabble.com/file/p15009963/report.xls report.xls 
-- 
View this message in context: 
http://www.nabble.com/Problem-with-single-page-excel-Report-tp15009963p15009963.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions


Re: [jasperreports-questions] Problem with single page excel Report

2008-01-22 Thread SomunNabble

Hi All,
The issue got resolved by using the latest version of jasperreport jar
file.(jasperreports-2.0.4.jar).
We were using a little older one(jasperreports-2.0.0.jar).

Thanks,
Somu




SomunNabble wrote:
> 
> Hi Everyone,
> I have a report that needs to be exported to xls format in a single page.
> Through iReport, I'm able to generate a single page continuous xls
> report(with no empty lines in-between). I have two problems with this
> report.
> Pbm 1:
> First problem is that the same report comes bad when generated through the
> application. Many empty lines appear randomly after some set of rows
> throughout the report. Infact the number of empty lines increases as we go
> down the report. Please give me some suggestions for this issue.
> 
> Pbm 2:
> We want to be able to have exactly the same number of rows as in the table
> in the generated report. Currently some extra 30 lines appear in the
> report due to the over flow of text.
> Please note that for some column of  a row, the data is over 100
> lines(when  put in a doc file).
> 
> Note:
> I have set the foll. parameters in the code:
> 1. JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE
> 2. 
> JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
> Boolean.TRUE
> 
> Also, I have enabled the  'stretch with over-flow' property of the Text
> fields in iReport. I have attached the genereted excel report for your
> reference.
> 
> I feel that both the problems have the same cause ie text over flow. If
> there is way so that the text of a column, does not over flow to the next
> row, this issue can be resolved. I looked in to the previous forum
> questions, but still trying to fiqure out the solution.
> 
> 
> Thank you very much for your time!
> 
> -Somu
>  http://www.nabble.com/file/p15009963/report.xls report.xls 
> 

-- 
View this message in context: 
http://www.nabble.com/Problem-with-single-page-excel-Report-tp15009963p15032615.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions