Database Reference
In-Depth Information
Another benefit of exporting reports to PowerPoint is that it allows you to print all
of the reports at the same time (in SharePoint, you can only print one view at a time
within a report file). Also, once exported to PowerPoint, you can save the reports to
PDF format, since there is no way to export to PDF while in SharePoint.
Design tips
The following are descriptions of some features and tips that make it easier to create
reports in Power View in Excel and in SharePoint.
Undo/Redo
Almost anything you do when designing a report can be undone using the
Undo
button. This allows you to experiment with any feature to learn about it, and if
you don't like it, just use
Undo
. You are able to undo multiple steps in the order in
which you did them, and if you undo too many times, you can use the
Redo
button.
In Power View in Excel, the
Undo
and
Redo
buttons are the large forward and
backward arrows that are on the
Power View
tab. In Power View in SharePoint,
they are two small buttons at the top left-hand side, separate from the tabs.
Arranging visualizations
When populating a report with multiple visualizations, one item can overlap or
completely cover another, for example, you could place a smaller graph on top of a
larger graph. To provide flexibility in the design, you can bring objects forward or all
the way to the front, or move objects backward or all the way to the back. In Power
View in Excel, this is accomplished by the
Bring Forward
and
Send Backward
buttons in the
Arrange
section in the
Design
tab. In Power View in SharePoint,
use the
Arrange
button in the
Home
tab.
Fit to window
The Power View report in Microsoft Excel as well as in SharePoint fits to the window
and automatically resizes if you open more panes, such as the
Filters
area, or if you
resize the window, it resizes by adjusting the font size of all the objects. To stop the
report from resizing to fit the window, click on the
Fit to Window
button. Then, if
the report is too big to fit the canvas area, use the scroll bars to view the different
parts of the report.
