Forum Discussion

LolaVeci's avatar
LolaVeci
Regular Visitor
1 year ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 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.

    1. Right-click on the column header ,Click Expression.
    2. Update the expression to enclose the header text in double quotes
      • Repeat this step for all column headers.
    3. Right-click on each data field in the Tablix (one column at a time).
    4. Click Expression.
    5. 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.


    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!



Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi LolaVeci ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your answer and accept it as answer. It would be greatly appreciated by others in the community who may have the same question.

Thank you for being a part of the Microsoft Fabric Community Forum!