ToText Function in Crystal Report

ToText Function

Uses

The ToText function can be used to convert number, date, boolean, or time values to a string (text). It provides you with controls that let you control how the resulting string looks.

It’s mostly used for concatenation (for example, you can create a title for your report that shows the records covered, or a group name that shows the date range included.)

• Add parameters to a Report title
• Control how group names appear (you can force your dates to appear in the format 3/7/10 or 20100901.
 

List of FUNCTIONS in Crystal Report

Crystal Reports provides many FUNCTIONS for extracting information from the files. 

List of Functions

• Abs(x)
• Average([array])
• Average(field, condField)
• Average(field, condField, "condition")
• Average(field)
• BeforeReadingRecords
• Count([array])
• Count(field, condField)
• Count(field, condField, "condition")
• Count(field)
• Date (yyyy, mm, dd)
• Day (x)
• DayOfWeek (x)
• GroupNumber
• IsNull
• Length(x)
• LowerCase (x)
• Maximum([array]) Maximum(field, condField)
• Maximum(field, condField, "condition")
• Maximum(field)
• Minimum([array])
• Minimum(field, condField)
• Minimum(field, condField, "condition")
• Minimum(field)
• Month (x)
• Next
• NextIsNull
• NumericText(fieldname)
• PageNumber
• PopulationStdDev([array])
• PopulationStdDev(field, condField)
• PopulationStdDev(field, condField, "condition")
• PopulationStdDev(field)
• PopulationVariance([array])
• PopulationVariance(field, condField)
• PopulationVariance(field, condField, "condition")
• PopulationVariance(field)
• Previous
• PreviousIsNull
• PrintDate
• RecordNumber
• Remainder(numerator, denominator)
• ReplicateString(x,n)
• Round(x, # places)
• Round(x)
• StdDev([array])
• StdDev(field, condField)
• StdDev(field, condField, "condition")
• StdDev(field)
• Sum([array])
• Sum(field, condField)
• Sum(field, condField, "condition")
• Sum(field)
• Today
• ToNumber (x)
• ToText (x, # places)
• ToText (x)
• ToWords(x, # places)
• ToWords(x)
• TrimLeft (x)
• TrimRight (x)
• Truncate (x)
• UpperCase (x)
• Variance([array])
• Variance(field, condField)
• Variance(field, condField, "condition")
• Variance(field)
• WhilePrintingRecords
• WhileReadingRecords
• Year (x)