Forum Discussion
LolaVeci
1 year agoRegular Visitor
Report Builder export to csv double quotes
We need to use Report Builder to reproduce a custom format for a CSV that was generated with another tool.
The file's peculiarities are mainly two:
1. The values โโof the headers and the data have t...
- Anonymous1 year ago
Hi LolaVeci ,
Thank you for your patience! I truly appreciate your time and effort in clarifying your requirements. Your detailed explanation has provided valuable insight.- Right-click on the column header ,Click Expression.
- Update the expression to enclose the header text in double quotes
- Repeat this step for all column headers.
- Right-click on each data field in the Tablix (one column at a time).
- Click Expression.
- Use the following format to enclose the data in double quotes:
- Replace the existing value with:
= """" & Fields!YourColumnName.Value & """" - Repeat this for all data columns(except headers) in the table.
- Replace the existing value with:
Please refer the screenshot for more understanding.
This is the exported csv output.
I hope this solution works for you.If this helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you for being a part of the Microsoft Fabric Community Forum!
LolaVeci
1 year agoRegular Visitor
I need an export to csv whose result is (Headers and data in quotes, and headers with names containing spaces๐