Dataset

Dataset Plugin
File Dataset
Stored Procedure
"Dataset" Doc in this DirectoryThere are 29 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:293 Times

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

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

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

Remote Excel Dataset
Author:ayuan0625      Create Time:04-19 09:37      Tag:      Edit:10 Times    |   View:200 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:332 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:234 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:1631 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:1073 Times

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

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

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

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

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

Tree Dataset
Author:ayuan0625      Create Time:10-20 14:25      Tag:      Edit:19 Times    |   View:944 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:1378 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:1180 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:895 Times

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

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

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

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

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

通用查询取数中的函数
Author:ayuan0625      Create Time:10-20 11:22      Tag:      Edit:9 Times    |   View:184 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:124 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:117 Times

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

Oracle分页存储过程的实现
Author:ayuan0625      Create Time:03-04 11:06      Tag:      Edit:13 Times    |   View:130 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:198 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:286 Times

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