SQL Server Rep Services => Working with Items in a Report

Working with Items in a Report A report in Reporting Services uses report items to display data and graphical elements. In addition to the data regions table, matrix, list, and chart, report items also include text box, image, line, rectangle, and subreport. Text Box Text boxes display all text data in a report. A table or matrix cell include a text boxes by default to display data. Text boxes can be placed anywhere on a report and can contain labels, fields, or calculated data. You use expressions to define data in text boxes. Image Images display binary image data in a report. An image report item can use a URL to display an image stored on a Web server, display embedded image data, or display an image from binary data in a database. Reporting Services supports .bmp, .jpeg, .gif, and .png files. Line Lines are graphical elements that you can place anywhere on a page. A line is defined with a start and end point and can have a number of styles (for example, weight and color) assigned to it. A line has no data associated with it. Rectangle Rectangles can be used in two ways: as a graphical element and as a container for other report items. When you place report items within a rectangle, you can move them with the rectangle. This is useful for keeping numerous text boxes and other items together in a report. Subreport A subreport is an item in a report that points to another report on the report server. The report that the subreport refers to can be a full report that can also run on its own, or it can be a report that looks best when embedded within the main report. When you define a subreport, you can also define parameters to filter data in the subreport. When deciding whether to use a subreport, you may want to consider using a data region instead. Because the report server processes each instance of a subreport as a separate report, performance can be an issue. Data regions provide much of the same functionality and flexibility as subreports, but with better performance. Item Properties All items in a report, including groups, table and matrix columns and rows, the above items, and the report itself, have properties associated with it. These properties govern the appearance and behavior of the item. For information about the properties associated with an item, see the documentation for that item. Regards Mitesh Mehta