jagadeshl Posted September 23, 2006 Share Posted September 23, 2006 Hi alli has generated CSV Report using jasper.when its has been generated in not as the proper format.when i remove the header and tile i am able to get proper format.If i include header and title ,CSV exported report with extra commas. Thnaks in Advance jagadesh Link to comment Share on other sites More sharing options...
rsilverns.sympatico.ca Posted September 25, 2006 Share Posted September 25, 2006 The CSV exporter logic is pretty strict about how you can place the fields in the report to have them properly interpreted when exported in CSV format. For my reports I try to use all fields with a constant height/width and make sure they are touching each other 1 by 1. Page headers and footers are not a great idea for CSV export format. Review http://jasperforge.org/sf/wiki/do/viewPage/projects.jasperreports/wiki/FAQ9 for more info on best practices for CSV exporting. Thx,Rob Link to comment Share on other sites More sharing options...
jagadeshl Posted September 25, 2006 Author Share Posted September 25, 2006 ya. i am designed the report in the such way only.i got the problem while i am added title and page header Link to comment Share on other sites More sharing options...
rsilverns.sympatico.ca Posted September 25, 2006 Share Posted September 25, 2006 Is it the title/page header that is throwing off the CSV algorithm is what I was meaning by my post. So if you have .... [field1,field2,field3,field4,field5] without any header info.. but then you insert a title at the top of the page, you have.... [title,,,,][field1,field2,field3,field4,field5] Is this correct? Then if so, you need to remove the title header etc. as per the FAQ posting concerning non-essential data. Link to comment Share on other sites More sharing options...
jagadeshl Posted September 25, 2006 Author Share Posted September 25, 2006 yes excately the same.here by i attached the generate CSV report,when the report which include header.if i remove the header its generating properly thanks Link to comment Share on other sites More sharing options...
jagadeshl Posted September 25, 2006 Author Share Posted September 25, 2006 sorry not able to attachits look this this Internal ID Report,,,,,Report Run,: 25 Sep 2006,,,,Report Generated By :,,,,,Account Name,,, Account #,, User IDUILFORD SPECIALTY GROUP INC,,, 164432585,, EXTERNALLUFTHANSA AIRLINES,,, 052587701,, EXTERNALOLF & CO,,, 002872895,, EXTERNALCREEDLE JONES & ALGA PC,,, 164421705,, EXTERNALGWINNETT COUNTY BOARD OF,,, 043361100,, EXTERNAL Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now