Report Design Fundamentals

Every report has three main parts: a body, header, and footer (you can view the header and footer and control their visibility settings by right-clicking an outer edge of the report on the design surface). A report body can be a collection of static controls, such as text boxes and lines, but most useful reports contain at least one data-bound control, meaning that the control is wired up to a dataset; its contents usually repeat in some fashion relative to the number of rows in the dataset. Notice that the header and footer cannot contain data-bound controls. Data-bound controls themselves may contain either data-bound or non–data-bound controls.

Table 48.4 summarizes all the controls in the Toolbox, with their data-binding ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.