How to Format Currency as Indian Rupees (₹) in SSRS Reports

If you’re designing SSRS (SQL Server Reporting Services) reports and want to show monetary values in Indian Rupees (₹), it’s important to apply correct formatting. Here are two simple ways to do this:


🔹 Method 1: Format with Expression & Culture Code (Recommended)

  1. Click on the cell where you want to show the currency (e.g., [List_Price]).
  2. Right-click → Expression…
  3. Use the following VB.NET expression to format as INR:
=Format(CDec(Fields!List_Price.Value), "C2", New System.Globalization.CultureInfo("en-IN"))

This ensures the value is:

  • Formatted to two decimal places (e.g., ₹1,234.50)
  • Using en-IN culture for Indian currency and number grouping

Note: If your field is already decimal/float type, you can skip CDec().


🔹 Method 2: Format Using Text Box Properties

Instead of writing an expression, you can use the built-in SSRS UI:

  1. Select the cell (e.g., [List_Price])
  2. Right-click → Text Box Properties
  3. Go to the Number tab → Choose Currency
  4. Set:
    • Decimal places: 2
    • Symbol: ₹ English (India)
  5. Click OK
SSRS Currency Formatting Text Box Properties

That’s it! Now when you preview your report, it will show values like:

₹1,234.00

⚠️ Common Issue: Format Shows as (C hi-IN)

If you’re seeing text like (C hi-IN) in your report output, it means you entered the format string incorrectly (as literal text).

To fix:

  • In Properties → Format, use C2 (not ("C", hi-IN))
  • Set the Language property of the text box (or report) to en-IN or hi-IN
Fixing C hi-IN in SSRS

✅ Final Output Example

Your final SSRS report should now show values correctly like:

₹12,345.00

with proper formatting for Indian currency, digit grouping, and negative values.


🧠 Pro Tip

If you want to set currency formatting globally in your report:

  1. Click outside the report area → Right-click → Report Properties
  2. Set Language to en-IN or hi-IN

💬 Have questions?

Leave a comment below or connect with us for more SSRS tips.

Share on :

Social Share

Recent Post

© 2024 All rights reserved by Go1digital.com