4C-TV™ System

  Quick Report Formulas

u When creating Quick Reports it is possible to add columns with special formulas, e.g.: calculation of fields from the database.  4C-TV provides a set of functions to allow the creation of special formulas.  The functions available and a brief description are listed below.

Function

Description

fR_Boolean

Used in Boolean fields to indicate a specific text field for which the values is True or False

Format :
fR_Boolean(field;"True";"False")
Where:
    o  field : indicates the type of Boolean field
    o  "True" : shows the text for True field, e.g.: "Sim", "Yes"; "Has"
    o    "False" : shows the text for the False field,  e.g.: "Não"; "No";...

fR_DataTrafego

Used for Monthly Schedule reports, and calculates the exact date of broadcast of a program

Format:
fR_DataTrafego

fR_DispTrafego

Indicates versions available for a specific program.  If a version is found, the result will be "Traffic Available"; if not found, it will indicate "Expected Traffic xx/xx/xx" (expected delivery date of the program copy)

Format:
fR_DispTrafego

fR_Versoes

Displays a list of recorded versions for a specific program as:

n:vfm vfm vfm ....

Where:

    • n: stands for the number of versions for a program
    • vfm : stands for the versions available as follows:
      • V: first letter for the version (L:Leg, D:Dub, S:Script,...)
      • F : first letter for the formatting (B:Beta, V:VHS, ...)
      • M : first letter for the material (M:Master, C:Copy, B:backup, ...)
Format:
fR_Versoes

fR_PlayDateAte

Indicates the total number of play dates of a program.  It is also fills the variable RV_ProgDays with the list of play dates

Format:
fR_PlayDateAte

fR_PlayDatePer

Indicates the number of play dates of a program within the indicated report period.It is also fills the variable RV_ProgDays with the list of play dates

Format:
fR_PlayDatePer

fR_Quoted

Indicates fields in quotation marks

Format:
fR_Quoted(field)
Where:
o       field : indicates the "quoted" field

fR_DescontoOI

Indicates the discount negotiated for an Ad Sales Order.  It is calculated based on the value negotiated and the table value

Format:
fR_DescontoOI

fR_VlrTablOI

Indicates the Ad Sales Order price table Value.  It also puts the calculated discount in the variable RV_Desconto

Format:
fR_VlrTablOI

UThhTimeToZone

Used to convert a time field into different time zones

Format:
UThhTimeToZone(field;"timezone"[;date][;"datetype"][;channel])
Where:
o       field : indicates the original time field
o       timezone : the name of the time zone to be converted to.  It must correspond to a timezone defined in the system and in quotation marks
o       date : reference date for the conversion; if ommitted, the current date will be used
o       datetype : informs the type of the date parameter and can be: "B"= the date represents the broadcast date; or "C"= the date is the calendar date (default).
o       channel : the corresponding channel to be used as basis to determining time zone conversions; this is required if the datetype is "B" as channles may have a distinct broadcast day start time.

UTtxfAdjustTitle

Adjusts program titles containing articles at the end.  The article is transferred to the beginning of the title

Format:
UTtxfAdjustTitle(field)
Where:
o       field : indicates the title field to be adjusted

UTtxNormalizeName

Converts cast's names into a standard format: "lastname, firstname".

Format:
UTtxNormalizeName(field)
Where:
o       field : indicates the name field to be converted

UTtxNaturalName

Converts names from  "lastname, firstname" format to "firstname lastname" format

Format:
UTuxNaturalName(field)
Where:
o       field : indicates the name field to be converted

UUtxCapitals

Capitalizes the first letter of each word

Format:
UUtxCapitals(field)
Where:
o       field : indicates the field to be capitalized

UUtxFixStringSize

Changes the size of characters strings, adjusting the text accordingly.  It can be used when exporting texts with fixed string sizes

Format:
UUtxFixStringSize(field; size)
Where:
o       field : indicates the field to be adjusted
o       size : indicates the desired number of characters


4C-TV Home | 4C-TV Functions | Release Notes

updated release 2.3.008
Thu, Nov 15, 2001