Shulou(Shulou.com)06/03 Report--

In our daily life or work, we often see such small cards recording the basic information of a commodity or a person. Like a business card, it looks simple and clear. In the database, these information are actually dense records, and it is easy to misread them directly, as shown in the following figure:

So how can we present this information in the form of cards, one card at a time? Next, let's take a look at how to use the report artifact-drying reports to generate such reports simply and easily:

First (the first step), open the report designer, connect to the data source, create a blank report, and set up the dataset. The SQL statement we use here is as follows:

SELECT employee. Name, employee. Employee ID, employee. Position, employee. Date of employment, employee. Address, employee. Date of birth, employee. Zip code, employee. Photo FROM employee

(step 2) fill in the expression in the blank report, as shown in the figure:

(step 3) then set the left nominative of A1Magic A2Magic A3Magazine A4Magee A5 to B2, so that a simple card report is designed, then click Save, and finally view the preview, the effect is as follows:

Note: leave a blank row below and on the right of the report settings area, and set the nominative of the lower row to B2, so that there will be a gap rather than a close connection between the cards during the preview, as shown in the image above.

At this point, a card report is easily done, so let's review the problems encountered and the skills to solve them:

1. Setting of left nominative

[skill] set the left nominative of the cell in the property bar-extension-left nominative.

two。 Photo field rendering

[skill] right-click the cell-picture-expression set the picture expression

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.