You design a report by using SQL Server 2008 Reporting Services (SSRS). The report contains a dataset that has 25 million rows of data. The report is rendered by using the HTML rendering extension…

Question

Options

• ASet the PageHeight property to 0.
• BSet the InteractiveHeight property to 100.
• CSet the InteractiveHeight property to 0,
• DSet the PageHeight property to 100.

• A
  5% (1)
• B
  81% (17)
• C
  5% (1)
• D
  10% (2)

Explanation

To control pagination, you specify page-related properties in the report definition. Each rendering extension varies in how it supports page properties and whether it supports pagination altogether. The same report will paginate differently depending on which rendering extension you use to view InteractiveHeight and InteractiveWidth are used by the HTML rendering extension to provide the equivalent of PageHeight and PageWidth. Because the HTML rendering extension dynamically resizes a report to accommodate drilldown, drillthrough, and show/hide features, the report server uses different properties to support pagination on dynamic pages. There is no maximum size for InteractiveHeight. A value of 0 is used to specify infinite height, regardless of the size designator it is paired with. When InteractiveHeight=0, the user can't see a report until all rendering completes.

No community discussion yet for this question.