"Data Preparation" Doc in this DirectoryThere are 76 docs under this directory.Create a Doc in this Directory
Elasticsearch Dataset - Delight Edition
Author:ayuan0625      Create Time:09-01 21:43      Tag:      Edit:4 Times    |   View:242 Times

Summary:OverviewVersionReport Server VersionJAR Package VersionPlugin VersionElasticsearch Version11.02018-07[Full Text:]

[Platform] Data Connection to Dameng
Author:ayuan0625      Create Time:02-27 13:57      Tag:      Edit:3 Times    |   View:217 Times

Summary:OverviewVersionFineReport VersionFunctional Change11.0/11.0.18Allowed Dameng adaptation to stored pro[Full Text:]

[Platform] Data Connection to HBase
Author:ayuan0625      Create Time:12-19 15:39      Tag:      Edit:15 Times    |   View:196 Times

Summary:OverviewVersionFineReport VersionFunctional Change11.0/11.0.1Changed the database driver package uplo[Full Text:]

[Platform] ClickHouse Data Connection
Author:April陶      Create Time:07-01 11:42      Tag:      Edit:15 Times    |   View:5823 Times

Summary:OverviewVersionFineReport VersionFunctional Change11.0/11.0.1Changed the database driver package uplo[Full Text:]

JSON Dataset Plugin
Author:ayuan0625      Create Time:05-17 09:28      Tag:      Edit:56 Times    |   View:2832 Times

Summary:OverviewVersionReport Server VersionJSON Dataset Plugin Version11.0V9.5.7V11.0.8V9.5.811.0.10V9.5.9Ap[Full Text:]

Report Debugger
Author:ayuan0625      Create Time:06-12 11:52      Tag:      Edit:9 Times    |   View:236 Times

Summary:OverviewVersionReport Server VersionPlugin Version11.0V7.0Application ScenarioDuring a report preview[Full Text:]

Custom Data Extraction
Author:ayuan0625      Create Time:10-20 11:15      Tag:      Edit:15 Times    |   View:418 Times

Summary:OverviewWhen you create an SAP dataset, the default method is Custom Data Extraction, in which data i[Full Text:]

Simple General Query for Data Extraction
Author:ayuan0625      Create Time:10-20 11:17      Tag:      Edit:14 Times    |   View:459 Times

Summary:OverviewSimilar to SQL statements, simple general query is used to retrieve data from certain column[Full Text:]

Function in General Query for Data Extraction
Author:ayuan0625      Create Time:10-20 11:22      Tag:      Edit:11 Times    |   View:470 Times

Summary:DescriptionFineReport provides the source code for EXTRACT_TABLE_DATA and supports subsequent dataset[Full Text:]

SAP Dataset
Author:ayuan0625      Create Time:10-20 11:42      Tag:      Edit:25 Times    |   View:654 Times

Summary:OverviewAfter you have successfully established an SAP connection (referring to SAP Dataset Plug[Full Text:]

Data Sources
Author:ayuan0625      Create Time:10-20 09:55      Tag:      Edit:41 Times    |   View:7758 Times

Summary:I. An Overview of Data Sources1) Data sources in business intelligence (BI) serve as foundationa[Full Text:]

Excel Dataset (Multiple Sheets)
Author:印然      Create Time:11-17 16:49      Tag:      Edit:25 Times    |   View:59598 Times

Summary:OverviewVersionVersionFunctional Change11.0.13/Application ScenarioThis plugin can help you add one o[Full Text:]

Data Factory Dataset
Author:ayuan0625      Create Time:11-27 19:09      Tag:      Edit:12 Times    |   View:464 Times

Summary:OverviewVersionReport Server   VersionMin JAR Package VersionPlugin VersionFunctional Change11.0[Full Text:]

Data Connection to Google BigQuery
Author:frenadmin1234      Create Time:05-19 16:59      Tag:      Edit:4 Times    |   View:855 Times

Summary:OverviewVersionReport Server VersionJAR Package VersionFunctional Change11.0/Supported the data conne[Full Text:]

File Dataset
Author:ayuan0625      Create Time:11-23 15:37      Tag:      Edit:23 Times    |   View:470 Times

Summary:OverviewFile dataset refers to using data from TXT text files, Excel files, and XML files as the data[Full Text:]

[Designer] ODBC Data Connection
Author:ayuan0625      Create Time:10-30 15:43      Tag:      Edit:29 Times    |   View:1560 Times

Summary:OverviewApplication ScenarioThis document introduces how to connect FineReport to an ODBC database.En[Full Text:]

Built-in Dataset
Author:ayuan0625      Create Time:10-20 10:56      Tag:      Edit:20 Times    |   View:1818 Times

Summary:OverviewApplication ScenarioBuilt-in dataset refers to creating an original table that is similar to[Full Text:]

Data Connection to YouTube
Author:_791089      Create Time:09-07 14:22      Tag:      Edit:5 Times    |   View:525 Times

Summary:OverviewVersionFineReport VersionFunctional Change11.0/Application ScenarioThis document introduces h[Full Text:]

Supported Data Connection Range
Author:ayuan0625      Create Time:12-20 15:59      Tag:      Edit:19 Times    |   View:1206 Times

Summary:OverviewThere are many ways to connect data sources in FineReport.1. Direct connection to the databas[Full Text:]

Data Connection to Facebook
Author:文档助手1      Create Time:12-18 10:31      Tag:      Edit:21 Times    |   View:19272 Times

Summary:OverviewVersionFineReport VersionFunctional Change11.0/Application ScenarioThis document introduces h[Full Text:]

Data Connection to Google Sheets
Author:印然      Create Time:11-11 11:55      Tag:      Edit:28 Times    |   View:54732 Times

Summary:OverviewUse the Google Sheets file as a report data source, which can be a template dataset or server[Full Text:]

SAP Dataset Plugin
Author:ayuan0625      Create Time:10-20 10:02      Tag:      Edit:55 Times    |   View:825 Times

Summary:OverviewVersionReport Server VersionSAP Dataset Plugin Version11.0V1.8.8Function DescriptionAfter ins[Full Text:]

Multidimensional Dataset Plugin
Author:ayuan0625      Create Time:10-20 10:06      Tag:      Edit:47 Times    |   View:656 Times

Summary:OverviewVersionReport Server VersionJAR Package VersionPlugin Version10.02020-04-27V3.3.119.02018-10-[Full Text:]

Advanced Database Query
Author:ayuan0625      Create Time:11-07 13:44      Tag:      Edit:13 Times    |   View:625 Times

Summary:OverviewVersionReport Server VersionPlugin Version11.0V2.14Note:The JDK version needs to be 1.8 and t[Full Text:]

Advanced Setting in Data Connections
Author:ayuan0625      Create Time:10-30 15:46      Tag:      Edit:27 Times    |   View:1394 Times

Summary:OverviewVersionReport Server VersionFunctional Change10.0.18Renamed the Connection Pool Attributes bu[Full Text:]

Remote Excel Dataset
Author:ayuan0625      Create Time:04-19 09:37      Tag:      Edit:10 Times    |   View:486 Times

Summary:OverviewSometimes you may need to call Excel datasets on other servers.In this case, you can call Exc[Full Text:]

XML Dataset
Author:yzm282451      Create Time:12-09 11:41      Tag:      Edit:1 Times    |   View:661 Times

Summary:OverviewXML datasets refer to those whose data source is a series of XML files. You can use FineRepor[Full Text:]

Text Dataset
Author:Wendy123456      Create Time:06-23 10:46      Tag:      Edit:1 Times    |   View:499 Times

Summary:OverviewVersionReport Server Version11.0Application ScenariosMost system-generated log files are text[Full Text:]

Excel Dataset
Author:ayuan0625      Create Time:12-01 10:53      Tag:      Edit:32 Times    |   View:2466 Times

Summary:OverviewExcel dataset uses Excel files as the data source.You can use these files as the data source,[Full Text:]

Enhanced CSV Dataset
Author:frenadmin1234      Create Time:07-28 17:25      Tag:      Edit:2 Times    |   View:1877 Times

Summary:OverviewVersionReport Server VersionJAR Package VersionPlugin VersionFunctional Change10.02021/04/261[Full Text:]

[Platform] Data Connection to Microsoft SharePoint List
Author:_791089      Create Time:09-15 17:27      Tag:      Edit:2 Times    |   View:626 Times

Summary:OverviewVersionReport Server VersionFunctional Change11.0/Application ScenariosThis document introduc[Full Text:]

[Platform] Kerberos Authentication in Data Connection
Author:ayuan0625      Create Time:12-17 11:42      Tag:      Edit:21 Times    |   View:903 Times

Summary:OverviewVersionVersionFunctional Change11.0/11.0.7Optimized Kerberos authentication method, allowing[Full Text:]

StarRocks Data Connection
Author:_791089      Create Time:09-06 18:26      Tag:      Edit:0 Times    |   View:865 Times

Summary:OverviewVersionReport Server VersionFunctional Change11.0.19/Application ScenariosThis document intro[Full Text:]

[Platform] Data Connection Management
Author:ayuan0625      Create Time:11-12 19:49      Tag:      Edit:29 Times    |   View:2489 Times

Summary:OverviewVersionReport Server VersionFunctional Change11.0/11.0.4For details, see section "SSH Se[Full Text:]

New SAP BW Dataset Plugin
Author:ayuan0625      Create Time:03-23 15:47      Tag:      Edit:59 Times    |   View:1591 Times

Summary:OverviewReport Server VersionNew SAP BW Dataset Plugin Version11.0V 1.5.5Preparation Before Connectio[Full Text:]

Data Connection to Google Analytics
Author:frenadmin1234      Create Time:05-19 17:04      Tag:      Edit:1 Times    |   View:677 Times

Summary:OverviewGoogle Analytics is the data statistics program provided by Google. It can access data statis[Full Text:]

Database Query
Author:ayuan0625      Create Time:10-20 10:25      Tag:      Edit:45 Times    |   View:3278 Times

Summary:OverviewVersionVersionFunctional Change11.0/11.0.5If you select Postgre database connection, you can[Full Text:]

Google Ads Data Connection
Author:frenadmin1234      Create Time:04-13 14:55      Tag:      Edit:14 Times    |   View:801 Times

Summary:OverviewVersionReport Server VersionJAR Package DateFunctional Change11.0/Supported data connection t[Full Text:]

Dataset
Author:ayuan0625      Create Time:10-20 10:21      Tag:      Edit:36 Times    |   View:3018 Times

Summary:OverviewVersionFineReport VersionFunction Changes11.0/11.0.4Data set preview interface supported copy[Full Text:]

[Platform] SAP HANA connection
Author:ayuan0625      Create Time:12-20 09:50      Tag:      Edit:9 Times    |   View:845 Times

Summary:I. OverviewSAP HANA is a combination of software and hardware that provides high-performance data que[Full Text:]

[Platform] MySQL8 Data Connection Plugin
Author:frenadmin1234      Create Time:01-17 12:01      Tag:      Edit:1 Times    |   View:912 Times

Summary:I. Overview1. VersionReport Server VersionJAR Plugin VersionFeature Changes10.0.112020-11-27V1.0[Full Text:]

Connect to MySQL
Author:ayuan0625      Create Time:12-18 14:35      Tag:      Edit:23 Times    |   View:1823 Times

Summary:I. Overview1. VersionDesignerJARFunction change10.0.152021-04-09Built-in driver updateNote: Upgrade d[Full Text:]

Connect to MS SQL Server
Author:ayuan0625      Create Time:12-18 14:14      Tag:      Edit:23 Times    |   View:8733 Times

Summary:I. Overview1) You will learn to connect to a SQL Server database through the designer.2) This article[Full Text:]

[Designer] Hangao Data Connection
Author:ayuan0625      Create Time:06-07 09:13      Tag:      Edit:10 Times    |   View:469 Times

Summary:I. Overview1. VersionFinereport versionFunctional changes10.0.16The designer data connection configur[Full Text:]

Data Connection Failure Troubleshooting
Author:frenadmin1234      Create Time:01-14 12:08      Tag:      Edit:1 Times    |   View:1079 Times

Summary:I. Overview1. VersionFinereport version10.0.162. OverviewAfter encountering a data connection error,[Full Text:]

[Designer] Access Data Connection
Author:ayuan0625      Create Time:08-17 16:59      Tag:      Edit:23 Times    |   View:1094 Times

Summary:I. Overview1. Product IntroductionMicrosoft Office Access is a database management system that Micros[Full Text:]

[Platform] SQLite connection
Author:ayuan0625      Create Time:12-20 11:44      Tag:      Edit:16 Times    |   View:616 Times

Summary:I. OverviewSQLite is a software library that implements a self-contained, serverless, zero-confi[Full Text:]

[Platform]HSQL data connection
Author:ayuan0625      Create Time:12-19 16:02      Tag:      Edit:5 Times    |   View:666 Times

Summary:I. OverviewHSQL database is a free database written in Pure Java, licensed under bSD-style proto[Full Text:]

[Platform] Huawei cloud DWS data connection
Author:ayuan0625      Create Time:12-25 17:23      Tag:      Edit:5 Times    |   View:689 Times

Summary:I. OverviewHuawei Cloud Data Warehouse Service (DWS) is an enterprise-level data warehouse produ[Full Text:]

[Platform]ODBC data connection
Author:ayuan0625      Create Time:07-23 16:04      Tag:      Edit:3 Times    |   View:710 Times

Summary:I. Overview1) Application scenariosFineReport10.0 has JDK1.8 or JDK 11 built in, but these two J[Full Text:]

MongoDB Dataset Plugin
Author:ayuan0625      Create Time:02-02 11:45      Tag:      Edit:32 Times    |   View:1372 Times

Summary:I. OverviewMongoDB is a mainstream NoSQL database. After the MongoDB database plugin is installed (pl[Full Text:]

[Platform] GaussDB 200 Data Connection
Author:ayuan0625      Create Time:12-25 17:10      Tag:      Edit:7 Times    |   View:1436 Times

Summary:I. DescriptionGaussDB is a relational database system developed by Huawei Technologies Co., Ltd. base[Full Text:]

[Platform] Oracle Data Connection
Author:ayuan0625      Create Time:12-18 15:00      Tag:      Edit:13 Times    |   View:1248 Times

Summary:I. Overview1. Version FineReport VersionFunction Changes10.0-10.0.18The built-in driver version[Full Text:]

Connection Pool Full
Author:ayuan0625      Create Time:10-30 15:45      Tag:      Edit:18 Times    |   View:1631 Times

Summary:I. Overview1)The core of the connection pool technology lies in "connection reuse". To[Full Text:]

[Designer] JDBC Data Connection
Author:ayuan0625      Create Time:10-20 09:57      Tag:      Edit:73 Times    |   View:2009 Times

Summary:I. Overview1. VersionFinereport versionFunction changes10.0.16The designer data connection configurat[Full Text:]

Firebird Data Connection
Author:ayuan0625      Create Time:07-19 15:21      Tag:      Edit:9 Times    |   View:738 Times

Summary:I. OverviewFirebird is an open source, free, full-featured, powerful, efficient, lightweight and main[Full Text:]

[Platform] HP Vertica Data Connection
Author:ayuan0625      Create Time:12-06 17:20      Tag:      Edit:15 Times    |   View:813 Times

Summary:I. DescriptionHP Vertica is a database based on column-based MPP (massively parallel processing) arch[Full Text:]

[Platform] Hadoop Hive Data Connection
Author:ayuan0625      Create Time:12-18 10:48      Tag:      Edit:14 Times    |   View:955 Times

Summary:I. DescriptionHadoop is a very popular distributed computing solution, and Hive is a data warehouse i[Full Text:]

[Platform] SPARK Data Connection
Author:ayuan0625      Create Time:12-20 10:43      Tag:      Edit:11 Times    |   View:724 Times

Summary:I. DescriptionSpark is a general-purpose fast processing engine for big data. Spark uses Spark RDD, S[Full Text:]

Tree Dataset
Author:ayuan0625      Create Time:10-20 14:25      Tag:      Edit:19 Times    |   View:1559 Times

Summary:I. Overview1) Tree datasets are used to construct tree-like hierarchical relationships, such as hiera[Full Text:]

Stored Procedure
Author:ayuan0625      Create Time:10-20 11:25      Tag:      Edit:23 Times    |   View:7235 Times

Summary:I. Overview1) FineReport can call the stored procedures in mainstream databases, and the result of ex[Full Text:]

TXT and XML Dataset
Author:ayuan0625      Create Time:12-01 10:51      Tag:      Edit:32 Times    |   View:1315 Times

Summary:I. Overview1) Some data are stored in unstructured or semi-structured forms, including TXT and X[Full Text:]

新SSAS插件
Author:ayuan0625      Create Time:04-26 09:16      Tag:      Edit:3 Times    |   View:412 Times

Summary: 1. 概述1.1 应用场景用户工程有时需要使用 SSAS 数据库来解决效率问题,同时前端使用中国式复杂报表展现,因此需要解决两者的连接问题。1.3 功能简介用户[Full Text:]

通用查询取数(适用于ECC6以上版本)
Author:ayuan0625      Create Time:10-20 11:20      Tag:      Edit:22 Times    |   View:326 Times

Summary:1. 概述通用查询较之简单通用查询,增加了表间关联的能力,支持多表查询,但是需要在 ECC6 以上版本使用,且需要在 SAP 系统中添加一个我方提供的 ABAP Function。通用查询相对[Full Text:]

数据集中SQL可全屏插件
Author:ayuan0625      Create Time:04-09 22:45      Tag:      Edit:2 Times    |   View:224 Times

Summary:1. 概述1.1 版本报表服务器版本JAR 包版本插件版本10.02015-12-20V2.49.08.01.2 应用场景在数据库查询数据集中,自带的 SQL 编写区域比较小,在编写和查看比较冗长和复杂[Full Text:]

SQL Server 触发器实例
Author:ayuan0625      Create Time:01-10 14:30      Tag:      Edit:2 Times    |   View:497 Times

Summary:1. 概述1.1 触发器简介触发器( trigger )是 SQL server 提供给程序员和数据分析员用来保证数据完整性的一种方法,它是与表事件相关的特殊的存储过程,它[Full Text:]

内置 FRDemo 数据连接失败
Author:ayuan0625      Create Time:03-03 10:35      Tag:      Edit:0 Times    |   View:197 Times

Summary:1. 问题描述设计器安装目录%FR_HOME%\webroot\help下,内置了一个 SQLite 数据库 FRDemo.db。设计器中也内置了该数据库的数据连接。若用户删除该连接后,重新连接 F[Full Text:]

[设计器]PI数据连接
Author:ayuan0625      Create Time:01-08 11:53      Tag:      Edit:14 Times    |   View:222 Times

Summary:1. 描述PI实时数据库是电力生产中及其常见的数据底层。2. 环境准备2.1 安装 Server安装顺序为:PI-Server、PI-OLEDB-Enterprise、PISQLDAS、PI-JDBC。[Full Text:]

Oracle存储过程相关问题
Author:ayuan0625      Create Time:03-04 10:20      Tag:      Edit:6 Times    |   View:237 Times

Summary:1. 索引序号内容简介文档教程1Oracle分页存储过程的实现以 Oracle 数据库中的 SCOT T用户的 EMP 表为例,编写一个分页存储过程Oracle分页存储过程[Full Text:]

调用SqlServer存储过程报没有返回数据集错误
Author:ayuan0625      Create Time:03-04 10:44      Tag:      Edit:8 Times    |   View:227 Times

Summary:1. 问题描述在 SQL Server 数据库中,若定义的存储过程中包含有 insert/Update 等更新操作时,在设计器中对存储过程进行调用时,会提示没有返回数据集的错误,如下[Full Text:]

SqlServer2005分页存储过程的实现
Author:ayuan0625      Create Time:03-04 10:40      Tag:      Edit:16 Times    |   View:336 Times

Summary:1.描述直接使用数据集可以实现分页查询,下面我们要做的就是如何定义分页存储过程即直接在存储过程中实现分页查询了。2.通用的分页存储过程1.1 存储过程具体代码如下:CREATE pr[Full Text:]

Oracle分页存储过程的实现
Author:ayuan0625      Create Time:03-04 11:06      Tag:      Edit:13 Times    |   View:250 Times

Summary:1. 描述这里以 Oracle 数据库中的 SCOT T用户的 EMP 表为例,编写一个分页存储过程,要求是:输入表名、每页显示记录数、当前页,返回总记录数、总页[Full Text:]

自定义MDX查询
Author:ayuan0625      Create Time:10-20 14:20      Tag:      Edit:15 Times    |   View:406 Times

Summary:1. 描述自定义 MDX 查询是指用户直接在 MDX 语句输入框中输入 MDX 查询语句,然后 FineReport 通过该语句去多维数据库取数。2. 示例在查询方式下拉列表中选择自定义 MDX 查询,[Full Text:]