Data Formating

The report wizard supports a number of standard data formats as well as some extensible data formating and masking. The standard formats include:

Money/Currency - defaults to the system's currency e.g. $1,000.00
Numeric Formats include: Decimals (e.g. 1,000.00), Numbers (1,000) and Percentages (e.g. 25%)
Boolean types such as Yes/No, True/False, On/Off or any custom boolean format of your choice
Date formats include Long Dates (e.g. Tuesday July 15, 1997), Medium Date (15-July-97), Short Dates - US(7/15/97), Short Date (15/7/97), Time 2:30 PM and Army Time (14:30)
Named string formats include:
- Phone numbers (800) 555-9000 and 800-555-9000
- Social Security Numbers 123-45-6789

Data Masking

In addition to data formating, the report wizard employs data masking. i.e. the output text can futher be formatted to output a different representation. These include

HTML URL (Webpage link) - the field data must be a valid web page url
Email Address - the field data must be a valid email address
Image URL - the field data must be a valid image url
Custom data masking include Inserting Hyperlinks, and doing Text Replacements

If you need to mask and format data, the report wizard will recognize the following defaults and will format the data accordingly for the Insert Hyperlink and Text Replacement text formats:

#TEMP# : Is replaced with your field value
#MONEY# : Is replaced with your field value formatted as money e.g. $35.99
#PERCENT# : Is replaced with your field value formatted as a percent e.g. 23.20%
#NUMBER# : Is replaced with your field value formatted as a number e.g. 1,000.00

Also, {{YOUR FIELD NAME}} will be replaced by the corresponding field name

Using Custom HTML Tags

Support for custom HTML tags has just been added to the Text Replacement field data format. These tags include: b, i, u, br & eval

b - bold, i - italic and u - underline e.g.
[b]{{FirstName}}[/b]
br - line break e.g.
You can format an address field as follows:
[i]{{Address}}[br]{{City}}, {{State}}[/i]
eval - evalutes the string within as a javascript function. for example, if you wanted the SUM of Field1 and Field2, you will enter the following line for your TextReplacement format:
[eval]{{Field1}}+{{Field2}}[/eval]
Consider the Order Details table which has the following fields: OrderID,ProductID,UnitPrice,Discount
If you wanted the Sale Price to appear in the Discount column, you will enter the following line for your TextReplacement format:
$[eval]{{UnitPrice}}-({{UnitPrice}}*#TEMP#)[/eval]

If you need us to include any data format that is not listed above, please send your request to support@aspwebsolution.com

...