توصيف حقل فى تقارير Reportviewer

Create a report and a dataset that returns two fields for each row. For the purposes of this example, you can use the following query to retrieve two fields from the AdventureWorks sample database:

other

Copy

Select distinct Lastname, Firstname from Person.Contact Order by Lastname

# Set report properties to specify the number of columns, margins, and padding. In this example, specify 2 columns for the report. To view instructions about adding columns to a report, see How to: Specify Multiple Columns in a Report (Report Designer).

# From the Toolbox, drag a List onto the report design surface.

# Position the List so that it is at the top of the report. This removes extra whitespace from the report and ensures that both columns on the page are aligned with each other when the report is rendered.

# Drag a Table onto the List. A Table is useful because it provides a uniform arrangement for fields in repeating rows of data, but you can use any kind of data region that gives you the report layout you are looking for.

# Drag the Lastname and Firstname fields from the dataset onto the Details row in the table.

# Delete the Footer row and the third column.

# Resize the page layout to remove extra whitespace and to bring the second column into view. The report layout should look similar to the following image:

Shows multi-column report layout

When you define more than one column in a report, Report Designer calculates the width of the columns in the report, the width of the report, and the width of the space between columns based on the number of columns. It then displays a decreased design surface so that you can place report items on the report that will fit within the column. Note that the layout of the entire report must be placed on the decreased design surface. Additional columns are displayed so that you can verify that the number of columns you defined will fit the page size dimension. You can adjust page size, padding, and margins to fit more columns on the page.

# Create a group expression on the List and specify page breaks to force data onto the next column.

1. Right-click the List and select Properties.

2. In List Properties, on the General tab, click Edit Details Group.

3. In the Grouping and Sorting Properties dialog box, on the General tab, type an expression to limit the number of rows that appear in each column. In this expression, twenty rows are allowed in each column:

other

Copy

=Ceiling(RowNumber(Nothing)/20)

4. Click Page break at end.

5. Click OK to close the Grouping and Sorting Properties dialog box. Click OK again to close the List Properties dialog box.

# Preview the report, and then export it to PDF or IMAGE output.