nerdexam
Microsoft

70-466 · Question #142

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. Report users require PDF exports of the report with no bulky images of the

The correct answer is A. Set the Hidden property of the report header to (Globals!RenderFormat.Name = "PDF").. The Globals!RenderFormat.Name global in SSRS identifies the active rendering extension by name, enabling precise conditional visibility that targets only PDF exports.

Build reports

Question

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. Report users require PDF exports of the report with no bulky images of the report header. You need to ensure that the header of the report is hidden when a user exports the report to PDF format. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Exhibit

70-466 question #142 exhibit

Options

  • ASet the Hidden property of the report header to (Globals!RenderFormat.Name = "PDF").
  • BSet the Hidden property of the report header to (Globals!RenderFormat.IsInteractive = False).
  • CSet the Hidden property of the report header to FALSE.

How the community answered

(49 responses)
  • A
    73% (36)
  • B
    16% (8)
  • C
    10% (5)

Why each option

The Globals!RenderFormat.Name global in SSRS identifies the active rendering extension by name, enabling precise conditional visibility that targets only PDF exports.

ASet the Hidden property of the report header to (Globals!RenderFormat.Name = "PDF").Correct

Setting the Hidden property to the expression (Globals!RenderFormat.Name = "PDF") evaluates to True only when the report is rendered by the PDF rendering extension, hiding the header exclusively during PDF export. This leaves the header visible in all other formats such as HTML and Excel, satisfying the requirement without unintended side effects.

BSet the Hidden property of the report header to (Globals!RenderFormat.IsInteractive = False).

Globals!RenderFormat.IsInteractive = False evaluates to True for all non-interactive renderers including Excel, Word, and Image formats, hiding the header in more export formats than just PDF.

CSet the Hidden property of the report header to FALSE.

Setting Hidden to FALSE unconditionally keeps the header visible in all rendering formats, including PDF, which directly contradicts the requirement to hide it during PDF export.

Concept tested: SSRS RenderFormat global for format-conditional visibility

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#report header visibility#PDF export#RenderFormat

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice