Hello, I am exporting a report from SSRS 2005 to CSV format. I have set the device info Encoding to ASCII. I have two fields ord and type and a total count field at the end. When I export to CSV the file looks like this: textbox4 textbox25 textbox10 order type ord typ Total: 17 288744 IM ord typ Total: 17 288724 MT ord typ Total: 17 288557 MT ord typ Total: 17 280307 CA ord typ Total: 17 288722 MS ord typ Total: 17 288023 IN ord typ Total: 17 279791 CU ord typ Total: 17 288699 DP ord typ Total: 17 288717 MT ord typ Total: 17 287994 TR ord typ Total: 17 258522 IN ord typ Total: 17 288752 MT ord typ Total: 17 288383 MT ord typ Total: 17 287081 CA ord typ Total: 17 287986 CA ord typ Total: 17 288620 EF ord typ Total: 17 288719 MT But the file should look like this: order type 288744 IM 288724 MT 288557 MT 280307 CA 288722 MS 288023 IN 279791 CU 288699 DP 288717 MT 287994 TR 258522 IN 288752 MT 288383 MT 287081 CA 287986 CA 288620 EF 288719 MT TOTAL: 17 How can I eliminate the unwanted/unnecessary fields??? Setting the device info header to no-header did not solve it. Please help! Thanks.

Hi mexl, Does the report preview on BIDS and report preview on Report Server (before exporting) looks good to you? How many columns you have when you execute the report (before exporting to any of the file)? Please let us know your feedback. Thanks KumarKG, MCTS

Hi, Yes, the report preview on BIDS and Report Server looks good I have 2 columns. Thanks.

Hi Again, Can you try exporting to Excel or pdf ( I mean other formats)? Does it happens the same? Thanks KumarKG, MCTS

Hi, In Excel and PDF, it does not happen. Looks good in excel and pdf.