Interactive Reporting has special words that should not be used when naming a column, table, section or computed item name:
Table 186. Reserved Word List
| Reserved Word | |
|---|---|
Abs | MonthsBetween |
| Add | Next |
AddMonths | NextDay |
Ascii | Nv1 |
Atn | parseInt |
Avg | Percentile |
AvgNonNull | Power |
Ceil | Prior |
Chr | Rank |
ColMas | RankAsc |
ColMin | Replace |
Concat | Round |
Cos | Rtrim |
Count | Sign |
CountDistinct | Sin |
CountNonNull | Sinh |
CountNull | Sqrt |
Cume | StdDev |
DayOfMonth | StdDevp |
Decode | Substr |
Exp | Sum |
Floor | Sysdate |
Initcap | Tan |
Instr | Tanh |
LastDay | ToChart |
Length | ToDate |
Ln | ToMonth |
Log | ToQtr |
Lower | ToYear |
Ltrim | Translate |
Max | Trunc |
Median | Upper |
Min | Var |
Mod | Varp |
Mode |
Special characters to avoid when naming sections and variables: