SSRS Format currency

Philippe Desmarez 0 Reputation points
2024-07-17T08:34:49.4933333+00:00

Hello,

In MS Report Builder, I try to get columns showing currency formatted like this 8.959.930,44€

When I configure the cell to "Currency", the result is : 8,959,930.44€

I tried to format te cell with this =Format(Sum(Fields!PRIXVENTE.Value), "#.###,00") but the result is : 8959930.44000

Can someone help me ?

Thank you,

Philippe

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,910 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,111 Reputation points
    2024-07-18T05:18:25.6666667+00:00

    Hi @Philippe Desmarez,

    What the original data looks like? If possible you may provide the sample data and tell us the expected result.

    Also you may try below expression to see if it works.

    =FormatNumber((CDbl(Fields!PRIXVENTE.Value)),2)

    If it does not work, please share the sample data.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.