Demand: 2 fields in the database: category and quantity. Category Number 1 100 2 200 3 300 4 200 But when displayed in the report, you need to display as Category 1 Category 2 Category 3 Category 4100 200 300 400 The following is how the appropriate number should be designed when designing reports, and later It may increase the new category and require fields to be dynamically added. Thank you for your answer! -------------------------------------------------- -------------- Solution: 1, "Details" section design: portrait two fields ... Category Number
2, use "multiple formatting" ... Multi-column you don't have to print data down the page, you can set multiple columns to make the data flow between columns.
Create a multi-rated statement to open a report to be set to multiple columns. On the Report menu, click "Section Expert". Tip: Another way to complete this task is to click the "Section Expert" button on the Expert Tools toolbar.
In the "Section Expert", highlight "Details" and select "Multi-column formatting". A "layout" tab will be added to the "Festival expert".
Click the Layout tab and set the desired column "width". The width of the paper should be taken into account at the same time as the column width is determined. For example, if there are three fields in the Details section, you account for four-inch wide space, then column width should be limited to four o'clock in order to see all field information.
Set the "horizontal" and / or "vertical" spacing that wants to retain between each record in the column. Select one direction in the Print Direction area. If the report is being formatted contains grouping, select "Formatting with multiple columns". Click OK. When previewing the report, you will see only the field headings of the first column. To display the field title of the second column, insert a text object.
3, set the "lower margins" in the "margin", so that the page only shows a line ...
