Thanks Joe for replysing, Yes of course it's CVS option. problem is when i export to cvs my description value (if it is multiple lines with '\n') break into multiple rows. Can you please share how you avoid such situation. Thanks Regards Manish
_____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, January 19, 2009 8:05 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Search data export to xls ** What do you mean exported to xls??? There is only a csv option and I didn't have any problems with using the csv option except that leading 0's get truncated if you manipulate the file later using Excel and as a workaround I use Access to do that. Joe _____ From: Manish SINGLA <manish.sin...@st.com> To: arslist@ARSLIST.ORG Sent: Monday, January 19, 2009 7:40:13 AM Subject: Remedy Search data export to xls Hello List, There is issue of description field, which get copied in multiple rows when exported to xls, through search result reporting. Please note when we perform following: 1. Search field value based tickets on "Helpdesk" table 2. Run report on search results 3. Try exporting data to xls When data get exported to xls, "\n" there in "Description" field breaks "description" field value to multiple row. I need a solution through which I can export text fields like "Description" to single cell of xls. Thanks Regards Manish __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"