Export to WorkSheet

[ldionne]

Hi,__I^m trying to export a report in Excel 2002 SP2 but all the accents are not working, EX: LA SABLI╚RE would be LA SABLIÈRE. The code page of the DBF files used in the report is 1252 and DBCHARS is set to ANSI in Rrw.srt____But, when i check the print preview, all accents are presents.____Thanks,____Luc Dionne__

[kfleming]

Can you export to text and then read that data in Excel?____Kathleen__R&R Support

[ldionne]

Your solution work fine but it does^nt solve my problem !____We have to export the report in worksheet and not in the text file. Your solution is harder for a inexperienced user.

[Sue_(Guest)]

What I have done is to put a riparam field (could be a parameter field) in the report that is a comma if they are going to export and blank if they are running the report to the screen. Put in as many as you need. Then when exporting I export as a text file but add the .csv extension so the system thinks it is an excel file. You get all the bands on the report not just a single one. Not sure if that helps you or not.