Web System Common Tools

Web System Applications Development

 Web System Database Web System PostgreSQL Tables Web System Manage fields Web System Manage constraints Web System Manage indexes Web System Manage triggers Web System SQL Tab Web System Single-row editing Web System Multirow editing in table mode Web System Import Web System Export Web System Table transfer - or Store Web System Composite Types Web System SQL Queries Web System Workflow Web System Dataset Design Web System Query Expressions Web System Where Conditions Web System Group by Expressions Web System Having Condition Web System Windows Clause Web System Order by Expressions Web System SQL Tab Web System Test a Query Web System Views Web System Functions Web System Datasources Web System Charts Web System Main type selection Web System Subtype selection Web System Datasource selection Web System General settings Web System Axis settings Web System Background settings Web System Margin settings Web System Color settings Web System Mark settings Web System QR Barcodes Web System Saving Web System Reports Web System Template Editor GYRE Web System Sections Web System Toolbar Web System Basic properties Web System Data formatting Web System Text Web System Data Web System Macro Web System Geometry Web System Line Web System Bezier curve Web System Image Web System Chart Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Report Generator Web System Report Schedule Web Site Builder Web System Content Management System (CMS) Web System Edit site Web System Themes and pages Web System Create and edit theme Web System Edit page Web System Web Form Builder / Content Editor (GYRE) Web System Toolbar Web System Events Web System Basic properties Web System Text field Web System Button Web System List Web System Combobox Web System Label Web System Checkbox Web System Radiobutton Web System Filler Web System Upload file Web System Additional tools (Gears) Web System Image Web System Flash video Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Operations with objects Web System DNS Manager Web System SEO tools Web System App Analyzer Web System Reindex Web System Publish Web System Access Log Web System Checkout settings Web System PHP Scripts development (Actions) Web System Source Editor Web System API functions Web System Custom Scripts development (JS, CSS, XML, etc...) Web System Gears Web System SaaS Solution Manager

Web System Cook book

Web System Deprecated

Web System Data formatting

GYRE Editor is capable of formatting data before generating the report. There are four methods of formatting data.

Text default format displays data as is
Number manages the display of numeric fields. Allows you to display numeric values as integers or fixed-point, or percent.
Money displays numbers with a currency sign or without with the set number of decimal digits.
Date/Time lets you choose the right date and time representation.

Dialog Set Datafield lets you select desired format from the list of prepared formats, or you can enter the format manually.

Formatting rules.

Function Description Arguments
n manages mapping of numeric fields
  • Count of fractional characters
  • Fractional divider (the default is  ".")
  • Thousands separator(the default is a comma ",")

Example: Format  weight data source field as a number with three signs in the fractional part:


Example: Format weight data source field as a number with two characters in the fractional part, using a comma as the separator:


d manages the appearance of date and time
  • Date and time format (see table below)

Example: Format the date and time in the form of "01/27/2010 15:30":

[[date||d:Y-m-d h:i]]

m Financial format
  • Currency (the default is USD). Note: a + or - sign placed in front of an argument shows where you'll see a currency symbol character. Plus - before the number, minus - after the number. By default, the symbolic representation of currencies is displayed before the number.
  • The currency symbol indent from the number.
  • Number of signs in the fractional part
  • Fractional part separator( "." is the default)
  • Thousands separator ("," is the default)

Example: Format  price data source field as a number with two characters in the fractional part and with  Euro currency symbol after the price indented one space:


Code symbols for formatting date and time:

Character in the row format Description Examples
a Ante meridiem or Post meridiem lower case am or pm
A Ante meridiem or Post meridiem upper case AM or PM
B Time in Swatch Internet standard from 000 to 999

ISO 8601 (added to PHP 5)

d Day of the month, 2 numbers with leading zeros from 01 to 31
D Abbreviated name of week days, 3 letters from Mon to Sun
F Fulll month name from January to December
g Hours in 12-hour format without leading zeros from 1 to 12
G Hours in 24-hour format without leading zeros from 0 to 23
h Hours in 12-hour format with leading zeros От 01 до 12
H Hours in 24-hour format with leading zeros from 00 to 23
i Minutes with leading zeros from 00 to 59
I (capital i) DST 1, If the date corresponds to the summer time, or 0 otherwise.
j Day of the month without leading zeros from 1 to 31
l (lowercase 'L') Full name of week day from Sunday to Saturday
L Leap year 1, if a leap year, otherwise 0.
m Serial month number with leading zeros from 01 to 12
M Abbreviated name of the month, 3 letters from Jan to Dec
n Serial month number without leading zeros from 1 to 12
O Difference with Greenwich Mean Time in hours Example: +0200
r Date in RFC 2822 format
Example: Thu, 21 Dec 2000 16:01:07 +0200
s Seconds with leading zeros from 00 to 59
S Ordinal suffix for day of the month, 2 letters st, nd, rd or th. Used together with j
t Number of days in a month from 28 to 31
T Server time zone Examples: EST, MDT ...
U Number of seconds since the beginning of The Unix Epoch (The Unix Epoch, January 1, 1970, 00:00:00 GMT) 581249852 — equivalent of 2 июля 2008 года в 10 ч. 17 м. 32 с.
w Week day number from 0 (Sunday) to 6 (Saturday)
W Serial number of the week in  the year according to ISO-8601, first day of the week - Monday (added to PHP 4.1.0) Example: 42 (42nd week of the year)
Y Serial number of the year, 4 digits Examples: 1999, 2003
y Year number, 2 digits Examples: 99, 03
z The day of the year (starting with 0) from 0 to 365
Z Timezone offset in seconds. For the time zones west of UTC it is always negative, east of UTC is positive. from -43200 to 43200