nerdexam
Exams70-467Questions#160
Microsoft

70-467 · Question #160

70-467 Question #160: Real Exam Question with Answer & Explanation

The correct answer is D: report parts. SSRS report parts stored in SharePoint libraries satisfy all three requirements: cross-report content reuse, in-place SharePoint editing, and built-in document version history.

Question

You are designing a reporting solution that uses SQL Server Reporting Services (SSRS) in SharePoint integrated mode. The reporting solution must meet the following requirements: - Allow report writers to reuse content between different reports. - Allow report writers to modify reusable content in SharePoint. - Retain version history for report content. You need to choose a reporting method that meets the requirements. What should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

  • Adrillthrough reports
  • Blinked reports
  • Csubreports
  • Dreport parts

Explanation

SSRS report parts stored in SharePoint libraries satisfy all three requirements: cross-report content reuse, in-place SharePoint editing, and built-in document version history.

Common mistakes.

  • A. Drillthrough reports navigate from a summary report to a detail report at click time but do not provide a mechanism for storing or sharing reusable content components across different reports.
  • B. Linked reports share a base report definition and support different parameter values, but they do not store independently modifiable, version-tracked reusable content items that can be embedded in other reports.
  • C. Subreports embed one complete report inside another at render time, but the embedded report is not a granular, separately versioned content component that writers can independently discover and modify in SharePoint.

Concept tested. SSRS report parts for shared content reuse in SharePoint mode

Reference. https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-parts-in-report-designer-ssrs

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice