ssrs 2005 export to csv issue
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.
July 13th, 2011 5:07pm
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
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2011 5:11pm
Hi,
Yes, the report preview on BIDS and Report Server looks good
I have 2 columns.
Thanks.
July 13th, 2011 5:25pm
Hi Again,
Can you try exporting to Excel or pdf ( I mean other formats)?
Does it happens the same?
Thanks
KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2011 5:36pm
Hi,
In Excel and PDF, it does not happen. Looks good in excel and pdf.
July 13th, 2011 5:57pm