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 ,
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 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.