 |
Add 18 Types of Barcodes: QR Code (includes support for colors, logos, and ZATCA e-invoicing), PDF417, DataMatrix, Aztec, UPC-A, UPC-E, UPC-EAN-Extended, EAN13, EAN8, CODE 39, CODE 93, CODE 128, CodeBar, ITF, MSI, Plessey, USPS Intelligent Mail barcode (aka IMb, One Code Solution, 4-State Customer Barcode, 4CB, 4-CB, or USPS4CB). without dependency on font files. See sample image.
|
|
Generate Sparklines, Gauges, and Bullet Charts. See sample image.
|
|
Resize, Crop, Reorient, and Re-color Images
|
|
Convert PDF, HTML, and Web Pages to images for dynamic insertion into reports.
|
|
Total Totals
|
|
Build/Run SQL statements (Get/Update Values, Select Data Source)
|
|
GEO: compute distance between zip codes, use Google to lookup Latitude/Longitude for an address, return driving time and distance between 2 addresses given current traffic conditions.
|
|
Translate Text: use Google Translate API 
|
|
Call Web Services and Return Values
|
|
E-mail dynamic-content messages from within any section of a Crystal report via SMTP. A variety of options are supported including multiple recipients, CC Recipients, BCC recipients, and attachment files. These options can be specified by using the EmailSet() function call within a Crystal formula and by appending more elements or more text via follow-up EmailAdd() function calls before triggering the email via an EmailSend() function call.
|
|
Append Content to Text Files
Note: this can be used to take snapshots of information each time the report runs (for example, via Visual CUT scheduled processing). Another Crystal report can then use the text file as a data source for information across multiple snapshots.
|
|
Read Content of Text/RTF/HTML Files
Provide the file path & name as an argument to the FileGetText() function and get the file content as a string. You can use Crystal's formatting options to interpret the string as RTF or HTML. You can also use Crystal's string search and manipulation functions to lookup values inside the text file.
|
|
Lookup & Set Values in *.ini files
|
|
Lookup Values in Excel files or in the Registry
|
|
Convert GMT/UTC to Local or Specified Time Zone
|
|
Replace Accented Characters
|
|
Convert hex strings to ascii
|
|
Trigger Message/Input Boxes and Applications via Command Lines
|
|
Trigger Report Processing by Visual CUT or DataLink Viewer
|
|
Annotate (add comments to) Crystal reports
|
|
Convert HTML content to RTF for better display
|
|
Encrypt/Decrypt Strings
|
|
Perform 'BitWise AND' Operations
|
|
Get the 'User Name' & 'PC Name' Running the Report
Note: this can be used to impose row-level security or to address data access tracking requirements such as those imposed by HIPAA.
|
|
Lookup JSON Values
|
|
Regular Expression functions allow you to match and replace strings based on powerful patterns.
|
