How to show a Unicode character in RTC report ?

makara
makara Member Posts: 25
edited 2013-01-15 in NAV Three Tier
I added a textbox in RDLC report and set value of it to unicode character. but when I run report, I got only ????? sign.
Please help me to solve this problem. I wish to see the unicode character in report.

Any suggestion ?

Comments

  • clausl
    clausl Member Posts: 455
    What is the value in the dataset? Select "About this Report" to see the dataset.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • makara
    makara Member Posts: 25
    sorry I couldn't find any Dataset value. I go to Help => About this report
  • clausl
    clausl Member Posts: 455
    1. Run your report.
    2. On Request Page, select "Help / About This Page"
    3. Close the "About This Page". You have now enabled the possibility to see the dataset in your report
    4. Select "Preview"
    5. In Report Viewer, select "Help / About This Report" This opens page where you can see the dataset sent to Report Viewer from NAV.

    Now go to the column where your value are for your textbox. I am interested in seeing if the value is wrong in the dataset.

    We have a customer in South Korea where reports are showing the unicode characters fine. They are running NAV 2013. I assume you are also trying to get this to work in NAV 2013?

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • makara
    makara Member Posts: 25
    This is a dataset value (Picture)

    but I am actually typing unicode direct to textbox value.
    and here is how I do it. pls see the link to download below file.

    http://www.mediafire.com/view/?l9uh7urcn12al3i
  • clausl
    clausl Member Posts: 455
    The text looks OK in the dataset, correct me if I'm wrong. If correct in dataset we can conclude that the issue is in Report Viewer 2010 and not an NAV issue.

    I have 2 suggestions:

    1. Uninstall Report Viewer 2010 from your computer and then install the Chinese version of the Report Viewer 2010. This can be found here: http://www.microsoft.com/en-us/download/details.aspx?id=6442.

    2. If #1 does not solve the issue, try to save your Dataset.xml and Report.rdlc as I have described in my blog, and run the report offline. Several times I have seen some slight differences between the report being rendered in Visual Studio 2010 and Report Viewer 2010. Also it would be nice if you share these two files so I can run the report and see if I can repro. If it runs fine in Visual Studio 2010 but not in Report Viewer 2010, you have found a bug in Report Viewer 2010.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • makara
    makara Member Posts: 25
    Thx Claus, I followed your instruction ... but the result still the same. Unicode characters could show If I retrieve it from DB.

    Some Suggestions said : I need to add new field from table and then retrieve to show in the report.
    other said : I might need to use Image for that caption.
    Another said : I need to use Label in NAV (View => Labels) and add those label to report.

    Anyways, Thx you for your answer. I will consider on one of them (above)
  • esbenk
    esbenk Member, Microsoft Employee Posts: 1
    The problem is that you are adding Unicode texts to what is essentially metadata. The RDLC is a part of the object definition (Metadata) and that is still not Unicode enabled to NAV 2013.

    When the RDLC is saved from Visual Studio into NAV it is persisted using the System Locale (language) for non-unicode programs. If the RDLC contains characters that doesn't map to this locale they will be converted into question marks. You can verify this by saving the report and reopening the layout - now the Unicode text is already converted to question marks.

    You could put the captions in a table and add them to the dataset.

    Another solution is to embed the text as "\u0066\u0068...." in the RDLC and assign the text to the label in a script block. I'm not an expert on the actual RDLC syntax here - ClausL is probably more skilled in that area.

    /esben

Categories