Need Help its Urgent....

[ravi_sati]

HI All,

 

I am using jasperserver 3.5.1. Created a report with 5 columns only.  When i generated the report in csv format its gives me out as pasted below.  

Output:

AREA NAME,BLEED DAY,COIN IN DAY,CANCEL CREDIT JP LTD,CANCEL CREDIT JP MTD
AREA 10,0.00,6.30,"21,300.00","21,300.00"
AREA 10,0.00,0.00,"23,561.00","2,261.00"
,,,,

 

Issues

1) double values are enclosed in " "  e.g "21,300.00". How can i get 21300.00 as output.

2) last line is coming only with commas.

3) It has header

 

Output needed

AREA 10,       0.00,   6.30,    21300.00,   21300.00
AREA 10,       0.00,   0.00,    23561.00 ,  2,261.00

 

Please any one knows , let me know, although i made pattern "###0.00"  in jrxml to get expected output, but no use.

Regards,

Ravi Dutt
 

[nchirr]

Ravi,

Although of not much of direct help... check out the following links for some related discussion/information:

http://www.raj2u.net/jasperserver-quick-how-to.html check out section B

http://jasperforge.org/website/jasperreportswebsite/trunk/faq.html?group_id=252#FAQ28 look for the question

How can I suppress page headers and footers when exporting to XLS? - There in there is a note about extrapolating all of the excel parameters to CSV too.

Please confirm if how you have resolved your problem.

Thanks,

Nagesh