TechNet
Export (0) Print
Expand All

Keyboard Shortcuts (Report Builder)

 

Applies To: SQL Server 2016

When you create and edit paginated Reporting Services paginated reports in Report Builder, you have access to all the shortcut keys for navigation that are provided by the Windows environment. You can select from several standard keyboard mapping schemes.

You can navigate through the Report Builder window, or select and change options in dialog boxes, without using the mouse.

Report Builder provides many right-click menus for quick access to frequently used dialog boxes and commands. Right-click menus are dynamic and may contain different options, depending on the user configuration and the current objects. As you explore Report Builder, make sure you right-click objects to explore the menu options and learn about these shortcuts.

System_CAPS_ICON_note.jpg Note


Keyboard shortcuts can contain the SHIFT, ALT, and/or CTRL keys in combination with letters, or use function keys. For example, F1 opens the Report Builder Help file.

DescriptionKey Combination
Open the Report Builder menu.ALT+F
Create a report.CTRL+N
Open a report.CTRL+O
Save a report.CTRL+S, ALT+S
Move between areas of Report Builder, such as the Ribbon, design surface, Grouping pane, Properties pane, and the Data pane.F6, SHIFT+F6
Move to the Ribbon.ALT
Move to the Home tab on the Ribbon.ALT+H
Move to the Insert tab on the Ribbon.ALT+I
Move to the View tab on the Ribbon.ALT+V
Activate the division lines between areas such as the line between the Grouping pane and the design surface.TAB
Move the division lines between areas.Any arrow key. Use the UP and DOWN arrows to move the line between the Grouping pane and design surface. Use the RIGHT and LEFT arrows to move the line between the Report Data pane and the design surface.
Move within an area of Report Builder, such as moving within a Ribbon tab.TAB, SHIFT+TAB
Move between Ribbon tabs.RIGHT ARROW, LEFT ARROW
Navigate the drop-down menus.Any arrow key
Select items on the design surface.TAB, SHIFT+TAB
Move a selected item on the design surface.Any arrow key
Move a selected item on the design surface, in small increments.CTRL with an arrow key
Resize a selected item on the design surface.SHIFT with an arrow key
Resize a selected item on the design surface, in small increments.CTRL + SHIFT with an arrow key
Align the edges of multiple selected items.ALT+H+A
Run the report.F5, ALT+H+R
Switch to design mode.F8
CopyCTRL+C, ALT+H+C
CutCTRL+X, ALT+H+X
PasteCTRL+V, ALT+H+V
Select all.CTRL+A
UndoCTRL+Z, ALT+Z
RedoCTRL+Y, ALT+Y
Zoom in.CTRL+Plus sign (+)
Zoom out.CTRL+Minus sign (-)
Select and unselect a checkbox on the View tab.Spacebar
Display the font family list, the font size list, or the border point size list, on the Home tab.ALT+DOWN ARROW
Display the font color list.DOWN ARROW
Display Help.F1
Merge table cells.ALT+H+M
Split a table cell.ALT+H+U
Insert a table.ALT+I+A
Insert a matrix.ALT+I+M
Insert a list.ALT+I+L
Insert a chart.ALT+I+C
Insert a gauge.ALT+I+G
Insert a mapALT+I+P
Insert a data bar.ALT+I+D
Insert a sparkline.ALT+I+K
Insert an indicator.ALT+I+U
Insert a text box.ALT+I+T
Insert an image.ALT+I+I
Insert a line.ALT+I+N
Insert a rectangle.ALT+I+E
Insert a subreport.ALT+I+S
Insert report header.ALT+I+H
Insert report footer.ALT+I+F
Pan map view area when a map viewport is selected.CTRL with an arrow key
Zoom in on map view area when a map viewport is selected.CTRL +Plus sign (+)
Zoom out on map view area when a map viewport is selected.CTRL +Minus sign (-)
Accelerator mode for pan and zoom in map view area when a map viewport is selected.CTRL +Left click

Report Builder in SQL Server 2016
Report Design View (Report Builder)
Glossary (Report Builder)

Community Additions

ADD
Show:
© 2016 Microsoft