Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

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...