DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
An existing report aggregates data from a SQL Server database in a chart.
You need to use the chart in a new report and ensure that other users can use the chart in
their reports.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Note:
* In Report Designer, after you create tables, charts, and other report items in a project, you
can publish them asreport partsto a report server or SharePoint site integrated with a report
server so that you and others can reuse them in other reports.
* . By using Report Builder, you can customize and update reports that were created in SQL
Server Data Tools (SSDT) Report Designer.
* InReport Builder, IT pros and power users can create powerful operational reports, and
reusable report parts and shared datasets.
Incorrect:
* (incorrect) Power View, a feature of SQL Server 2012 Reporting Services Add-in for
Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration,
visualization, and presentation experience. It provides intuitive ad-hoc reporting for business
users such as data analysts, business decision makers, and information workers. They can
easily create and interact with views of data from data models based on PowerPivot
workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server
2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight
application launched from SharePoint Server 2010 that enables users to present and share
insights with others in their organization through interactive presentations.
Getting Started with Report Builder
Report Parts in Report Designer (SSRS)
ok
Answer is correct:
1. In Report Designer (RD/SSRS/Visual Studio) open the report that contains the Report Part.
2. Publish the Report Part in RD.
3. To test that other users will be able to add the Published Report Part to their own reports, go to the Report Builder Application (RB), search for the Report Part, and add it to another report.
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-parts-in-report-designer-ssrs