Subreport is used to embed another report inside the body of a main report. It allows to customize the subreport properties along report path, parameters.
Basic Settings category contains
Set Parameters properties.
Reportproperty can be used to specify the report path of the subreport. Refer Report Path section to set report path to this property.
Set Parametersproperty can be used to pass parameters from the main report to the subreport. Refer Set Parameters section to set parameters to the subreport.
Appearance property can be used to improvise the style of subreport layout. Border style, color, width properties are displayed under the
Border properties are used to add or customize the border around a subreport item to visually separate items in the report design. To set border properties to the subreport item using properties panel refer Border Properties section.
No Rows property is used to display static text when dataset results with a empty or zero rows.
Supported font family names are listed in the drop-down list, choose the required font family from the drop-down list to change the
Font Family of the no rows message.
To set font color for the no rows message, click on the color palette icon and choose the required color in the
Font size property allows you to increase the size of the text in the no rows message. You can increase the font size using the numeric drop-down highlighted in below snap.
To change font style of the no rows message, choose the required font style in the
Font Style drop-down list. Following are the supported font styles:
To change the font weight of the no rows message, choose the required type of font weight property from the drop-down list.
Provide the required text in the message textbox, the given message will be displayed to the user when dataset results with empty or zero rows.
To customize the message appearance, open the
Text decoration property sets the appearance of decorative lines on text.
Format property is used to format the given text in the no rows message. Refer Format section to represent the text in Numbers, Currency, Date, Time, Scientific, Percentage and Custom formats.
Line height property is used to increase space between lines in given message. Increase or decrease the values in numeric dropdown to set the line height for no rows message.
Padding property is used to provide space around the no rows message content. Increase or decrease the values in numeric dropdown to set the left, right, top and bottom padding to the no rows message.
Text align property is used to set the horizontal alignment of a no rows message. The text can be aligned in left, right, or center position. Choose the required text align property from the drop-down list as shown below.
Vertical Align property is used to set the vertical alignment of a no rows message. Choose the required vertical align property from the drop-down list as shown below.
Writing mode property represent the direction of the no rows message along
Rotate270. Choose the required writing mode property from the drop-down.
Horizontal: Text will be horizontal, read left to right.
Vertical: Text will be vertical, read top to bottom.
Rotate 270: Text will be vertical, read bottom to top.
All the customizations will be applied to the no rows message container while previewing the report.
Position property is used to set the width, height, left and top position of the subreport item in the report design. To handle these properties using properties panel refer Position section.
Data element can be used to control visibility of a report item when exporting the report in XML format. The Data element properties are listed in the properties panel, under the
Data Element category.
You can assign a custom name for the subreport element using the
Name field. The subreport will be exported with the provided name.
Note: The name cannot contain spaces, and it must begin with a letter followed by letters, numbers, or the underscore character (_).
On exporting the report, the visibility of the subreport can be controlled using the
Output property. Choosing the following options for the
Output property will perform the respective operations:
Visibility property is used to conditionally show or hide the subreport report item on report preview or export action. To set visibility of subreport item using properties panel refer Visibility section.
Keep together property is used to display the subreport item in a single page, on report preview or export action. Enable the checkbox to keep the content in single page or it will span across multiple pages.
This property can be used to set the values for subreport custom properties. To create and assign values for custom properties using properties panel refer Custom Properties section.
A document map is a navigational feature that displays a separate side pane with set of navigational links in hierarchical structure when you view a report. A user can click the content in the list, to navigate to the report page that displays that item. Refer Document Map section to configure document map in the report design.
You can set the static or dynamic text as value for document map property. To set and reset dynamic text, refer Set Expression and Reset Expression section.
Bookmark links allows the users to navigate to different parts of a SSRS report. You can add bookmarks to each textbox, image, table or chart or to the unique group values displayed in a tablix which can direct the users to specified locations in the report. The value of bookmark property can be your own strings or an expression. Refer Bookmark section to configure bookmark in the report design.
You can set the static or dynamic text as value for bookmark property. To set and reset dynamic text, refer Set Expression and Reset Expression section.
Tooltip property can be used to display informative text or value, when the user hovers over on the report item in report preview. To set tooltip for sub-report item using properties panel refer Tooltip section.
Properties panel allows you to specify expressions that can include two or more data fields and various functions. To set expressions for the report or report item properties refer Set Expression section.
Reset the property value and expression, refer Reset Expression section.
Few properties of the subreport report contains nested properties. To open and handle nested properties, refer Advanced Properties section.
Refer Design rdl report using subreport section to learn how to link report, set parameters, to customize the subreport properties.