nerdexam
Microsoft

70-466 · Question #130

You need to ensure that all reports meet the reporting requirements. What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

The correct answer is D. Create a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored report. Storing a base report in the Visual Studio PrivateAssemblies\ProjectItems\ReportProject folder makes it available as a local template for all new SSRS reports created in that environment.

Implement a reporting services solution

Question

You need to ensure that all reports meet the reporting requirements. What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

Options

  • ACreate a report part. Publish the report part to a server that has SSRS installed. Add the report part to each new report that is created.
  • BCreate a report part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.
  • CCreate a report. Copy the report to source code control. Create each new report by using the report template in source code control.
  • DCreate a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored report

How the community answered

(24 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    4% (1)
  • D
    83% (20)

Why each option

Storing a base report in the Visual Studio PrivateAssemblies\ProjectItems\ReportProject folder makes it available as a local template for all new SSRS reports created in that environment.

ACreate a report part. Publish the report part to a server that has SSRS installed. Add the report part to each new report that is created.

Report parts are reusable sub-components (charts, tables) published for insertion into reports, not full report templates that define the starting structure of a new report.

BCreate a report part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.

Publishing a report part to SharePoint makes it available for insertion into reports but does not create a Visual Studio new-report template that enforces baseline structure on creation.

CCreate a report. Copy the report to source code control. Create each new report by using the report template in source code control.

Storing a report in source code control preserves the file but does not register it as a Visual Studio item template, so it cannot be selected as the basis for new reports through the standard Add New Item dialog.

DCreate a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored reportCorrect

Visual Studio looks in the PrivateAssemblies\ProjectItems\ReportProject directory for custom project item templates when a developer adds a new report to an SSRS project. Placing a pre-configured report file there makes it the starting point for every new report, ensuring consistent formatting, data sources, and layout requirements are enforced from creation. This is the supported, local-deployment approach for organization-wide report standards in SSRS development.

Concept tested: Creating custom SSRS report templates in Visual Studio

Source: https://learn.microsoft.com/en-us/sql/reporting-services/tools/reporting-services-in-sql-server-data-tools-ssdt

Topics

#report templates#PrivateAssemblies#SSRS project items#report standardization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice