Pro SQL Server 2012 Reporting Services

(sharon) #1

CHAPTER 6  BUILDING REPORTS


Figure 6-10. Report with navigation pane from document map

The EmployeeServiceCost_DocumentMap.rdl report in the Pro_SSRS project includes a document
map.

 Note Adobe Acrobat views document mapping as bookmarks when the report is rendered in PDF. Bookmarks
in SSRS perform a different function altogether. They are embedded within the report, and report items are
assigned bookmark links.

Visibility


Another feature of SSRS is the ability to show or hide areas of the rendered report based on user input,
results returned in a dataset or based on some predefined logic. Often users want to see only summary
information on a report, but would like to be able to drill into the summary data to see the detail
information if necessary. Report designers might make two reports, a summary and a detail report,
which have to be updated and maintained separately. These reports are often based on the same query.
Fortunately, SSRS’s ability to show or hide report data does away with the need to create separate
reports. The visibility properties for report items control which report items are shown or hidden.
Free download pdf