8,849
edits
Changes
→Formatting
{{MySQL Syntax}}
The ''Calculated Field'' in the [[Report Builder]] allows you to specify MySQL statements to be executed when generating the report.
<br />
{| border="1"{MYSQLDATETIMEFORMATS}}! Format! Description|-|%a||Abbreviated weekday name|-|%b||Abbreviated month name|-|%c||Month, numeric|-|%D||===Calculate Business Day of month with English suffix===|-|%d||Day To calculate number of monthbusiness day had passed, numeric (01-31)you need to do the following:|-|%e||Day of month, numeric (1-31)|-|%H||Hour (00-23)|-|%h||Hour (01-12)|-|%I||Hour (01-12). Create a holiday calendar and add all the holiday within that calendar.|-|%i||Minutes, numeric (00-59)2. Use the following syntax within Calculated Field when you build your report|-|%k||Hour (0-23)|-'''Syntax'''|%l||Hour SS_FUNC.countbusdays(1-12)|-|%M||Month name|-|%m||Monthdate1, numeric (00-12date2)|-|%p||AM or PM|-|%r||Time, 12-hour (hh:mm:ss AM or PM)|-'''Example'''|%S||Seconds SS_FUNC.countbusdays(00-59)|-|%s||Seconds now(00-59)|-|%T||Time, 24-hour (hh:mm:ss[this])|-1|%W||Weekday name|-|%Y||Year, four digits|-|%y||Year, two digits|}
==Conditional Statements==
THEN 'Thank for your submission' WHEN 'Status 3' THEN 'Congratulations' ELSE 'I have no comment' END
==Formatting==
To add a line break between two values in the calculated field, use syntax such as the following:
<nowiki> concat([2],"<br>",[3])</nowiki>
This will make the column display the value in column 2 of the Report Builder, followed by a line break, followed by the value in column 3.
==See Also==
