"Data Preparation" Doc in this DirectoryThere are 68 docs under this directory.Create a Doc in this Directory
SAP Dataset
Author:ayuan0625      Create Time:10-20 11:42      Tag:      Edit:19 Times    |   View:292 Times

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

SAP Dataset Plugin
Author:ayuan0625      Create Time:10-20 10:02      Tag:      Edit:55 Times    |   View:404 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:252 Times

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

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

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

Advanced Database Query
Author:ayuan0625      Create Time:11-07 13:44      Tag:      Edit:13 Times    |   View:91 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:814 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:197 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:331 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:232 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:1630 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:1069 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:286 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:552 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:269 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:1429 Times

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

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

Summary:OverviewVersionFineReport VersionJAR Package Date11.0/Application ScenarioBigQuery is a fully-managed[Full Text:]

New SAP BW Dataset Plugin
Author:ayuan0625      Create Time:03-23 15:47      Tag:      Edit:59 Times    |   View:831 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:350 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:1965 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:367 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:1747 Times

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

[Platform] PostgreSQL Data Connection
Author:ayuan0625      Create Time:12-18 16:48      Tag:      Edit:14 Times    |   View:1836 Times

Summary:I. DescriptionPostgresql is a powerful open source database system. After more than 15 years of activ[Full Text:]

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

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

Connect to Google sheets
Author:frenadmin1234      Create Time:09-27 15:55      Tag:      Edit:4 Times    |   View:841 Times

Summary:I. OverviewUse Google Sheets files as a report data source, either as a template dataset or as a[Full Text:]

[Platform] MySQL8 Data Connection Plugin
Author:frenadmin1234      Create Time:01-17 12:01      Tag:      Edit:1 Times    |   View:501 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:1293 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:7073 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:266 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:469 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:799 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:353 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:370 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:404 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:435 Times

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

MongoDB
Author:ayuan0625      Create Time:02-02 11:45      Tag:      Edit:32 Times    |   View:925 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:1075 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:868 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:1280 Times

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

[Designer] ODBC data connection
Author:ayuan0625      Create Time:10-30 15:43      Tag:      Edit:25 Times    |   View:1057 Times

Summary:I. Overview1. Application scenariosFineReport10.0 has built-in JDK1.8 or JDK 11, which do not support[Full Text:]

Data Connection Overview
Author:ayuan0625      Create Time:10-20 09:55      Tag:      Edit:34 Times    |   View:2665 Times

Summary:I. Overview1. Application scenariosBefore making reports, the first need to define the data source, t[Full Text:]

[Designer] JDBC data connection
Author:ayuan0625      Create Time:10-20 09:57      Tag:      Edit:73 Times    |   View:1186 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:492 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:534 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:625 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:488 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:940 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:1372 Times

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

Embedded Dataset
Author:ayuan0625      Create Time:10-20 10:56      Tag:      Edit:19 Times    |   View:1179 Times

Summary:I. Overview1) If you intend to preview template data normally on a client without connecting to a dat[Full Text:]

TXT and XML Dataset
Author:ayuan0625      Create Time:12-01 10:51      Tag:      Edit:32 Times    |   View:892 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:203 Times

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

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

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

数据集中SQL可全屏插件
Author:ayuan0625      Create Time:04-09 22:45      Tag:      Edit:2 Times    |   View:111 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:136 Times

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

内置 FRDemo 数据连接失败
Author:ayuan0625      Create Time:03-03 10:35      Tag:      Edit:0 Times    |   View:103 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:134 Times

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

通用查询取数中的函数
Author:ayuan0625      Create Time:10-20 11:22      Tag:      Edit:9 Times    |   View:182 Times

Summary:1. 描述FineReport 提供了 EXTRACT_TABLE_DATA 的源码及后续的数据集使用过程。本篇对 EXTRACT_TABLE_DATA 的创建过程及出现的问题解决进行详细说明[Full Text:]

Oracle存储过程相关问题
Author:ayuan0625      Create Time:03-04 10:20      Tag:      Edit:6 Times    |   View:123 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:128 Times

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

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

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

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

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

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

Summary:1. 描述简单通用查询,即类似 SQL 语句一样,从某张表中读取出某些列,并列出数据需要满足的一些条件,不同于 SQL 语句的是,简单通用查询并不是全部用语句实现,读取表跟列是可视化界面选择,[Full Text:]

自定义取数
Author:ayuan0625      Create Time:10-20 11:15      Tag:      Edit:10 Times    |   View:170 Times

Summary:1. 描述新建 SAP 数据集时,默认的为自定义取数方式,使用自定义取数,就是直接调用 ABAP Function 获取数据。2. 示例2.1 函数选择从定义上看,自定义取[Full Text:]

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

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