Summary:OverviewVersionReport Server VersionJAR Package VersionPlugin VersionFunctional Change10.02019/07/31V[Full Text:]

Summary:DATEDescriptionDATE(year, month, date)  Inputyear: a number that specifies the year. Type:[Full Text:]

Summary:CLASSOverviewSyntaxCLASS(object)Returns the class to which the object parameter belongs.Parameterobje[Full Text:]

Summary:OverviewVersionReport Server VersionFunctional Change11.0/11.0.18Added a new writing method to preven[Full Text:]

Summary:OverviewVersionsReport Server VersionFunctional Change11.0.4/11.0.7Optimized the ACCSUM function, whi[Full Text:]

Summary:I. Description1. VersionReport Server VersionJAR Package VersionPlugin Version10.02015-12-20V8.89.08.[Full Text:]

Summary:I. Overview1) Application scenariosIf you want to "conditionally display" the values o[Full Text:]

Summary:I. Decimals are displayed in thousandths styleIn Cell Attribute>Style>Format, there is onl[Full Text:]

Summary:I. Formula edit boxThere are many places where FR uses formulas, cells (the ones beginning with = are[Full Text:]

Summary:I. DescriptionEveryone knows that Excel is very powerful, but some Excel functions in FineReport cann[Full Text:]

Summary:I. DescriptionIn our daily report design, one of the most commonly used widgets is the "Date&quo[Full Text:]

Summary:I. DescriptionWhen operating on date data, you often encounter operations such as obtaining the curre[Full Text:]

Summary:I. IntroductionAs a report tool, FanRuan often uses the knowledge of arrays when expanding the displa[Full Text:]

Summary:I. DescriptionIn the process of setting up reports, we may often need to perform string splicing in c[Full Text:]

Summary:I. Overview1. FunctionThe TOIMAGE function is used to display pictures under a certain path in the re[Full Text:]

Summary:I. FunctionWith the value function, you can directly retrieve the row and column data that meet the c[Full Text:]

Summary:I. DescriptionSometimes we need to use regular expressions, for example, regular expressions are used[Full Text:]

Summary:I. len()LEN(args): Returns the number of characters in the text string or the length of the arra[Full Text:]

Summary:I. SUMSUM(number1,number2,...): Find the sum of all numbers in a specified cell range.number1,nu[Full Text:]

Summary:I. INDEXOFARRAYINDEXOFARRAY(array,index): Returns the index element of the array.array: Need to[Full Text:]

Summary:I. OperatorOperators are used to perform program code operations and will perform operations on[Full Text:]

Summary:MAPDescriptionMAP(reference_value, searched_dataset, reference_col, result_col)Inputreference_value:[Full Text:]

Summary:ARRAYDescriptionARRAY(value_1, value_2, ...)Inputvalue_1: the first element of array. value_2: t[Full Text:]

Summary:ANDDescriptionAND(value1, value2, ...)InputValues that participate in the logical operation. Type: lo[Full Text:]

Summary:CHARDescriptionCHAR(number)  InputAn integer between 1 and 65535 (including 1 and 65535).Ty[Full Text:]

Summary:ABSDescriptionABS(value)Inputvalue: a number. Type: number.OutputOutput the absolute value of the num[Full Text:]

Summary:SUMDescriptionSUM(value1, value2,...)Inputvalue1: the first value to sum.value2: the second value to[Full Text:]

Summary:CIRCULARDescriptionCIRCULAR(timestamp, result, add_value, minus_value, vertical_expansion)Inputtimest[Full Text:]

Summary:1. 概述1.1 函数作用统计数据区域中所含数字项的个数，为非去重计数。去重计数通过组合 count 函数和 UNIQUEARRAY()函数实现 ，例如：count(UNIQUEAR[Full Text:]

Summary:1. 描述在使用数据集函数 select 的时候ds1.select（ 列A, 列B=E4) 这样公式时，每行都对整个数据集做了遍历的操作，这样会导致速度比较慢，详细点击 ds1.select[Full Text:]

Summary:1. 概述语法：treelayer(TreeObject, Int, Boolean, String)定义：返回一个树对象 TreeObject 第 n 层的值，一般为树数据集，或下拉树、视图[Full Text:]

Summary:1. 描述在进行多 sheet 报表设计的时候，两个 sheet 里面都用到了扩展数据集，如何从一个 sheet 里面获取另一个sheet里面对应的数据的值呢，如下：    &nbs[Full Text:]

Summary:1. Map 函数的定义语法Map(object, string, int, int)其中四个参数依次为：索引值，数据集的名字，索引值所在列序号，返回值所在列序号。后面两个参数也可以用列名代替[Full Text:]

Summary:1. 描述在制作报表时，某数据列如收入金额是数字类型，其中数据包含小数，且小数位数不超过 2 位，对该列进行求和（使用公式 sum）等处理时，会发现最终的结果如：123456.409999996，即小数[Full Text:]

Summary:1. 问题描述报表中，若使用到复杂的FR脚本表达式，如：=if (很长很长的公式 > 0，执行语句 1(很长很长的公式)，执行语句 2(很长很长的公式))，首先想到的是：将很长很长的公式[Full Text:]

Summary:1. 函数用法NVL 函数的使用方法：NVL(value1,value2,value3,...)：在所有参数中返回第一个不是 null 的值。注：6.5 之前的版本 NVL 只支持 2 个参数[Full Text:]

Summary:1. 描述当需要判断条件多的时候，可能您会觉得用if函数要对每种情况都进行判断的话会比较麻烦，那么您可以使用 switch 函数，这样您只需要写一个表达式了。下面简单的介绍一下 switch函数的用法。[Full Text:]

Summary:1. 问题描述在票据类汇总报表中，为防止随意涂改作假，常需将金额转换为大写的人民币形式，此时可使用 Cnmoney() 函数直接进行转换。2. 公式的使用说明Cnmoney(numb[Full Text:]

Summary:1. 描述Range(from,to,step)函数：表示从整数 from 开始，以 step 为每一步的大小，直到整数 to 的一个数字序列。Range()函数有三种参数形式，不仅可以生成数值，且也能[Full Text:]