nerdexam
Microsoft

70-466 · Question #125

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. You need to ensure that the header of the report is hidden when a user exp

The correct answer is C. = (Globals!RenderFormat.Name = "PDF"). SSRS exposes the Globals!RenderFormat object to let report designers conditionally show or hide elements based on the current export format, such as PDF.

Build reports

Question

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. You need to ensure that the header of the report is hidden when a user exports the report to PDF or print. Which hidden property expression should you use for the report header? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

  • A= True
  • B= False
  • C= (Globals!RenderFormat.Name = "PDF")
  • D= (Globals!RenderFormat.IsInteractive = False)

How the community answered

(29 responses)
  • A
    10% (3)
  • B
    3% (1)
  • C
    72% (21)
  • D
    14% (4)

Why each option

SSRS exposes the Globals!RenderFormat object to let report designers conditionally show or hide elements based on the current export format, such as PDF.

A= True

Setting Hidden = True unconditionally hides the header in all rendering formats, including interactive web views, which is not the requirement.

B= False

Setting Hidden = False unconditionally shows the header in every format, including PDF and print, which is the opposite of the requirement.

C= (Globals!RenderFormat.Name = "PDF")Correct

The expression (Globals!RenderFormat.Name = "PDF") evaluates to True only when the report is rendered as PDF, causing the hidden property to activate and suppress the header. This directly targets the named PDF format without affecting interactive HTML rendering. It is the most precise expression for hiding content on PDF export.

D= (Globals!RenderFormat.IsInteractive = False)

Globals!RenderFormat.IsInteractive = False evaluates to True for all non-interactive formats including Excel, Word, and CSV - not just PDF and print - making it broader than required and potentially the wrong choice when only PDF export must be targeted.

Concept tested: SSRS conditional visibility using RenderFormat globals

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-built-in-globals-and-users-references-report-builder

Topics

#SSRS hidden property#RenderFormat.Name#PDF export#report header visibility

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice