The production of dry report list

General washing Ah, if SQL to find more than one data, the way to use the table extension in a table (horizontal, vertical); The current requirement is to make a list of reports. For example, if 3 data is detected, the preview will have 3 different reports in the same format. One of the following;

Figure One: Ideal

Here to give a similar simple demo, the implementation of the list effect; the steps are as follows: Four

One: In the Operation menu of the dataset, select the value, drag the DS1 element to the cell then cell (shown in Figure II).

Second: The method of appeal, the data into C2-C5, D2-d5 cell.

Three: A1 for select query statement, set A1 to not visible, b column exists because to divide the border, if there is no column B, the border division is more troublesome.

Figure II

Might

Figure IV:

The production of dry report list