Skip to Content
avatar image
Former Member

Letter problem when I extract a report

Dear all,

I want to explain an issue that we notice when we extract a Report created by Crystal Report 2011 by a project developed with Visual Studio 2013 and Cristal Report for Visual studio.
Since 2 weeks we have transferred all our project and IIS sites on a new Server with Crystal Report for Visual studio v19 and SQL Server 2016.
We notice that, in all cases, when we extract a Report from the Project Interface we have in ALL the letter "t" occurrence replaced by a "ti". This not happens if we extract the Report directly from the Preview in Crystal Report 2011. Also if we try to modify the .pdf with acrobat reader and we delete the ti character there is no way to delete only the i, it delete t and i together.
This does not happens with the old Crystal Report for Visual Studio, and the Language of Database is the same that before: Italian, with Collation Latin1_General_CI_AS.

Do you know if there is any option to avoid this issue in Crystal Report, or if it depends on SQL Server problems?

Cordially,

Trezzi Alessandro

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 12, 2017 at 01:52 PM

    After doing some further research, this appears to be a known issue with the Calibri font. I don't know whether the registry setting in my comment above will help.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Yes, there is a way to do something like this in C#. First, you'll load a report into a ReportDocument object. Then you'll do something like the following:

      Font regularFont = new Font(FontFamily.GenericSansSerif, 10, FontStyle.Regular);
      Font headerFont = new Font(FontFamily.GenericSansSerif, 12, FontStyle.Bold);
      foreach (Section section in procRpt.ReportDefinition.Sections)
      {
        foreach(ReportObject rptObj in section.ReportObjects)  
        {
          switch (rptObj.Kind)
          {
            case ReportObjectKind.FieldObject:
              FieldObject fldObj = (FieldObject) rptObj;
              fldObj.ApplyFont(regularFont);
              break;
            case ReportObjectKind.FieldHeadingObject:
              FieldHeadingObject fhObj = (FieldHeadingObject) rptObj;
              fhObj.ApplyFont(headerFont);
              break;
            default:
              break;
          }
        }
      }

      I didn't find a way to modify stuff in a CrossTab, so you may have to do any of those manually.

      -Dell

  • Apr 06, 2017 at 05:19 PM

    Hi Trezzi,

    Is it possible to upload the report with saved data, make sure it is dummy data, so I can test it?

    We can no long attach rpt files to forums so you need to provide a link for me to download it from.

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Don, thank's for you answer.
      Sadly I've only reserved data; how can I send to you Report with dummy data?
      However, could be the convertion in pdf mode?

  • Apr 06, 2017 at 05:53 PM

    1. Did you recompile your application with SP19? Or did you just deploy the existing application with the new version of the runtime?

    2. Which version of the SQL Server driver are you using? For SQL Server 2016 you need to be on at least SQL Server Native Client 11 or SQL Server ODBC driver 13.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • There is a registry setting that may work.

      In either of the following:

      • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0 - (on 64 bit OS)
      • HKEY_CURRENT_USER\Software\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0

      go to or create ...\Crystal Reports\Export\PDF.

      Then create the key UseCustomEncoding with a value type of DWord and a value of 0

      -Dell