Learning ReportLite
Chapter 1 Installation & Trial
- 1.1 Download & install
- 1.2 Create row-wise reports through wizard
- 1.3 Expansion & expression
- 1.4 Report zone
Chapter 2 Appearance & format
- 2.1 Border, font and color
- 2.2 Display format and display value
- 2.3 Conditional format
- 2.4 Card-style report
- 2.5 Picture
- 2.6 Exercises
Chapter 3 Grouped report
- 3.1 Create grouped reports through wizard
- 3.2 Common grouped reports
- 3.3 Structure of a grouped report and master cell
- 3.4 Computations on a grouped report
- 2.5 Picture
- 3.5 Exercise
Chapter 4 Crosstab report
- 4.1 Create crosstab reports through wizard
- 4.2 Common crosstab reports
- 4.3 Structure of a crosstab report & master cell
- 4.4 Computations on a crosstab report
- 4.5 Exercise
Chapter 5 Multizone association
- 5.1 From crosstab to zones
- 5.2 Coexistence of expanding and static areas
- 5.3 Equality of row and column
- 5.4 Make a master-sub table through multizone association
- 5.5 Exercise
Chapter 6 Inter-cell computations
- 6.1 Calculate proportion, running total & simple YOY growth
- 6.2 Calculate ratio & complex ratio
- 6.3 Calculate conditional aggregate, ranking & complex YOY growth
- 6.4 Get ordinal number in one group/across groups
- 6.5 Exercise
Chapter 7 Irregular sorting & grouping
- 7.1 Incomplete grouping
- 7.2 Sorting & grouping by the specified order
- 7.3 Grouping by segment
- 7.4 Grouping by specified conditions
- 7.5 Exercise
Chapter 8 Parameters & scripts
- 8.1 The concept & uses of parameters
- 8.2 Dynamic parameters
- 8.3 Reports with dynamic columns
- 8.4 Variables & scripts
- 8.5 Exercise
What is ReportLite
ReportLite: Addressing all grievances in report production.
One template, multiple uses, eliminating redundant labor.
One template, multiple uses, eliminating redundant labor.
ReportLite is a desktop reporting tool that uses Excel like operation methods, supporting multiple data files as data sources and the generation of various format reports. The operation is simple and the settings are flexible, which can significantly improve the efficiency of report making.
When & Where to use
Large number of reports， heavy workload
When converting some data files (xls, csv, etc.) into the required report format, even if the report is very simple, the production of a large number of tables takes too much time and is very cumbersome.
When the data changes, the report needs to be remade
After the original data changes, it is necessary to manually remake the report.
The format undergoes significant change
Reports need to present data in different formats, such as converting rows to card format.
Weak grouping and cross statistical scenarios
The number of rows and columns in grouping and cross statistical reports is not fixed, and the report needs to be scrape together manually. It is troublesome to do only one time.
The format of the pivot table is too rigid and we can only view the data.
Difficult to perform complex calculations
Excel can group and summarize data through a pivot table, but slightly more complex calculations are difficult to implement. For example, based on a student grade table, students with average scores below each subject and students with total scores below average are listed separately.
Poor data association ability
The vlookup function can achieve data association, but for summary data, it is necessary to first group it through a pivot table. If multiple columns need to be fetched, the function needs to be written multiple times, which is cumbersome to operate. It is even more difficult to achieve for reports with an unfixed number of columns.
More Difficulties
There may also be some special grouping intervals during data aggregation and statistics, such as grouping according to numerical intervals (age group, numerical range, etc.), or artificially dividing some grouping rules, etc.
How to use
Application diagram
Report Design Process
Select a Data File
Set the data required in the report through the wizard, and when multiple data files are needed in the report, you can also choose from here.
Data mapping
Set corresponding data mapping relationships in cells according to report requirements
- The grouping, summation, counting, and other settings of data can be generated through formula wizards or mouse dragging
- The grouping subtotal, total, and other data summary intervals are determined by merging multiple cells
Format adjustment
Adjust the report format to make the presentation of the report more aesthetically pleasing
- Adjust the formatting and beautify the presentation of the report through setting the font color, fill color, border, and alignment of cells
- Save the report template after completing report settings
Preview results, export files
Preview and view the report results, which can be converted into formats such as xls, doc, PDF, HTML, txt, etc.
Replace data file
The source data file needs to be replaced. Open the already set report template and select the desired data file. The template does not require any other modifications. Save as a new report template file.
Preview results, export files
Features
Zero learning cost
Provide Excel like spreadsheet tools that maintain consistency for regular operations with Excel, and can implement most tasks without the need for specialized learning, making it simple and easy to use.
Easy to create reports, no matter how many reports to make
Wizard based report generation, simple and fast
By extending data through report formulas, the template only needs to set the style of the extended rows, making it easy to operate.
Report templates can be reused, and for reports with similar formats, simply change the data file and adjust the format, resulting in high development efficiency.
Changing source data is simple and convenient
To replace a data file for an existing report, simply select a new data file; even if the data changes, the report template does not need to be modified.
Data files can be switched between different formats, such as replacing xls with txt.
Free format reports are more flexible
The sheet content can be laid out arbitrarily through a flexible expanding model.
The results can be dynamically generated based on the amount of data
Meet the needs of various tables
Powerful grouping and cross statistical ability, flexible style setting
Reports support multi-dimensional grouping, cross and summary statistics. The header cell merging, diagonal setting, form and style settings are flexible and diverse, and the display effects are more abundant.
More powerful complex-computing capability
Reports can be re-filtered and re-calculated based on the summarized data, making complex calculations easier to process. Of course, the calculation function is not limited to this, the change of data also makes the position of row-or-column results altered. It can achieve some dynamic cross-row operations, such as the same period ratio, proportion, ranking, etc.…
Multi source associated zone is simple and efficient
Multiple data files can be imported into the report
Through functions to associate and display data, it only needs to be set once
Grouping and aggregation before join is more efficient
Multiple dimensions dynamically expand based on its own data without affecting each other
More flexible grouping and statistics
Provide more flexible grouping methods, which can group data according to interval, numerical range, or manually specified grouping interval, etc.
You can also perform secondary statistics based on the aggregated data, such as listing the top three states in sales
Flexible expanding model
Simple
Expanding based on the data in the data file through the formula of cells. When setting the template style, only the row and column where the formula is located need to be operated, rather than selecting a whole piece of data in Excel. The operation is simple.
Easy
Extend based on data file, and there is no need to repeatedly adjust templates for changes in data
Flexible
Free format reports can also be expanded in chunks based on the amount of data
Efficient
Aggregation before association for multi file association leads to higher efficiency; and expansion of multi areas do not affect each other.
Generate multiple types of files
The results can generate multiple file formats: xls, doc, PDF, HTML, txt ......
The generated HTML can be easily embedded into other web pages
