Changes

{{MySQL Syntax}}The '''Calculated Field''' in '''Reporting''' the [[Report Builder]] allows you to specify MYSQL MySQL statements to be executed when generating the report.

The field itself is a multiple line text area field, which means users can stretch out the box so that all text contained within the field can be immediately exposed. This is of assistance when there are long, complicated calculations against a column.  The following are some examples of statements that can be entered into the '''Calculated Field''' of the [[Report]] builder.

Under Calculated Field section{{ReportBuilderDateFormatOption}}<br /> {{MYSQLDATETIMEFORMATS}} ===Calculate Business Day===To calculate number of business day had passed, you can use need to do the following format for : 1. Create a date fieldholiday calendar and add all the holiday within that calendar. 2. Use the following syntax within Calculated Field when you build your report '''Syntax'''SS_FUNC.countbusdays(date1,date2)

DATE_FORMAT'''Example'''SS_FUNC.countbusdays(now(),[this], '%W, %M %D') -- Thursday, November 5th 1

* If the field value ([[Determining the statusid |statusid]] in this example) is one of 6 different statusids, display the word ''Submitted''', otherwise display the field value: