1544676 - Tab character - char(9) is interpreted as a space when used in a Crystal Reports formula

SAP Knowledge Base Article - Public

1544676 - Tab character - char(9) is interpreted as a space when used in a Crystal Reports formula

Symptom

  • A formula with two strings separated by a tab character displays only a space, not tab

Environment

Reproducing the Issue

  • Create a report
  • Add a formula:

"Hello" + chr(9) + "Good Bye"

  • Run the report
  • See that instead of seeing a tab between the strings, only a space is displayed

Resolution

  • Technical Escalation number 5000299747 has been created for this issue
  • Work-around; Create two formulas.
  • Formula_1(defines the length of the tab)
  • Formula_2 references formula 1:

"Hello" + Space ({@Formula_1}) + "Good Bye"

Keywords

KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio