Summary:OverviewVersionFineReport VersionFunctional Change11.0 -11.0.1 Added the Input Tip&nbs[Full Text:]

Summary:OverviewApplication ScenarioIn report creation, you may need to sum the data of a data column. For ex[Full Text:]

Summary:OverviewSyntax: treelayer(TreeObject, Int, Boolean, String).Definition: to return the value at the No[Full Text:]

Summary:OverviewVersionReport Server VersionFunctional Change11.0.4-11.0.7  Adapted the COUNTIFS fu[Full Text:]

Summary:OverviewFunction RoleThe function counts the number of items contained in an array or data area, such[Full Text:]

Summary:OverviewThis document explains how to use the calculation function in FineReport. This document also[Full Text:]

Summary:SUM-Summation1. OverviewSyntaxSUM(number1,number2,...)  To sum all the numbers in a specifi[Full Text:]

Summary:OverviewFunction RoleSometimes, you want to extract the data meeting required conditions in certain c[Full Text:]

Summary:OverviewVersionReport Server VersionPlugin VersionFunctional Change11.0V1.0/V1.2Added the TODATEPRO f[Full Text:]

Summary:OverviewVersionReport Server Version11.0.4Application ScenarioThe MOM function is used to calculate t[Full Text:]

Summary:OverviewWhen operating on date-type data, you often need to perform operations such as getting the cu[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. 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. 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:CIRCULARDescriptionCIRCULAR(timestamp, result, add_value, minus_value, vertical_expansion)Inputtimest[Full Text:]

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

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

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