Pentaho Report Designer Summary

1. It can only have one primary query result set.

2. Place the $ {parameter name} parameter in the SQL statement at the bottom of the DATA page in the upper-right corner. The parameter must have a default value. Otherwise, no DATA is displayed in the preview.

3. report Generation Time: $ (report. date, date, MM-dd, yyyy hh: mm: ss)

4 page number $ (PageofPages) but cannot be displayed for specific reasons

5 Chart associated dataset content value source category-column set X axis value-columns set Y axis data

For example, the table has three fields: name, height, and age.

Set "category-column" to "name" and "value-columns" to "height" and "age".

6 Series: series-by-value indicates what bar chart means. series-by-field is extracted from the dataset; auto-generate-series indicates Automatic Generation.

For example, if the above series-by-filed = Name contains five students, the names of these five students are displayed. if auto-generate-series = true, then what are the color of the graph...

In fact, it wants to say that age and height are different colors. When it doesn't know, set it to FLASE. series-by-value = [height, age].

7. Show-labels = show labels 3-D = False in X-axis on the left must be displayed on the BAR.

In this way, the 3-D must be closed before it can be displayed.