This discussion is archived
10 Replies Latest reply: May 13, 2013 6:48 AM by M.R. RSS

French characters not showing on a web report

M.R. Newbie
Currently Being Moderated
Hello,

Using Oracle 11g R2. On a web report I created, the French characters are not showing (like e with an accent, etc)
I tried both NVARCHAR2 and VARCHAR2 data types.

The current language settings are the following:

NLS_LANGUAGE: AMERICAN
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_TERRITORY: AMERICA
NLS_CHARACTERSET:     WE8MSWIN1252

NLS_RDBMS_VERSION     11.2.0.2.0

Are these setting supporting French language?
If not, then please let me know what parameter above need to be changed in order to include French language support?

Regards,
M.R.
  • 1. Re: French characters not showing on a web report
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    The database settings are OK for French characters. If want us to find the cause of your problem, you need to describe the generation of the Web report, especially the used technologies/tools in detail. You should also precisely define what you mean by "are not showing". Are they missing entirely from the screen?

    -- Sergiusz
  • 2. Re: French characters not showing on a web report
    M.R. Newbie
    Currently Being Moderated
    Hello Sergiusz,

    Thank you for your help.
    I created a web report using Visual Studio 2010. The report is pulling the information from the Oracle database and has been deployed on a web site.
    In the web browser (Internet Explorer), the French characters on the report are just missing from fields defined as NVARCHAR2 and showing as a spaces for fields defined as VARCHAR2.
    I checked the browser and it displays correctly French characters on different sites.

    Additional information:
    1. Using the latest Oracle Data Access components for VB.Net ver. 11.2.0.3.20 release 5
    2. Development on Windows Server 2008

    Thank you,
    M.R.
  • 3. Re: French characters not showing on a web report
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    Could you check the encoding of the page that is displayed and also click on View Source to see what the HTML page contains in place of the French letters? Let's concentrate on VARCHAR2 and forget NVARCHAR2.


    -- Sergiusz
  • 4. Re: French characters not showing on a web report
    M.R. Newbie
    Currently Being Moderated
    Encoding is Unicode (UTF-8) but I also tried with 'Western European': same problem, no special characters are displayed.
    Unfortunately, I cannot check the incorrect words via 'View Source' in Internet Explorer. The reason is that I browse the Oracle database through Microsoft Report Viewer that is designed by Microsoft in a way that doesn't allow you to view the database content.
    When I open 'View Source' in IE, I can only see strings of random characters, it is probably some encryption...

    Thank you,
    M.R.

    Note: I have the same problem when I open the Oracle tables in Ms Access through ODBC. Instead of French characters I can only see question marks.
  • 5. Re: French characters not showing on a web report
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    Please, run
    SELECT DUMP(your_column,1016) FROM your_table WHERE some_condition
    on some of the values to be displayed and let me know the result. Also, tell me what exact "random characters" you see. Paste the HTML fragment here, if possible.


    -- Sergiusz
  • 6. Re: French characters not showing on a web report
    M.R. Newbie
    Currently Being Moderated
    The SQL statement returns the following, on a value with a missing "E" with accent:
    Typ=1 Len=18 CharacterSet=WE8MSWIN1252: 55,6f,66,4f,20,90,72,69,63,6b,61,20,4c,61,76,6f,69,65

    If I 'View Source":

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
    <HTML>
    <HEAD lang="en-US">
         <META HTTP-EQUIV="X-UA-Compatible" CONTENT="IE=5">
         <script language="JScript" type="text/Javascript" src="/Reports/js/ReportingServices.js"></script>

         <TITLE>Customers - Report Manager</TITLE>
         <link href="/Reports/styles/ReportingServices.css"type="text/css" rel="stylesheet">
    <link href="/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&amp;Version=2011.110.3128.00" rel="stylesheet" type="text/css" />     <META Name="Report Server" CONTENT="http://localhost:80/ReportServer">
    </HEAD>
    <BODY style="margin:0px;" class="msrs-normal" onload=""><form name="ui_form" method="POST" action="Report.aspx?ItemPath=%2fRBS+Reports%2fCustomers" id="ui_form" enctype="multipart/form-data">
    <div>
    <input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
    <input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
    <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUENTM4MQ8WAh4RUGFnZVZpZXdTdGF0ZVRpbWUoKVlTeXN0ZW0uSW50NjQsIG1zY29ybGliLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjc3YTVjNTYxOTM0ZTA4ORI2MzUwMzcxOTc4MDMyMTkyOTIWAgIBD2QWAgIDD2QWAmYPZBYCAgEPZBYCZg9kFgZmDxYCHgdWaXNpYmxlaGQCAQ9kFgJmD2QWAmYPZBYCZg8WCB4GdmFsaWduBQN0b3AeBmhlaWdodAUCMzAeB2NvbHNwYW4FATQeBWNsYXNzBRRtc3JzLXZhbGlkYXRpb25lcnJvcmQCAg9kFgICAQ9kFgJmD2QWAmYPZBYCZg9kFgJmD2QWAmYPZBYCZg9kFgRmDxYCHwFoZAIBD2QWAmYPZBYCZg8WAh8DBQQxMDAlFgQCAQ9kFgQCAQ8WAh4FVmFsdWVkZAIDD2QWAmYPZBYCZg8WAh8GZGQCAg8UKwAFDxYSHhZTaG93QXRvbURhdGFGZWVkQnV0dG9uZx4OUHJvY2Vzc2luZ01vZGULKZIBTWljcm9zb2Z0LlJlcG9ydGluZy5XZWJGb3Jtcy5Qcm9jZXNzaW5nTW9kZSwgUmVwb3J0aW5nU2VydmljZXNXZWJVc2VySW50ZXJmYWNlLCBWZXJzaW9uPTExLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPTg5ODQ1ZGNkODA4MGNjOTEBHhlJbnRlcmFjdGl2aXR5UG9zdEJhY2tNb2RlCymdAU1pY3Jvc29mdC5SZXBvcnRpbmcuV2ViRm9ybXMuSW50ZXJhY3Rpdml0eVBvc3RCYWNrTW9kZSwgUmVwb3J0aW5nU2VydmljZXNXZWJVc2VySW50ZXJmYWNlLCBWZXJzaW9uPTExLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPTg5ODQ1ZGNkODA4MGNjOTECHgxTY3JvbGxUYXJnZXRkHgVXaWR0aBsAAAAAAABZQAcAAAAeDlNob3dCYWNrQnV0dG9uaB4OUmVuZGVyaW5nU3RhdGULKZgBTWljcm9zb2Z0LlJlcG9ydGluZy5XZWJGb3Jtcy5SZXBvcnRSZW5kZXJpbmdTdGF0ZSwgUmVwb3J0aW5nU2VydmljZXNXZWJVc2VySW50ZXJmYWNlLCBWZXJzaW9uPTExLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPTg5ODQ1ZGNkODA4MGNjOTEAHgZIZWlnaHQbAAAAAAAAWUAHAAAAHgRfIVNCAoADZCgpWFN5c3RlbS5HdWlkLCBtc2NvcmxpYiwgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODkkZTk0NTlmYmEtODBiMy00OWRiLTkzYzItODJkNTQyYTRiMGUxAgEUKwABFCsABGYUKwAEBRgyeGdrZ280NTRqZHprZjU1bzRwZmY1ZWUUKwEAZQIBZGQy2BQAAQAAAP////8BAAAAAAAAAAwCAAAAZVJlcG9ydGluZ1NlcnZpY2VzV2ViVXNlckludGVyZmFjZSwgVmVyc2lvbj0xMS4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj04OTg0NWRjZDgwODBjYzkxBQEAAAAxTWljcm9zb2Z0LlJlcG9ydGluZy5XZWJGb3Jtcy5EZXZpY2VJbmZvQ29sbGVjdGlvbgUAAAAaS2V5ZWRDb2xsZWN0aW9uYDIrY29tcGFyZXIWS2V5ZWRDb2xsZWN0aW9uYDIrZGljdBpLZXllZENvbGxlY3Rpb25gMitrZXlDb3VudBtLZXllZENvbGxlY3Rpb25gMit0aHJlc2hvbGQSQ29sbGVjdGlvbmAxK2l0ZW1zAwMAAAMWU3lzdGVtLk9yZGluYWxDb21wYXJlcpYCU3lzdGVtLkNvbGxlY3Rpb25zLkdlbmVyaWMuRGljdGlvbmFyeWAyW1tTeXN0ZW0uU3RyaW5nLCBtc2NvcmxpYiwgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODldLFtNaWNyb3NvZnQuUmVwb3J0aW5nLldlYkZvcm1zLkRldmljZUluZm8sIFJlcG9ydGluZ1NlcnZpY2VzV2ViVXNlckludGVyZmFjZSwgVmVyc2lvbj0xMS4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj04OTg0NWRjZDgwODBjYzkxXV0ICLMBU3lzdGVtLkNvbGxlY3Rpb25zLkdlbmVyaWMuTGlzdGAxW1tNaWNyb3NvZnQuUmVwb3J0aW5nLldlYkZvcm1zLkRldmljZUluZm8sIFJlcG9ydGluZ1NlcnZpY2VzV2ViVXNlckludGVyZmFjZSwgVmVyc2lvbj0xMS4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj04OTg0NWRjZDgwODBjYzkxXV0CAAAACQMAAAAJBAAAAAAAAAAAAAAACQUAAAAEAwAAABZTeXN0ZW0uT3JkaW5hbENvbXBhcmVyAQAAAAtfaWdub3JlQ2FzZQABAQQEAAAAlgJTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYy5EaWN0aW9uYXJ5YDJbW1N5c3RlbS5TdHJpbmcsIG1zY29ybGliLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjc3YTVjNTYxOTM0ZTA4OV0sW01pY3Jvc29mdC5SZXBvcnRpbmcuV2ViRm9ybXMuRGV2aWNlSW5mbywgUmVwb3J0aW5nU2VydmljZXNXZWJVc2VySW50ZXJmYWNlLCBWZXJzaW9uPTExLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPTg5ODQ1ZGNkODA4MGNjOTFdXQQAAAAHVmVyc2lvbghDb21wYXJlcghIYXNoU2l6ZQ1LZXlWYWx1ZVBhaXJzAAMAAwgWU3lzdGVtLk9yZGluYWxDb21wYXJlcgiaAlN5c3RlbS5Db2xsZWN0aW9ucy5HZW5lcmljLktleVZhbHVlUGFpcmAyW1tTeXN0ZW0uU3RyaW5nLCBtc2NvcmxpYiwgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODldLFtNaWNyb3NvZnQuUmVwb3J0aW5nLldlYkZvcm1zLkRldmljZUluZm8sIFJlcG9ydGluZ1NlcnZpY2VzV2ViVXNlckludGVyZmFjZSwgVmVyc2lvbj0xMS4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj04OTg0NWRjZDgwODBjYzkxXV1bXQEAAAAJAwAAAAMAAAAJBwAAAAQFAAAAswFTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYy5MaXN0YDFbW01pY3Jvc29mdC5SZXBvcnRpbmcuV2ViRm9ybXMuRGV2aWNlSW5mbywgUmVwb3J0aW5nU2VydmljZXNXZWJVc2VySW50ZXJmYWNlLCBWZXJzaW9uPTExLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPTg5ODQ1ZGNkODA4MGNjOTFdXQMAAAAGX2l0ZW1zBV9zaXplCF92ZXJzaW9uBAAAKU1pY3Jvc29mdC5SZXBvcnRpbmcuV2ViRm9ybXMuRGV2aWNlSW5mb1tdAgAAAAgICQgAAAABAAAAAQAAAAcHAAAAAAEAAAABAAAAA5gCU3lzdGVtLkNvbGxlY3Rpb25zLkdlbmVyaWMuS2V5VmFsdWVQYWlyYDJbW1N5c3RlbS5TdHJpbmcsIG1zY29ybGliLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjc3YTVjNTYxOTM0ZTA4OV0sW01pY3Jvc29mdC5SZXBvcnRpbmcuV2ViRm9ybXMuRGV2aWNlSW5mbywgUmVwb3J0aW5nU2VydmljZXNXZWJVc2VySW50ZXJmYWNlLCBWZXJzaW9uPTExLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPTg5ODQ1ZGNkODA4MGNjOTFdXQT3////mAJTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYy5LZXlWYWx1ZVBhaXJgMltbU3lzdGVtLlN0cmluZywgbXNjb3JsaWIsIFZlcnNpb249Mi4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj1iNzdhNWM1NjE5MzRlMDg5XSxbTWljcm9zb2Z0LlJlcG9ydGluZy5XZWJGb3Jtcy5EZXZpY2VJbmZvLCBSZXBvcnRpbmdTZXJ2aWNlc1dlYlVzZXJJbnRlcmZhY2UsIFZlcnNpb249MTEuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49ODk4NDVkY2Q4MDgwY2M5MV1dAgAAAANrZXkFdmFsdWUBBCdNaWNyb3NvZnQuUmVwb3J0aW5nLldlYkZvcm1zLkRldmljZUluZm8CAAAABgoAAAAaRGF0YVZpc3VhbGl6YXRpb25GaXRTaXppbmcJCwAAAAcIAAAAAAEAAAAEAAAABCdNaWNyb3NvZnQuUmVwb3J0aW5nLldlYkZvcm1zLkRldmljZUluZm8CAAAACQsAAAANAwULAAAAJ01pY3Jvc29mdC5SZXBvcnRpbmcuV2ViRm9ybXMuRGV2aWNlSW5mbwIAAAAGbV9uYW1lB21fdmFsdWUBAQIAAAAJCgAAAAYNAAAAC0FwcHJveGltYXRlCxYCAgEPZBYCZg9kFgJmD2QWDAIBDw8WAh4LSGFzQ29udHJvbHNnZBYEAgMPZBYEAgMPFgIeBE5hbWUFF2N0bDMyX2N0bDA0X2N0bDAzX2N0bDAxZAIED2QWAgIBDw8WAh4OVmFsaWRWYWx1ZUhhc2gUKVhTeXN0ZW0uQnl0ZSwgbXNjb3JsaWIsIFZlcnNpb249Mi4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj1iNzdhNWM1NjE5MzRlMDg5QANcA+QD2gOgA+QDQAMqA6MDZwPIAxUDRgNzAzkDCAO0A2kD1QN6AxsDFAP2A/8DDgM2A8YDpwM/A6oD6QNBA5kD0AO3Aw4DtQN6Ay4DAgPVA64DmQMUAzADCwNgA/oD2QMAA8cDOQNBA8ID5gNhA8ADsQMoAxUDbQP7A8UDkAPjZBYCZg8WAh8GBQEwZAIFD2QWAgIDDxYIHxEFF2N0bDMyX2N0bDA0X2N0bDA1X2N0bDAxHgZvbmxvYWQFogENCnRoaXMucmVzdWx0ZmllbGQ9JGdldCgnY3RsMzJfY3RsMDRfY3RsMDVfdHh0VmFsdWUnKTsNCnRoaXMucmVzdWx0ZnVuYz1mdW5jdGlvbihyZXN1bHRGaWVsZCl7JGdldCgnY3RsMzJfY3RsMDRfY3RsMDUnKS5jb250cm9sLk9uQ2FsZW5kYXJTZWxlY3Rpb24ocmVzdWx0RmllbGQpO30eCXNjcm9sbGluZwUCbm8eA3NyYwVSL1JlcG9ydHMvUmVzZXJ2ZWQuUmVwb3J0Vmlld2VyV2ViQ29udHJvbC5heGQ/T3BUeXBlPUNhbGVuZGFyJkxDSUQ9MTAzMyZzZWxlY3REYXRlPWQCAg9kFgICAg8WAh8GBQVmYWxzZWQCAw8PFgIfAWhkZAIFD2QWAgICDxYCHwYFBWZhbHNlZAIGD2QWAmYPZBYCZg9kFgRmDw9kFgIeBXN0eWxlBRB2aXNpYmlsaXR5Om5vbmU7ZAIDD2QWBAIBDxYCHgdFbmFibGVkaGQCBA8WAh8GBQMxMDBkAgoPZBYCAgEPFgIfBgUFRmFsc2VkGAEFHl9fQ29udHJvbHNSZXF1aXJlUG9zdEJhY2tLZXlfXxYNBSJjdGwzMiRjdGwwNCRjdGwwMyRkZERyb3BEb3duQnV0dG9uBSNjdGwzMiRjdGwwNCRjdGwwMyRkaXZEcm9wRG93biRjdGwwMAUjY3RsMzIkY3RsMDQkY3RsMDMkZGl2RHJvcERvd24kY3RsMDIFI2N0bDMyJGN0bDA0JGN0bDAzJGRpdkRyb3BEb3duJGN0bDAzBSNjdGwzMiRjdGwwNCRjdGwwMyRkaXZEcm9wRG93biRjdGwwNAUjY3RsMzIkY3RsMDQkY3RsMDMkZGl2RHJvcERvd24kY3RsMDUFI2N0bDMyJGN0bDA0JGN0bDAzJGRpdkRyb3BEb3duJGN0bDA2BSNjdGwzMiRjdGwwNCRjdGwwMyRkaXZEcm9wRG93biRjdGwwNwUjY3RsMzIkY3RsMDQkY3RsMDMkZGl2RHJvcERvd24kY3RsMDgFI2N0bDMyJGN0bDA0JGN0bDAzJGRpdkRyb3BEb3duJGN0bDA5BSJjdGwzMiRjdGwwNCRjdGwwNSRkZERyb3BEb3duQnV0dG9uBRVjdGwzMiRUb2dnbGVQYXJhbSRpbWcFD2N0bDMyJGN0bDA3JGltZ0Sz+krAXwbU45RZ256iPMe7UfKM" />
    </div>



    <script src="/Reports/WebResource.axd?d=nkJcN85pEb3ZU7-GkpfGSPHWwbbpaKw94mdJ-Ycuz8Dr1lH3N5LR6kdEeeT7tcfYd66weQ87tdi83QgFLh5UnjYYF2U1&amp;t=634655681597856420" type="text/javascript"></script>


    <script src="/Reports/ScriptResource.axd?d=NNx9x0LAEtmmhBRXIF4Fz8HSwwwVSj2jHDchwiTKGl8OjGLtqy_HIxlER1AYzDt6txUju7I2Yx1nT6nwWRIMOxlwrBNCbPSbWavw0pgxrooEwD9ng7quh_RaUuDR7Le77ZAMTIkEhOtU2A9qhw-LXaJ8xbo1&amp;t=ffffffffb868b5f4" type="text/javascript"></script>
    <script src="/Reports/ScriptResource.axd?d=oHL_SL-WoCElKiDY07uVfmCVyX77n8ddYIevD2xzJp2CWQkyawAiAbKkWphowNJfPbnetQ2ij-XIxOBXeOp-5ZQXmeryqeCj4vGV0HeN5EBmq4IMIW5v9C9iPiuiLxiM_WMM7VCrNn_p53ycjzc-L1Srg4OX8uk_Oz_P0MxrMc87MKd90&amp;t=ffffffffb868b5f4" type="text/javascript"></script>
    <script src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Resource&amp;Version=11.0.3000.0&amp;Name=ViewerScript" type="text/javascript"></script>
    <script src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Resource&amp;Version=11.0.3000.0&amp;Name=Microsoft.Reporting.WebForms.Scripts.BrowserNavigationCorrector.js" type="text/javascript"></script>
    <script src="/Reports/ScriptResource.axd?d=C6oXSN2hPYRLINf3-L5AyGkrwhSTMbfM7VLisW9OZs3-agDUVfArPtQH29xH7P_22GWkSoaBafGteJNrGyyb5R7hkYy-b8PpQ8VC0poNzzvBISjhoW_XeFCMw5PDTFgrK1H3_khFKp0slJ5m-TT3aw5mzT41&amp;t=ffffffffb868b5f4" type="text/javascript"></script><script type="text/javascript">
    //<![CDATA[
    Sys.WebForms.PageRequestManager._initialize('ctl04', document.getElementById('ui_form'));
    Sys.WebForms.PageRequestManager.getInstance()._updateControls(['tNavigationCorrector$ctl00','fctl32$ReportViewer','fctl32$DocMap','fctl32$ctl09$ReportArea'], ['NavigationCorrector'], ['ctl32$ctl09$ReportControl$ctl00'], 0);
    //]]>
    </script>
    <span><noscript><table width="100%" class="msrs-normal">
         <tr>
              <td valign="top" height="30" colspan="4" class="msrs-validationerror"><img src="/Reports/images/blank.gif" height="1" width="24" border="0" /><img src="/Reports/images/line_err1.gif" height="16" width="16" alt="Error" /><img src="/Reports/images/blank.gif" height="1" width="12" border="0" />This page might not function correctly because either your browser does not support scripts or active scripting is disabled.</td>
         </tr>
    </table>
    </noscript><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0" height="100%">
         <tr>
              <td valign="top"><div>
                   <table class="msrs-topBreadcrumb" cellpadding="0" cellspacing="0" border="0" width="100%">
                        <tr>
                             <td><span><div>
                                  <a href="/Reports/Pages/Folder.aspx">Home</a> &gt; <a href="/Reports/Pages/Folder.aspx?ItemPath=%2fRBS+Reports">RBS Reports</a> &gt; <a href="/Reports/Pages/Report.aspx?ItemPath=%2fRBS+Reports%2fCustomers&amp;SelectedTabId=PropertiesTab&amp;SelectedSubTabId=GenericPropertiesTab">Customers</a>
                             </div></span></td>
                             <td align="right"><span><a href="/Reports/Pages/Folder.aspx">Home</a> | <a href="/Reports/Pages/Subscriptions.aspx">My Subscriptions</a> | <a href="/Reports/Pages/Settings.aspx">Site Settings</a> | <a href="http://go.microsoft.com/fwlink/?LinkID=223510" target="MicrosoftReportingServicesHelp">Help</a></span></td>
                        </tr>
                   </table>

              </div></td>
         </tr>
         <tr height="100%">
              <td valign="top"><table width="100%" class="msrs-contentFrame" cellpadding="0" cellspacing="0" height="100%">
                   <tr>
                        <td valign="top" height="100%"><span><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0" height="100%">
                             <tr>
                                  <td valign="top" height="100%"><span><span id="ctl31_ctl00" style="display:none;"></span><script>
                                       
    $addHandler(window, 'beforeunload', function() {Sys.WebForms.PageRequestManager.getInstance().abortPostBack();});

    Sys.WebForms.PageRequestManager.getInstance().add_endRequest(function(sender, args) {
    if (args.get_error() !== null) {
    var label = $get('ctl31_ctl00');
    label.style.display = '';
    label.innerText = args.get_error().message;
    label.textContent = label.innerText;
    }
    });

    Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(function(sender, args) {$get('ctl31_ctl00').style.display = 'none';});

                                  </script></span><div id="NavigationCorrector" style="display:none;">
                                       <input type="hidden" name="NavigationCorrector$ScrollPosition" id="NavigationCorrector_ScrollPosition" /><input type="hidden" name="NavigationCorrector$ViewState" id="NavigationCorrector_ViewState" /><input type="hidden" name="NavigationCorrector$PageState" id="NavigationCorrector_PageState" /><div id="NavigationCorrector_ctl00">
                                            <input type="hidden" name="NavigationCorrector$NewViewState" id="NavigationCorrector_NewViewState" />
                                       </div>
                                  </div><noscript>
                                        Your browser does not support scripts or has been configured not to allow scripts.
                                  </noscript><span id="ctl32_ReportViewer"><div id="ctl32" onclick="if ($get('ctl32_ctl04') != null &amp;&amp; $get('ctl32_ctl04').control != null) $get('ctl32_ctl04').control.HideActiveDropDown();" onactivate="if ($get('ctl32_ctl04') != null &amp;&amp; $get('ctl32_ctl04').control != null) $get('ctl32_ctl04').control.HideActiveDropDown();" style="height:100%;width:100%;">
                                       <div id="ctl32_HttpHandlerMissingErrorMessage" style="border-color:Red;border-width:2px;border-style:Solid;padding:10px;display:none;overflow:auto;font-size:.85em;">
                                            <h2>
                                                 Report Viewer Configuration Error
                                            </h2><p>The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add &lt;add verb=&quot;*&quot; path=&quot;Reserved.ReportViewerWebControl.axd&quot; type = &quot;Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91&quot; /&gt; to the system.web/httpHandlers section of the web.config file, or add &lt;add name=&quot;ReportViewerWebControlHandler&quot; preCondition=&quot;integratedMode&quot; verb=&quot;*&quot; path=&quot;Reserved.ReportViewerWebControl.axd&quot; type=&quot;Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91&quot; /&gt; to the system.webServer/handlers section for Internet Information Services 7 or later.</p>
                                       </div><span id="ctl32_ctl03"><input type="hidden" name="ctl32$ctl03$ctl00" id="ctl32_ctl03_ctl00" /><input type="hidden" name="ctl32$ctl03$ctl01" id="ctl32_ctl03_ctl01" /></span><input type="hidden" name="ctl32$ctl10" id="ctl32_ctl10" /><input type="hidden" name="ctl32$ctl11" id="ctl32_ctl11" /><div id="ctl32_AsyncWait" style="background-color:White;opacity:0.7;position:absolute;display:none;filter:alpha(opacity=70);">

                                       </div><div id="ctl32_AsyncWait_Wait" class="WaitControlBackground" style="display:none;position:absolute;">
                                            <table height="100%">
                                                 <tr>
                                                      <td width="32px" height="32px"><img src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Resource&amp;Version=11.0.3000.0&amp;Name=Microsoft.Reporting.WebForms.Icons.SpinningWheel.gif" alt="Loading..." style="height:32px;width:32px;border-width:0px;" /></td><td class="WaitInfoCell"><span class="WaitText">Loading...</span><div class="CancelLinkDiv">
                                                           <a class="CancelLinkText" href="javascript:$get('ctl32_AsyncWait').control._cancelCurrentPostback();">Cancel</a>
                                                      </div></td>
                                                 </tr>
                                            </table>
                                       </div><input type="hidden" name="ctl32$AsyncWait$HiddenCancelField" id="ctl32_AsyncWait_HiddenCancelField" value="False" /><table cellpadding="0" cellspacing="0" id="ctl32_fixedTable" style="table-layout:fixed;width:100%;height:100%;">
                                            <tr class="MenuBarBkGnd">
                                                 <td style="display:none;width:25%;"></td><td style="display:none;width:6px;"></td><td style="width:100%;"></td>
                                            </tr><tr id="ParametersRowctl32">
                                                 <td colspan="3"><div id="ctl32_ctl04" style="width:100%;overflow-x:auto;overflow-y:hidden;">
                                                      <div onclick="if ($get('ctl32_ctl04') != null &amp;&amp; $get('ctl32_ctl04').control != null) $get('ctl32_ctl04').control.HideActiveDropDown();" onactivate="if ($get('ctl32_ctl04') != null &amp;&amp; $get('ctl32_ctl04').control != null) $get('ctl32_ctl04').control.HideActiveDropDown();">
                                                           <table cellpadding="0" cellspacing="0" width="100%" id="ParameterTable_ctl32_ctl04" name="ParameterTable_ctl32_ctl04" class="ParametersFrame ParamsGrid MenuBarBkGnd">
                                                                <tr>
                                                                     <td width="100%" height="100%"><table id="ParametersGridctl32_ctl04">
                                                                          <tr IsParameterRow="true">
                                                                               <td class="ParamLabelCell"><label for="ctl32_ctl04_ctl03_txtValue"><span>Status</span></label></td><td class="ParamEntryCell" style="padding-right:0px;"><div id="ctl32_ctl04_ctl03">
                                                                                    <div onactivate="event.cancelBubble=true;" style="white-space:nowrap;">
                                                                                         <input name="ctl32$ctl04$ctl03$txtValue" type="text" size="28" readonly="readonly" id="ctl32_ctl04_ctl03_txtValue" disabled="disabled" class="DisabledTextBox" /><input src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=11.0.3000.0&Name=Microsoft.Reporting.WebForms.Icons.MultiValueSelect.gif" name="ctl32$ctl04$ctl03$ddDropDownButton" type="image" id="ctl32_ctl04_ctl03_ddDropDownButton" alt="Select a value" title="Select a value" style="vertical-align:top;margin-top:1px;cursor:pointer;" disabled="disabled" />
                                                                                    </div>
                                                                               </div></td><td class="InterParamPadding"></td><td class="ParamLabelCell"><label for="ctl32_ctl04_ctl05_txtValue"><span>INSTALL DATE</span></label></td><td class="ParamEntryCell" style="padding-right:0px;"><div id="ctl32_ctl04_ctl05">
                                                                                    <div onactivate="event.cancelBubble=true;" style="white-space:nowrap;">
                                                                                         <input name="ctl32$ctl04$ctl05$txtValue" type="text" size="28" id="ctl32_ctl04_ctl05_txtValue" disabled="disabled" class="DisabledTextBox" /> <input src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=11.0.3000.0&Name=Microsoft.Reporting.WebForms.calendar_disabled.gif" name="ctl32$ctl04$ctl05$ddDropDownButton" type="image" id="ctl32_ctl04_ctl05_ddDropDownButton" alt="Select a value" title="Select a value" style="cursor:pointer;" disabled="disabled" />
                                                                                    </div>
                                                                               </div></td>
                                                                          </tr>
                                                                     </table></td><td width="6px"></td><td class="SubmitButtonCell"><table>
                                                                          <tr>
                                                                               <td><input type="submit" name="ctl32$ctl04$ctl00" value="View Report" id="ctl32_ctl04_ctl00" /></td>
                                                                          </tr>
                                                                     </table></td>
                                                                </tr>
                                                           </table><input type="text" style="visibility:hidden;display:none" disabled="disabled"></input>
                                                      </div>
                                                 </div><iframe id="ctl32_ctl04_ctl03_ctl01" onclick="event.cancelBubble=true;" onactivate="event.cancelBubble=true;" style="display:none;position:absolute;z-index:10;" src="javascript:'';" frameBorder="0" title="Status place holder" longdesc="Status place holder" Name="ctl32_ctl04_ctl03_ctl01"></iframe><div id="ctl32_ctl04_ctl03_divDropDown" onclick="event.cancelBubble=true;" onactivate="event.cancelBubble=true;" style="display:inline-block;border-color:DarkGray;border-width:1px;border-style:Solid;height:150px;overflow:auto;background-color:window;display:none;position:absolute;z-index:11;">
                                                      <table cellpadding="0" cellspacing="0" style="background-color:window;">
                                                           <tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl00" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl00" onclick="$get('ctl32_ctl04_ctl03').control.OnSelectAllClick(this);" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl00">(Select All)</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl02" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl02" checked="checked" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl02">A</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl03" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl03" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl03">C</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl04" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl04" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl04">D</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl05" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl05" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl05">H</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl06" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl06" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl06">M</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl07" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl07" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl07">N</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl08" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl08" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl08">P</label></span></td>
                                                           </tr><tr>
                                                                <td nowrap="nowrap"><span><input id="ctl32_ctl04_ctl03_divDropDown_ctl09" type="checkbox" name="ctl32$ctl04$ctl03$divDropDown$ctl09" onclick="$get('ctl32_ctl04_ctl03').control.OnValidValueClick(this, 'ctl32_ctl04_ctl03_divDropDown_ctl00');" /><label for="ctl32_ctl04_ctl03_divDropDown_ctl09">W</label></span></td>
                                                           </tr>
                                                      </table><span><input type="hidden" name="ctl32$ctl04$ctl03$divDropDown$ctl01$HiddenIndices" id="ctl32_ctl04_ctl03_divDropDown_ctl01_HiddenIndices" value="0" /></span>
                                                 </div><iframe id="ctl32_ctl04_ctl05_ctl01" Name="ctl32_ctl04_ctl05_ctl01" frameBorder="0" onload="
    this.resultfield=$get('ctl32_ctl04_ctl05_txtValue');
    this.resultfunc=function(resultField){$get('ctl32_ctl04_ctl05').control.OnCalendarSelection(resultField);}" title="INSTALL DATE date picker" onclick="event.cancelBubble=true;" onactivate="event.cancelBubble=true;" scrolling="no" style="display:none;position:absolute;z-index:10;" longdesc="INSTALL DATE date picker" src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Calendar&amp;LCID=1033&amp;selectDate="></iframe></td>
                                            </tr><tr style="height:6px;font-size:2pt;">
                                                 <td colspan="3" class="SplitterNormal" style="padding:0px;margin:0px;text-align:center;"><div id="ctl32_ToggleParam">
                                                      <input type="image" name="ctl32$ToggleParam$img" id="ctl32_ToggleParam_img" title="Show / Hide Parameters" src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Resource&amp;Version=11.0.3000.0&amp;Name=Microsoft.Reporting.WebForms.Icons.SplitterHorizCollapse.png" alt="Show / Hide Parameters" align="middle" onclick="void(0);" style="border-width:0px;cursor:pointer;" /><input type="hidden" name="ctl32$ToggleParam$store" id="ctl32_ToggleParam_store" /><input type="hidden" name="ctl32$ToggleParam$collapse" id="ctl32_ToggleParam_collapse" value="false" />
                                                 </div></td>
                                            </tr><tr style="display:none;">

                                            </tr><tr>
                                                 <td style="vertical-align:top;width:25%;height:100%;display:none;"><div style="width:100%;height:100%;">
                                                      <span id="ctl32_DocMap"><div id="ctl32_ctl08" style="display:none;">
                                                           <input type="hidden" name="ctl32$ctl08$ClientClickedId" id="ctl32_ctl08_ClientClickedId" />
                                                      </div></span>
                                                 </div></td><td class="SplitterNormal" style="display:none;width:4px;padding:0px;margin:0px;height:100%;vertical-align:middle;"><div id="ctl32_ctl07">
                                                      <input type="image" name="ctl32$ctl07$img" id="ctl32_ctl07_img" title="Show / Hide Document Map" src="/Reports/Reserved.ReportViewerWebControl.axd?OpType=Resource&amp;Version=11.0.3000.0&amp;Name=Microsoft.Reporting.WebForms.Icons.SplitterVertCollapse.png" alt="Show / Hide Document Map" align="top" onclick="void(0);" style="border-width:0px;cursor:pointer;" /><input type="hidden" name="ctl32$ctl07$store" id="ctl32_ctl07_store" /><input type="hidden" name="ctl32$ctl07$collapse" id="ctl32_ctl07_collapse" value="false" />
                                                 </div></td><td style="height:100%;vertical-align:top;"><div id="ctl32_ctl09" style="height:100%;width:100%;overflow:auto;position:relative;">
                                                      <div id="VisibleReportContentctl32_ctl09" style="height:100%;display:none;">

                                                      </div><div id="ctl32_ctl09_ReportArea">
                                                           <div NewContentType="Microsoft.Reporting.WebFormsClient.ReportAreaContent.None" ForNonReportContentArea="false" id="ctl32_ctl09_VisibilityState" style="visibility:none;">
                                                                <input type="hidden" name="ctl32$ctl09$VisibilityState$ctl00" value="None" />
                                                           </div><input type="hidden" name="ctl32$ctl09$ScrollPosition" id="ctl32_ctl09_ScrollPosition" /><span id="ctl32_ctl09_Reserved_AsyncLoadTarget"></span><div id="ctl32_ctl09_ReportControl" style="display:none;">
                                                                <span></span><input type="hidden" name="ctl32$ctl09$ReportControl$ctl02" /><input type="hidden" name="ctl32$ctl09$ReportControl$ctl03" /><input type="hidden" name="ctl32$ctl09$ReportControl$ctl04" id="ctl32_ctl09_ReportControl_ctl04" value="100" />
                                                           </div><div id="ctl32_ctl09_NonReportContent" style="height:100%;width:100%;">

                                                           </div>
                                                      </div>
                                                 </div></td>
                                            </tr>
                                       </table>
                                  </div></span></td>
                             </tr>
                        </table>
                        </span></td>
                   </tr>
              </table>
              </td>
         </tr>
    </table>
    </span>
    </form></BODY></HTML>

    _There are no database values exposed in the code above._

    Thank you,
    M.R.
  • 7. Re: French characters not showing on a web report
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    If there are no database values shown in page source, then they are retrieved through JavaScript, probably AJAX, I guess. I do not know Microsoft report manager, unfortunately.

    However, the value in the database does not seem to make sense to me either. Could you tell me what is the expected string that corresponds to the DUMP result and also, what you exactly see on the screen where this string should be displayed.


    -- Sergiusz
  • 8. Re: French characters not showing on a web report
    M.R. Newbie
    Currently Being Moderated
    I just realized there is something wrong with the CSV file I upload to the database table. I get this file from an AS/400 database and if I open it in Notepad, I can see small squares instead of French characters. I verified the ASCII code for such a square that corresponds to an E with accent and I got: 144. This is correct. So I assumed the CSV file is correct.

    However, I was wrong. If I copy and paste an E with accent from a web page directly into the Oracle table (using TOAD), it shows correctly on the report!

    Why the ASCII code behind the French characters in Notepad is right but the characters are showing as small squares, it' unclear...
    As I mentioned, we get the CSV file from a DB2 database using an IBM application (iSeries) so I'll have to investigate what characters sets are supported, etc.

    Thank you for your help.

    Regards,
    M.R.





    OK it is now resolved! It was the character set ID in the ISeries apllication that had to be set to a special value, 819.

    Edited by: M.R. on May 10, 2013 1:16 PM
  • 9. Re: French characters not showing on a web report
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    Actually, if it is supported, you should use 1252 instead of 819. 819 corresponds to WE8ISO8859P1, 1252 corresponds to WE8MSWIN1252, your database character set. WE8ISO8859P1 is a subset of WE8MSWIN1252 and does not support some characters, such as '€' (Euro sign), or 'œ' (oe ligature). This may or may not be an issue, depending on what data you get from AS/400. Code 144 for 'É' is valid, indeed, however not in WE8MSWIN1252 but in US8PC437 or WE8PC850.


    -- Sergiusz
  • 10. Re: French characters not showing on a web report
    M.R. Newbie
    Currently Being Moderated
    Great, I set it to 1252 and it works perfectly!
    Thank you again for all your help.

    Regards,
    M.R.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points