Click here to Skip to main content
Click here to Skip to main content
Go to top

Localization (Globalization) of RDLC reports in ASP.NET applications

, 12 Sep 2008
Rate this:
Please Sign up or sign in to vote.
Localization of the RDLC reports in the ASP.NET applications

Introduction

If you need to display an RDLC report in one of several different languages, you need to create a localized version of the report for each language because RDLC reports do not support localization at the moment. However, that is complex and time-consuming, so it would be useful to localize the RDC reports similar to the way .NET handles localization normally.

Solution

The reports that you create for ReportViewer controls (.RDLC files) are XML files containing the definition of the report, so the procedure of localization doesn't look too difficult:

  1. Load the RDLC file using the Load method of the XMLDocument class.
  2. Go through the nodes of the XML document and localize the value of the Value property of the static elements of the report.
  3. Load the updated RDLC document into the LocalReport object using the LoadReportDefinition method.

To specify a resource key used for localization of the text of static elements, we can use a property named ValueLocID - the localization identifier associated with the Value property. I have not found any information about this property in any of the MSDN documentations or the RDL specification, and looks that this property is not used by the ReportViewer control in any way, so I hope that it is safe enough to use this property to specify a resource key for the localized text. Similarly, we can use the ToolTipLocID and LabelLocID properties for the localization of the ToolTip and Label properties.

Code

private void LocalizeReport(LocalReport report)
{
    // Load RDLC file. 
    XmlDocument doc = new XmlDocument();
    try
    {
        doc.Load(Server.MapPath(ResolveUrl(report.ReportPath)));
    }
    catch (XmlException)
    {
        // TIP: If your web site was published with the updatable option switched off
        // you must copy your reports to the target location manually
        return;
    }
    // Create an XmlNamespaceManager to resolve the default namespace.
    XmlNamespaceManager nsmgr = new XmlNamespaceManager(doc.NameTable);
    nsmgr.AddNamespace("nm", "http://schemas.microsoft.com/" + 
                       "sqlserver/reporting/2005/01/reportdefinition");
    nsmgr.AddNamespace("rd", "http://schemas.microsoft.com/" + 
                       "SQLServer/reporting/reportdesigner");
    //path to the local resource object
    string resourcePath = Path.Combine(ResolveUrl("."), 
                          Path.GetFileName(report.ReportPath));
    //Go through the nodes of XML document and localize
    //the text of nodes Value, ToolTip, Label. 
    foreach (string nodeName in new String[] { "Value", 
             "ToolTip", "Label" })
    {
        foreach (XmlNode node in doc.DocumentElement.SelectNodes(
                 String.Format("//nm:{0}[@rd:LocID]", nodeName), nsmgr))
        {
            String nodeValue = node.InnerText;
            if (String.IsNullOrEmpty(nodeValue) || !nodeValue.StartsWith("="))
            {
                try
                {
                    String localizedValue = (string)HttpContext.GetLocalResourceObject(
                      resourcePath, node.Attributes["rd:LocID"].Value);
                    if (!String.IsNullOrEmpty(localizedValue))
                    {
                        node.InnerText = localizedValue;
                    }
                }
                catch (InvalidCastException)
                {
                    // if the specified resource is not a String
                }
            }
        }
    }
    report.ReportPath = String.Empty;
    //Load the updated RDLC document into LocalReport object.
    using (StringReader rdlcOutputStream = new StringReader(doc.DocumentElement.OuterXml))
    {
        report.LoadReportDefinition(rdlcOutputStream);
        // TIP: If the loaded report definition contains any
        // subreports, you must call LoadSubreportDefinition
    }
}

An example of using of LocalizeReport function is shown below:

protected void Page_Load(object sender, EventArgs e)
{
    //...
    ReportViewer reportViewer = new ReportViewer();
    reportViewer.LocalReport.ReportPath = "App_Data/Reports/Report.rdlc";
    // you must run the LocalizeReport function before
    // setting parameters or data sources to the report
    LocalizeReport(reportViewer.LocalReport);
    // set parameters
    reportViewer.LocalReport.SetParameters(...);
    // set datasources
    reportViewer.LocalReport.DataSources.Add(...)
    //...
    form1.Controls.Add(reportViewer);
}

Step-by-Step Instructions

res1.JPG

  1. Create the App_LocalResources folder.
  2. Create a resx file named after your report for each language you want to support (e.g., for a report file named Report.rdlc, you would create a Report.rdlc.resx for the default language, and Report.rdlc.es.resx for Spanish). Always have a default language resx file.
  3. Add whatever strings you need to the resx file.
  4. In your RDLC, enter the string names from the resx file as the value of the property of ValueLocID (e.g., for the resource string Hello, set the value of property ValueLocID of textboxHello to Hello).
  5. Call the LocalizeReport function. Note that you must run the LocalizeReport function before setting parameters or data sources to the report; otherwise, it will not work.

References

This article is partly based on the example created by Joe Jone.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Alexander Vologin

United States United States
No Biography provided

Comments and Discussions

 
GeneralBest Localization Plug-in for Visual Studio. PinmemberAlexander Nesterenko17-Dec-08 21:36 
GeneralSubReport problem Pinmembergalodoido15-Sep-08 5:06 
AnswerRe: SubReport problem Pinmemberczeshirecat27-May-09 8:24 
GeneralRe: SubReport problem Pinmemberandrea_scurci22-Mar-10 0:47 
GeneralPrecompiled web PinmemberMember 411834010-Sep-08 23:21 
GeneralRe: Precompiled web PinmemberAlexander Vologin11-Sep-08 10:03 
GeneralRe: Precompiled web PinmemberMember 411834011-Sep-08 10:34 
GeneralRe: Precompiled web PinmemberAlexander Vologin12-Sep-08 7:00 
GeneralRe: Precompiled web PinmemberMember 411834015-Sep-08 4:26 
GeneralRe: Precompiled web PinmemberAlexander Vologin22-Sep-08 8:08 
GeneralExecution problem : System.InvalidOperationException Pinmemberchabouni8-Sep-08 3:37 
GeneralRe: Execution problem : System.InvalidOperationException PinmemberAlexander Vologin11-Sep-08 10:01 
GeneralRe: Execution problem : System.InvalidOperationException PinmemberAlexander Vologin12-Sep-08 7:00 
GeneralExcellent work, I've used it on a win app project Pinmemberandycted3-May-08 1:07 
GeneralRe: Excellent work, I've used it on a win app project PinmemberAntonio David Gonzalez13-Nov-08 22:32 
GeneralRe: Excellent work, I've used it on a win app project [modified] Pinmemberandycted14-Nov-08 8:21 
GeneralRe: Excellent work, I've used it on a win app project [modified] PinmemberJeffrey Murdock28-Jun-09 0:48 
GeneralRDLC and reporting services PinmemberMember #348389122-Jan-07 23:05 
GeneralRe: RDLC and reporting services PinmemberAlexander Vologin23-Jan-07 6:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140926.1 | Last Updated 12 Sep 2008
Article Copyright 2006 by Alexander Vologin
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid