How to find the Report Data tab in SSRS after closing it

August 2, 2011

Today I was rocking along in SSRS 2008R2 and then absent mindedly closed the Report Data tab by clicking the x at the top corner!  When I go to the View menu, I do NOT have the choice of Report Data.

no Report Data

Never fear. I’ve found a few ways to get it back. 

One way is to use the key combination Ctrl-Alt-D    But that may not do anything unless you first either double click on the name of the report ([reportname].rdl) in Solution Explorer or simply click on the Design surface where you’re creating the report. 

report in progress

In fact, clicking on the report in progress itself may bring Report Data back to the old View menu immediately!

report data

If all else fails and you can’t seem to get Report Data to reappear, you can always reset your windows to the way Nature intended them.

reset windows

{ 13 comments }

Study Methods August 4, 2011 at 10:10 pm

Nice post and properly explained….can you please make a simple video of it, because then it would be more clear. I was bit confused about to find the Report Data tab….thanks indeed

Desi August 10, 2011 at 2:06 am

Thank you very much for this post. Very helpful constantly I have problem with the SSRS

Glennda August 17, 2011 at 5:46 am

Yes it would be much clearer on videos although your illustration is fine but there are newbies who wanted to learn from you also.

Mark Testa from california mls listing service August 20, 2011 at 8:22 am

Another great input! This really useful and I’m sure it will come in handy one of these days. I see lots of people having trouble with SSRS. Haven’t read much about solutions like these for SSRS errors before.

Gary Ashton from Nashville homes August 20, 2011 at 9:59 am

Awesome! You actually figured it out yourself! Thanks for sharing this one. I might actually need this just in case I click that x button! :) Helpful post. Thanks!

Tom from namco pools sprinfield September 20, 2011 at 8:56 am

A great way thanks for the article

Dany from Yahoo domain September 22, 2011 at 3:38 pm

I don’t use SSRS but I do find little keyboard shortcuts like these useful in many programs! Especially one that recovers data that you thought you’ve already lost!

miftah from tablet computer September 23, 2011 at 2:22 pm

really helpful for me, before I always lost data after closing

jesna from blogging tips September 28, 2011 at 2:25 am

I often had this issue. Thank you for this detailed post!

Paul from Wooden Gates September 29, 2011 at 9:12 am

I kept doing the same thing with SSRS; I haven’t been using recently as I kept closing tabs and then having to try to find how to bring them back.

Alex from Pastile de slabit October 9, 2011 at 10:43 am

Thanks for the very informative article i bet you helped a lot of people.

Stephen Jack from Used Cellphones October 12, 2011 at 5:51 pm

I think you will be able to help people in much better way if you make a video tutorial of this video and upload in on youtube. Don’t forget to give the copyrights to everyone so that people can also post it on their blogs and spread the awareness. Anyhow thumbs up for you

john from mobile coupons October 24, 2011 at 9:32 pm

This is very helpful, thank you. Thank you for including the keyboard shortcut too. I like to learn as many of those shortcuts as possible.

Previous post:

Next post: