S V on 12 Jan 2022 18:11:00
Paginated Report - Export to CSV with out quotes
Allow settings or a way to export the paginated report without quotes.
Reproduce steps:
- This is my requirement, may be different or not suite for all
- A report with only one table and one column
- Export as csv
- By default
- it will export as without (double) quotes when the data does NOT have comma i.e., in the one column
- it will export as with (double) quotes when the data does comma i.e., in the one column
- If the data in a table column has a comma or other special characters, csv download is adding the double quotes. This is default behavior. I do NOT want double quotes.
It is a variation of export of the CSV
On-premise SSRS/PBIRS servers can be customized
- Ref: By design
- https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-a-csv-file-report-builder-and-ssrs?view=sql-server-ver15
- Ref: Customize
- https://docs.microsoft.com/en-us/sql/reporting-services/customize-rendering-extension-parameters-in-rsreportserver-config?view=sql-server-ver15
- https://docs.microsoft.com/en-us/sql/reporting-services/csv-device-information-settings?view=sql-server-ver15
- Ref: Similar issue
- https://stackoverflow.com/questions/59667551/ssrs-adding-extra-characters-when-exporting-to-csv
Thanks
- Comments (1)
RE: Paginated Report - Export to CSV with out quotes
Most other report tools that I have worked with allow the user to specify the qualifier string. What I don't understand is if the qualifier string is " for a text value, why does it not add it in for all text values? It either shows nothing when exporting to a CSV file, or it qualifies the " with ". That makes absolutely no sense. Why would you quality just the " and not the rest of the text in the field?