I'm just Exporting SSRS report to CSV format,where i'm getting extra commas at end of each record as
CSV Format:
274,98027,Issaquah
274,502097814,M
43849,SO43849,
44082,SO44082,
44508,SO44508,
44532,SO44532,
The extra comma appearing at end of rows in "CSV format",for the rows which has NULL values at end in the "Report"
Report Format:
274 98027 Issaquah
274 502097814 M
43849 SO43849 NULL
44082 SO44082 NULL
44508 SO44508 NULL
44532 SO44532 NULL
I have already hided these null columns in report.but i'm getting that comma at end of each row.
Is there any solution to hide extra comma in CSV format?
plz suggest solution for this.
Thanks in advance..