Successfully!

Error!

You are viewing 10.0 help doc. More details are displayed in the latest help doc

Design Ideas

I. Description

To use the FineReport designer to design a template, you first need to understand the idea of making the FineReport template, and follow the idea to understand all the functions in the FineReport report.

The FineReport report production process is as follows:

1.png


1) Create a new data connection: Before making a template, first make sure that the designer knows the database type, database address, user name and password for accessing the database, and then create a new data connection in the FineReport designer to establish the interaction between the database and the designer bridge;

2) Create a new template and dataset: After the data connection is created, you need to add a template. The data connection is used for the entire project. It does not actually take the data out of the database, so it needs to be in a specific template. Create a new dataset and fetch data from the database through a data connection;

3) Template design: After the data preparation is completed, the template design is carried out. The template design is the most important part of the FineReport learning process. We divide the template design into four parts: report design, parameter design, chart design and report design. , These four parts are the main ways to use the FineReport template. The report design is pure data display, the parameter design is dynamic query data, the chart design uses charts to display data, and the report design is to enter data and write the data into the database. , According to the actual situation, determine which way to use, or which ways to use in combination;

4) Template preview: After the template design is completed, save the template under the project directory to preview and view the effect of the template on the Web.

II. Index

Serial NumberContentIntroductionHelp Document
1Data ConnectionEstablish an interactive bridge between the database and the designerData Connection Overview
1.1JDBC Connect DatabaseTake the connection to Oracle database as an example to introduce the operation steps of connecting to the database in JDBC mode[Designer] JDBC data connection
1.2JNDI Connect DatabaseDefine data connection through JNDI[Designer] JNDI data connection
1.3XMLA Data ConnectionConnect with multidimensional database through XMLA data connectionCube plugin
1.4SAP Data ConnectionFineReport makes the SAP data connection function a plug-in, adds SAP data connection type, and adds SAP data set typeSAP Dataset Plugin
2DatasetDataset refers to the data display set that is taken out from the database and can be directly applied to the template designDataset
2.1Database QueryFor the database tables in the data source, directly use SQL statements to select the required data fieldsDatabase Query
2.2Built-in DatasetCreate a new original table similar to a database table, which can be used as a template data source to design reportsBuilt-in Dataset
2.3File DatasetRefers to using the data in TXT text files, Excel files and XML files as data sets, and displaying them in the data set in a two-dimensional table structureFile Dataset
2.3.1TXT Dataset:It means that the data source is a series of TXT text filesTXT and XML Dataset
2.3.2Excel Dataset:It means that the data source is a series of XLS filesExcel Dataset
2.3.3Remote Excel Dataset:Access the JSP page through URL, and use the corresponding Excel file as a datasetRemote Excel Dataset
2.3.4XML Dataset:Means that the data source is a series of XML filesTXT and XML Dataset
2.4SAP DatasetFirst establish an SAP data connection, and establish an SAP data set through the data connectionSAP Dataset
2.4.1 Custom access:Is to directly call ABAP Function to get dataCustom Access
2.4.2 Simple general query access:Through the open SQL statement, read certain columns from a table and list some conditions that the data needs to meetSimple general query access
2.4.3General query access:Compared with simple general queries, general queries increase the ability to associate between tables and support multi-table queriesGeneral query access
2.4.4Functions in general query access:Detailed description of the creation process of EXTRACT_TABLE_DATA and problem solvingFunctions in general query access
2.5Stored ProcedureThe stored procedure is to directly use the stored procedure as a data set, without querying in the database but to call the stored procedureStored Procedure
2.6Multidimensional databaseOn the basis of XMLA data connection, create a new multidimensional database XMLA datasetMultidimensional database
2.6.1Simple general query:Refers to FineReport directly displaying the multi-dimensional CUBE structure after connecting to the multi-dimensional database through XMLASimple general query
2.6.2Custom MDX query:Means that the user directly enters the MDX query statement in the MDX statement input box, and FineReport uses the statement to fetch data from the multidimensional databaseCustom MDX query
2.7Associated DatasetFilter and fetch data from different data sources; access different databases; use different data sources to form a datasetAssociated Dataset
2.8Tree DatasetBind the tree dataset for the widget, and the tree hierarchical structure will be automatically generated when viewed on the Web sideTree Dataset
3Template Design TypesFineReport template design mainly includes three template design types: normal template design, dashboard design and aggregate report designTemplate Design Types
3.1Normal Report DesignNormal report design is divided into four parts: report design, parameter design, chart design and data entry designNormal Report Design
3.2

Dashboard Design Mode

Realize the self-adaptation of the mobile terminal and the linkage between the components through the dashboardDashboard Design Mode
3.3Aggregate Report DesignAggregated report refers to a report that contains multiple modules, each of which is similar to a separate report or a chart, and the blocks are relatively independent and do not affect each otherAggregate Report Design
4Template PreviewFineReport has a variety of preview modes: Pagination Preview, Data Entry Preview, New Data Entry Preview, Data Analysis, Mobile Preview~Template Preview
4.1Pagination PreviewThe default preview mode of FineReport is generally used when you only need to view report data for analysisPagination Preview
4.2Data Entry PreviewRefers to the template used to fill in the data in the web preview, generally used when you only need to enter and modify the dataData Entry Preview(op=write)
4.3Data AnalysisData analysis mode can also view reports, but it can preview the report results without pagination and online analysis: sorting, secondary filtering, etc.Data Analysis(op=view)
4.4New Data Entry Preview

New Data Entry Preview, new style widgets, fast loading speed, and pagination loading

New Data Entry Preview(op=write_plus)
4.5Mobile PreviewDisplay the report directly on the mobile phone by scanning the code, allowing users to intuitively see the actual effect of the current design templateMobile Preview(op=mobile)
4.6Dashboard PreviewDashboard Preview is for the design mode of dashboardDashboard Preview


Attachment List


Theme: Report Design
Already the First
Already the Last
  • Helpful
  • Not helpful
  • Only read

Doc Feedback