Common Data Processing Methods

"Common Data Processing Methods" Doc in this DirectoryThere are 23 docs under this directory.Create a Doc in this Directory
Data Deduplication
Author:ayuan0625      Create Time:04-04 22:20      Tag:      Edit:6 Times    |   View:457 Times

Summary:OverviewProblemYou want the duplicated data to appear only once during data processing, as shown in t[Full Text:]

Zero Supplement and Removal
Author:ayuan0625      Create Time:04-04 21:28      Tag:      Edit:8 Times    |   View:544 Times

Summary:OverviewProblemSometimes zero supplement or zero removal is required when you process numerical data,[Full Text:]

Handling Zero Divisors and Zero Dividends
Author:ayuan0625      Create Time:11-03 15:12      Tag:      Edit:10 Times    |   View:229 Times

Summary:OverviewProblemWhen designing reports that involve division operations, you may encounter scenarios w[Full Text:]

Adding of Data from Two Datasets
Author:ayuan0625      Create Time:11-11 10:16      Tag:      Edit:10 Times    |   View:567 Times

Summary:OverviewProblemYou can define multiple datasets in a report and extract the required data from each r[Full Text:]

Importing a Font to the Designer
Author:ayuan0625      Create Time:11-03 15:06      Tag:      Edit:15 Times    |   View:1007 Times

Summary:OverviewFor some projects, the file format is very important with strict font requirements. However,[Full Text:]

Long cell content display with "..." and tooltip
Author:ayuan0625      Create Time:02-28 15:32      Tag:      Edit:23 Times    |   View:619 Times

Summary:I. DescriptionIn practical applications, some cells may have more content. How can the ellipsis (...)[Full Text:]

Card flip report
Author:ayuan0625      Create Time:04-16 20:27      Tag:      Edit:5 Times    |   View:586 Times

Summary:I. DescriptionIn the report design about pictures, the line report and the card column report are too[Full Text:]

Substitute by string sections
Author:ayuan0625      Create Time:11-01 16:47      Tag:      Edit:5 Times    |   View:474 Times

Summary:I. Overview1. Problem descriptionSometimes our database field stores the content of multiple characte[Full Text:]

Open PDF version of report with URL
Author:ayuan0625      Create Time:11-03 15:08      Tag:      Edit:11 Times    |   View:674 Times

Summary:I. Overview1. Problem descriptionAdding the parameter &format=pdf after the URL of the preview te[Full Text:]

Control display times of data through fields
Author:ayuan0625      Create Time:11-03 15:04      Tag:      Edit:14 Times    |   View:527 Times

Summary:I. Overview1. Expect effectFor cargo transportation companies, the database data is as follows.[Full Text:]

Only sum the first occurrence of the value
Author:ayuan0625      Create Time:03-28 12:00      Tag:      Edit:2 Times    |   View:499 Times

Summary:I. Overview1. Problem descriptionFor the recurring indicators in the template, sometimes we only want[Full Text:]

Progress bar using bar chart
Author:ayuan0625      Create Time:05-19 20:47      Tag:      Edit:5 Times    |   View:686 Times

Summary:I.DescriptionGraphical display of data (progress bar/level) and Cell progres[Full Text:]

Determine whether it is empty
Author:ayuan0625      Create Time:11-11 10:14      Tag:      Edit:7 Times    |   View:548 Times

Summary:I. DescriptionHow to judge whether the parameter is empty, or whether the value of a cell is empty, e[Full Text:]

Display (1) in cell
Author:ayuan0625      Create Time:11-11 10:15      Tag:      Edit:6 Times    |   View:469 Times

Summary:I. DescriptionIn the template design, enter (1) in the cell, the default display is -1. How to make t[Full Text:]

Different styles within one cell
Author:ayuan0625      Create Time:11-11 10:14      Tag:      Edit:8 Times    |   View:455 Times

Summary:I. DescriptionMultiple data and texts are displayed in a cell by formulas, hoping to change the style[Full Text:]

Dataset execution timepoint
Author:ayuan0625      Create Time:11-11 10:04      Tag:      Edit:6 Times    |   View:485 Times

Summary:I. DescriptionQuery the database table through the dataset. When there is a large amount of data, it[Full Text:]

Scroll bar within cell
Author:ayuan0625      Create Time:11-11 10:12      Tag:      Edit:11 Times    |   View:538 Times

Summary:I. DescriptionWhen there is too much content in a cell, when previewing the report, the cell will aut[Full Text:]

Cell content wrap display
Author:ayuan0625      Create Time:11-11 10:03      Tag:      Edit:14 Times    |   View:536 Times

Summary:I. Overview1. Problem descriptionWhen the FineReport cell displays the content, it cannot wrap displa[Full Text:]

Specified data list display under grouping
Author:ayuan0625      Create Time:12-27 18:19      Tag:      Edit:3 Times    |   View:718 Times

Summary:I. DescriptionThe grouping function is often used when designing reports. The default grouping is tha[Full Text:]

Issue of scroll bar occluding data
Author:ayuan0625      Create Time:03-21 15:22      Tag:      Edit:3 Times    |   View:442 Times

Summary:I. DescriptionWhen previewing the report, the left and right scroll bars block the bottom row of data[Full Text:]

Display data without pagination
Author:ayuan0625      Create Time:11-03 15:21      Tag:      Edit:15 Times    |   View:2158 Times

Summary:I. OverviewWhen the report content row height and column width exceed the paper size, the rows and co[Full Text:]

Anchor point realizes to jump to specified row
Author:ayuan0625      Create Time:11-08 20:03      Tag:      Edit:6 Times    |   View:481 Times

Summary:I. Overview1. Expected effectSometimes the report has a large amount of data and is displayed without[Full Text:]

Subscripts on expanded data
Author:ayuan0625      Create Time:06-20 11:46      Tag:      Edit:2 Times    |   View:522 Times

Summary:I. Overview1.1 Problem DescriptionSubscripts need to be set rich text or realized by two cells, but i[Full Text:]