Dataset- FineReport帮助文档|报表开发|报表使用|学习教程

您当前的位置：
首页 >> Directory >> 隐藏目录（不在目录树中显示，可以搜到和通过链接访问） >> Data Preparation >> Dataset

Dataset

Associated Dataset

Dataset Plugin

SAP Dataset

File Dataset

Stored Procedure

"Dataset" Doc in this DirectoryThere are 32 docs under this directory.Create a Doc in this Directory

Tree Dataset: Author:ayuan0625 Create Time:10-20 14:25 Tag: Edit:22 Times | View:1672 Times; Summary:OverviewApplication ScenarioA tree dataset is used to display hierarchical structures through drop-do[Full Text:]

Associated Dataset: Author:ayuan0625 Create Time:10-20 14:24 Tag: Edit:26 Times | View:1923 Times; Summary:OverviewApplication ScenarioCommon scenario one: Concatenate datasets from different data sources ver[Full Text:]

Report Debugger: Author:ayuan0625 Create Time:06-12 11:52 Tag: Edit:9 Times | View:256 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:424 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:467 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:481 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:666 Times; Summary:OverviewAfter you have successfully established an SAP connection (referring to SAP Dataset Plug[Full Text:]

Excel Dataset (Multiple Sheets): Author:印然 Create Time:11-17 16:49 Tag: Edit:25 Times | View:59614 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:509 Times; Summary:OverviewVersionReport Server   VersionMin JAR Package VersionPlugin VersionFunctional Change11.0[Full Text:]

File Dataset: Author:ayuan0625 Create Time:11-23 15:37 Tag: Edit:23 Times | View:487 Times; Summary:OverviewFile dataset refers to using data from TXT text files, Excel files, and XML files as the data[Full Text:]

Built-in Dataset: Author:ayuan0625 Create Time:10-20 10:56 Tag: Edit:20 Times | View:1848 Times; Summary:OverviewApplication ScenarioBuilt-in dataset refers to creating an original table that is similar to[Full Text:]

Advanced Database Query: Author:ayuan0625 Create Time:11-07 13:44 Tag: Edit:13 Times | View:652 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:501 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:675 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:506 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:2508 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:1968 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:3347 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:3109 Times; Summary:OverviewVersionFineReport VersionFunction Changes11.0/11.0.4Data set preview interface supported copy[Full Text:]

Stored Procedure: Author:ayuan0625 Create Time:10-20 11:25 Tag: Edit:23 Times | View:7279 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:1341 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:331 Times; Summary:1. 概述通用查询较之简单通用查询，增加了表间关联的能力，支持多表查询，但是需要在 ECC6 以上版本使用，且需要在 SAP 系统中添加一个我方提供的 ABAP Function。通用查询相对[Full Text:]

数据集中SQL可全屏插件: Author:ayuan0625 Create Time:04-09 22:45 Tag: Edit:2 Times | View:230 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:543 Times; Summary:1. 概述1.1 触发器简介触发器( trigger )是 SQL server 提供给程序员和数据分析员用来保证数据完整性的一种方法，它是与表事件相关的特殊的存储过程，它[Full Text:]

Oracle存储过程相关问题: Author:ayuan0625 Create Time:03-04 10:20 Tag: Edit:6 Times | View:243 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:229 Times; Summary:1. 问题描述在 SQL Server 数据库中，若定义的存储过程中包含有 insert/Update 等更新操作时，在设计器中对存储过程进行调用时，会提示没有返回数据集的错误，如下[Full Text:]

SqlServer2005分页存储过程的实现: Author:ayuan0625 Create Time:03-04 10:40 Tag: Edit:16 Times | View:367 Times; Summary:1.描述直接使用数据集可以实现分页查询，下面我们要做的就是如何定义分页存储过程即直接在存储过程中实现分页查询了。2.通用的分页存储过程1.1 存储过程具体代码如下：CREATE pr[Full Text:]

Oracle分页存储过程的实现: Author:ayuan0625 Create Time:03-04 11:06 Tag: Edit:13 Times | View:256 Times; Summary:1. 描述这里以 Oracle 数据库中的 SCOT T用户的 EMP 表为例，编写一个分页存储过程，要求是：输入表名、每页显示记录数、当前页，返回总记录数、总页[Full Text:]

自定义MDX查询: Author:ayuan0625 Create Time:10-20 14:20 Tag: Edit:15 Times | View:411 Times; Summary:1. 描述自定义 MDX 查询是指用户直接在 MDX 语句输入框中输入 MDX 查询语句，然后 FineReport 通过该语句去多维数据库取数。2. 示例在查询方式下拉列表中选择自定义 MDX 查询，[Full Text:]