Rudy Rodarte . com

Information

This article was written on 13 Jan 2017, and is filled under SQL Blogs.

Current post is tagged

, ,

Recover the missing Report Data tab in SSRS

While using SQL Server reporting services designer in Visual Studio, you may run into a situation where the Report Data tab disappears! Looking around, the Report Data tab is missing and no where to be found.

No Report Data Tab in SSRS

SSRS Report Data Tab Missing

Your first instinct is to look under View or View -> Other Windows, but you won’t find anything relating to report data there.

No Report Data in the SSRS View Menu

No Report Data in View Menu

Or will you?
First, bring up a report in the designer. Next, click on the report body, either on the background or a blank area.

Click on the report body or background

Click on the report body or background

Click on the report body or background

Click on the report body or background

Once you have clicked on the report body, you can recover the Report Data tab. You can recover the Report Data tab via View -> Report Data. Or, click Ctrl-Alt-D.

View - Report Data or Ctrl-Alt-D

View – Report Data or Ctrl-Alt-D

And your Report Data Tab has returned.

Report Data returns in SSRS

Report Data Tab returns

Note, Ctrl-Alt-D will not work until you click on the body or background of the report designer. If you are not editing a report via the designer, Ctrl-Alt-D has no effect.

Rudy

Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

More Posts - Website - Twitter