nerdexam
Microsoft

70-466 · Question #109

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1. Table is initially visible but

The correct answer is B. For the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.. SSRS supports interactive visibility toggling by configuring a report item's visibility to be controlled by a separate textbox, letting users show or hide Table1 without rerunning the report.

Build reports

Question

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1. Table is initially visible but the user must be able to choose when to hide it. You need to develop the report to meet the requirement. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

  • AAdd a parameter to the report so users can choose the display state of Table1.
  • BFor the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.
  • CConfigure Textbox1 to drill through to rerun the report to toggle the display of Table1.
  • DFor the properties of Table1, configure the Display can be toggled by this report item option to use Table1.

How the community answered

(40 responses)
  • A
    8% (3)
  • B
    88% (35)
  • C
    3% (1)
  • D
    3% (1)

Why each option

SSRS supports interactive visibility toggling by configuring a report item's visibility to be controlled by a separate textbox, letting users show or hide Table1 without rerunning the report.

AAdd a parameter to the report so users can choose the display state of Table1.

A report parameter controls visibility only at render time when the report is first executed and does not allow the user to interactively toggle Table1's display state after the report has already loaded.

BFor the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.Correct

Configuring the 'Display can be toggled by this report item' property on Table1 to reference Textbox1 implements SSRS's built-in toggle feature, which renders Textbox1 with a clickable expand/collapse indicator. This allows users to interactively show or hide Table1 after the report renders without requiring a parameter change or a report rerun, directly satisfying the requirement.

CConfigure Textbox1 to drill through to rerun the report to toggle the display of Table1.

A drill-through action navigates to another report or reruns the current report with different parameters; it does not toggle the in-place visibility of a report item within the current rendered report.

DFor the properties of Table1, configure the Display can be toggled by this report item option to use Table1.

SSRS requires the toggle source and the controlled item to be different report items, so Table1 cannot reference itself as its own toggle control.

Concept tested: SSRS interactive visibility toggle using a report item

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-an-expand-or-collapse-action-to-an-item-report-builder-and-ssrs

Topics

#toggle visibility#report item#SSRS interactivity#drill-down

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice