70-466 Question #134: Real Exam Question with Answer & Explanation

The correct answer is A: In When the report is initially run, select Show or hide based on an expression. Set the expression to = (Globals!RenderFormat.IsInteractive). Using Globals!RenderFormat.IsInteractive as the Hidden expression ensures SSRS report groups are fully visible in non-interactive renders like email while preserving interactive toggle behavior in the report portal.

Build reports

Question

After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email. You need to ensure that the sales department managers can see all of the data. In the report, you update the Hidden property of each group. What should you do next?

Options

AIn When the report is initially run, select Show or hide based on an expression. Set the expression to = (Globals!RenderFormat.IsInteractive)
BIn When the report is initially run, select Show.
CIn When the report is initially run, select Show or hide based on an expression.

Explanation

Using Globals!RenderFormat.IsInteractive as the Hidden expression ensures SSRS report groups are fully visible in non-interactive renders like email while preserving interactive toggle behavior in the report portal.

Common mistakes.

B. Setting visibility to always Show permanently removes the toggle capability for users who view the report interactively in the portal, degrading their drill-down experience.
C. Selecting 'Show or hide based on an expression' without specifying the Globals!RenderFormat.IsInteractive expression does not solve the email rendering problem, because the expression itself must check the render format to differentiate between delivery modes.

Concept tested. SSRS group visibility using RenderFormat.IsInteractive for email delivery

Reference. https://learn.microsoft.com/en-us/sql/reporting-services/report-design/hide-an-item-report-builder-and-ssrs

Topics

#SSRS hidden expression#RenderFormat.IsInteractive#email subscription rendering#group visibility

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice