search
HomeWeb Front-endHTML TutorialSummary of usage of common functions of web reporting tool FineReport (report function)_html/css_WEB-ITnose

Note: In this summary, tableName or viewName are used as parameter factors. When the function is called, it searches first from the private data source, and then from the public data source.

CLASS

CLASS(object): Returns the class to which the object object belongs.

CNMONEY

CNMONEY(number,unit) returns RMB in uppercase.

number: The numeric number that needs to be converted.

unit: unit, "s", "b", "q", "w", "sw", "bw", "qw", "y", "sy", "by", "qy" and "wy" respectively represent "Shi", "Hundred", "Qian", "Wan", "Shiwan", "Hundred million", "Qianwan", "Yi", "ShiYi", " "One hundred billion", "thousands of billions", "trillions".

Remarks:

The unit can be empty. If it is empty, directly convert the number into uppercase RMB. Otherwise, first multiply the number by the base of the unit, and then multiply the The results are converted to RMB capital letters.

Example:

CNMONEY(1200) is equal to one thousand two hundred round.

CNMONEY(12.5,"w") is equal to one hundred and twenty thousand five thousand round.

CNMONEY(56.3478, "bw") is equal to five thousand six hundred and thirty four thousand seven thousand eight hundred round.

CNMONEY(3.4567, "y") is equal to 340,000,500,000 yuan.

COL

COL() returns the column number of the current cell.

Example:

If the current cell is A5, writing "=col()" in A5 will return 1.

If the current cell is C6, writing "=col()" in C6 will return 3.

COLCOUNT

COLCOUNT(tableData): Returns the number of columns in tableData.

tableData: The name of tableData, in string form.

Remarks:

First search from the private data source, and then search from the public data source. What is returned is the number of columns in the first found tableData.

Example:

Take the data source FRDemo we provide as an example

COLCOUNT("Check") is equal to 6.

COLCOUNT("country") is equal to 5.

COLNAME

COLNAME(tableData,colIndex) returns the column name of the column number colIndex in tableData.

tableData: represents the name of TableData, in string form.

colIndex: represents the column number.

Note:

TableData first searches from private data sources, and then from public data sources.

Example:

COLNAME("Check", 3) equals AcceName.

COLNAME("country", 4) is equal to Area.

EVAL

EVAL(exp): Returns the calculated result of expression exp.

exp: an expression string.

Remarks:

As long as the parameter exp in EVAL can eventually be converted into a string in the form of an expression, such as "sum(2,4)", "2 7", etc., then it can be calculated.

Example:

EVAL("2 5") is equal to 7.

EVAL("count(2,3)") is equal to 2.

EVAL("sum" "(2,3,5)") is equal to 10.

EVAL(IF(true,"sum", "count") "(1,2,3,4)") is equal to 10.

EVAL(IF(false,"sum", "count") "(1,2,3,4)") is equal to 4.

FIELDS

FIELDS(connectionName, tableName): Returns all field names in the table tableName.

Example:

There is a table named task in database BASE with the following content:

namestart end

a2008 2009

b2009 2012

Then FIELDS("BASE","task") is equal to [name,start,end].

FORMAT

FORMAT(object ,format): Returns the format of object.

object: The object that needs to be formatted can be String, number, Object (commonly used are Date, Time).

format: formatting style.

Remarks:

The uppercase and lowercase letters in the format here must strictly follow the rules in the above example, month: uppercase MM, year lowercase: yyyy or yy, day: lowercase dd.

The format of the parameter factor here can be quoted with ' ' or " ".

Example:

Format(TODAY(),'yyyy-MM-dd') The result is 2008-11-01

INMAP

INMAP(key, value, mapName): Determine whether the data dictionary mapName contains a data pair with the key value being key and the value being value. The return value is Boolean. TRUE is returned, FALSE is not returned.

key: detected key.

value: detected value.

mapName: The specified data dictionary name.

Note:

mapName must be of type String.

Example:

INMAP(1,2, "customerdic") returns Boolean.TRUE (Boolean).

ISNULL

ISNULL(object): Determine whether all values ​​in the object are Primitive.NULL.

MAP

MAP(key,mapName): Returns the value corresponding to the key in the data dictionary named mapName.

key: The key in the data dictionary corresponding to the return value.

mapName: The specified data dictionary name. Note that the data dictionary name must be enclosed in quotation marks

Example:

MAP(1,"customername") equals "Yixing HongdaFood Co.".

RECORDS

RECORDS(connection, table, field): Returns all elements under the field name field in the database table table.

Example:

There is a table named task in database BASE with the following content:

namestart end

a2008 2009

b2009 2012

Then RECORDS("BASE","task","end") is equal to [2009,2012].

RECORDS(connection, table, field, row) returns the field in the table The record in row row under the field. Field can be a column name or a column number.

RECORDS("BASE","task","end",2) is equal to 2012.

RECORDS("BASE","task",2,2) is equal to 2009.

REVERSE

REVERSE(value): Returns the logical value opposite to value.

Example:

REVERSE(true) equals false.

ROW

ROW() returns the row number of the current cell

Example:

If the current cell is A5, Writing "=ROW()" in A5 returns 5.

If the current cell is B8, writing "=ROW()" in B8 will return 8.

ROWCOUNT

ROWCOUNT(tableData) returns the number of rows in tableData.

tableData: The name of TableData, in string form.

Note:

First search from the private data source, and then search from the public data source. The number of rows in tableData is returned.

Example:

Take the data source FRDemo we provide as an example

ROWCOUNT("Check") is equal to 3.

ROWCOUNT("country") is equal to 18.

TABLEDATAFIELDS

TABLEDATAFIELDS(tableData): Returns all field names in tableData.

Note:

First search from the report data set, and then search from the server data set. What is returned is an array composed of the column names of tableData.

Example:

TABLEDATAFIELDS("Country") equals [name, capital, continent, area, population

TABLEDATES

TABLEDATAS(): Returns the report data set and server data set names. ]

Example:

The server data set has: ds1, ds2, ds3; the report data set has dsr1, dsr2.

TABLEDATAS() is equal to [dsr1, dsr2, ds1 ,ds2,ds3].

And TABLEDATAS(0) returns the server data set name; TABLEDATAS(1) returns the report data set name;

TABLEDATAS(0) is equal to [ds1,ds2,ds3 ];TABLEDATAS(1) equals [dsr1,dsr2].

TABLES

TABLEAS(connectionName): Returns all table names in the database named connectionName.

Example:

Assume that in the FRDemo database, there are 3 tables: a, b, c;

Then TABLES("FRDemo") is equal to [a,b ,c].

VALUE

VALUE(tableData, row,col) returns the value of row number and column number col in tableData.

tableData: The name of tableData, in string form.

row: row number.

col: column number.

Note:

First search from the private data source, and then search from the public data source. What is returned is the qualified value of tableData.

Example:

VALUE("country", 5, 3) equals South America.

VALUE("Simple", 8, 3) equals jonnason.

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How can you validate your HTML code?How can you validate your HTML code?Apr 24, 2025 am 12:04 AM

HTML code can be cleaner with online validators, integrated tools and automated processes. 1) Use W3CMarkupValidationService to verify HTML code online. 2) Install and configure HTMLHint extension in VisualStudioCode for real-time verification. 3) Use HTMLTidy to automatically verify and clean HTML files in the construction process.

HTML vs. CSS and JavaScript: Comparing Web TechnologiesHTML vs. CSS and JavaScript: Comparing Web TechnologiesApr 23, 2025 am 12:05 AM

HTML, CSS and JavaScript are the core technologies for building modern web pages: 1. HTML defines the web page structure, 2. CSS is responsible for the appearance of the web page, 3. JavaScript provides web page dynamics and interactivity, and they work together to create a website with a good user experience.

HTML as a Markup Language: Its Function and PurposeHTML as a Markup Language: Its Function and PurposeApr 22, 2025 am 12:02 AM

The function of HTML is to define the structure and content of a web page, and its purpose is to provide a standardized way to display information. 1) HTML organizes various parts of the web page through tags and attributes, such as titles and paragraphs. 2) It supports the separation of content and performance and improves maintenance efficiency. 3) HTML is extensible, allowing custom tags to enhance SEO.

The Future of HTML, CSS, and JavaScript: Web Development TrendsThe Future of HTML, CSS, and JavaScript: Web Development TrendsApr 19, 2025 am 12:02 AM

The future trends of HTML are semantics and web components, the future trends of CSS are CSS-in-JS and CSSHoudini, and the future trends of JavaScript are WebAssembly and Serverless. 1. HTML semantics improve accessibility and SEO effects, and Web components improve development efficiency, but attention should be paid to browser compatibility. 2. CSS-in-JS enhances style management flexibility but may increase file size. CSSHoudini allows direct operation of CSS rendering. 3.WebAssembly optimizes browser application performance but has a steep learning curve, and Serverless simplifies development but requires optimization of cold start problems.

HTML: The Structure, CSS: The Style, JavaScript: The BehaviorHTML: The Structure, CSS: The Style, JavaScript: The BehaviorApr 18, 2025 am 12:09 AM

The roles of HTML, CSS and JavaScript in web development are: 1. HTML defines the web page structure, 2. CSS controls the web page style, and 3. JavaScript adds dynamic behavior. Together, they build the framework, aesthetics and interactivity of modern websites.

The Future of HTML: Evolution and Trends in Web DesignThe Future of HTML: Evolution and Trends in Web DesignApr 17, 2025 am 12:12 AM

The future of HTML is full of infinite possibilities. 1) New features and standards will include more semantic tags and the popularity of WebComponents. 2) The web design trend will continue to develop towards responsive and accessible design. 3) Performance optimization will improve the user experience through responsive image loading and lazy loading technologies.

HTML vs. CSS vs. JavaScript: A Comparative OverviewHTML vs. CSS vs. JavaScript: A Comparative OverviewApr 16, 2025 am 12:04 AM

The roles of HTML, CSS and JavaScript in web development are: HTML is responsible for content structure, CSS is responsible for style, and JavaScript is responsible for dynamic behavior. 1. HTML defines the web page structure and content through tags to ensure semantics. 2. CSS controls the web page style through selectors and attributes to make it beautiful and easy to read. 3. JavaScript controls web page behavior through scripts to achieve dynamic and interactive functions.

HTML: Is It a Programming Language or Something Else?HTML: Is It a Programming Language or Something Else?Apr 15, 2025 am 12:13 AM

HTMLisnotaprogramminglanguage;itisamarkuplanguage.1)HTMLstructuresandformatswebcontentusingtags.2)ItworkswithCSSforstylingandJavaScriptforinteractivity,enhancingwebdevelopment.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools