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!



LolaVeci's avatar
LolaVeci
Regular Visitor
1 year ago

If I put No Output, it does not show me the header of the report and if I put Output, it repeats the header. I need it to be displayed like this in Excel:

In Excel it is displayed like this:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi LolaVeci ,
    Thank you for the confirmation.

    1.Modify expressions for both headers and data fields using below expression:
    = """" & Fields!YourField.Value & """"

    2.Right-click each individual data column except header row.

    • Click Properties → Find DataElementOutput.
    • Set DataElementOutput = NoOutput
    • Do NOT set NoOutput for the entire header row. This would remove the headers completely.

    3.Run the report in Report Builder.
    Click Export ,then select csv to exprot the file.
    Attaching the output screenshot for your reference


    If this post 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 valued member of the Microsoft Fabric Community Forum!