I lost datasets pane in Visual Studio

Question

I'm developing a report in the Business Intelligence studio and I lost my dataset. The pane was near toolbox, and it is gone. What is the name of the pane I should to reopen?

Possible duplicate of [DataSet panel in SSRS designer is gone](http://stackoverflow.com/questions/678322/dataset-panel-in-ssrs-designer-is-gone) — Tim Abell, Sep 16 '16 at 19:02

score 219 · Accepted Answer · edited Mar 30 '18 at 08:15

219

If anyone is interested: Ctrl+Alt+D combo helped me.

edited Mar 30 '18 at 08:15

Xavier Guihot

32,132
15
193
118

answered Oct 31 '11 at 23:30

user194076

8,257
21
79
147

18

It's also usually found in the menu: `View > Report Data` – Jeroen Jul 16 '12 at 09:43
1

what causes it to disappear - happened to me too - the project is a report type project so you would think that would stay visible. – Biz Brown Feb 13 '15 at 14:23
13

Worked for me too. Just a note about the View > Report Data menu. It looks to only be visible if the focus in on the actual report. Have the focus on the toolbox for example and the menu item is not even listed, let alone greyed out. – Paul Jun 04 '15 at 11:15
And it is so very !intuitively the very bottom option. That is THE most important thing after the designer itself. Should be at the top. Thanks StackOverflow. Saved me yet again. – james kenny Aug 16 '19 at 07:43

Tim Abell · Answer 2 · 2015-05-15T17:54:39.093

39

In Visual Studio 2013 running SSDTBI for VS 2013 the option has moved to the "View" menu, and confusingly it only shows if an actual report has focus. So click somewhere in your report, and then click "View"

enter image description here

Or as stated by others Ctrl+Alt+d still works, though only if you have a report focussed.

edited May 15 '15 at 17:54

answered Mar 05 '15 at 16:50

Tim Abell

8,954
8
70
99

score 3 · Answer 3 · answered Oct 06 '14 at 19:18

3

For some reason Ctrl + Alt + D didn't work for me.

I found it under Data -> Show Data Sources...

You would think it would be under View.

answered Oct 06 '14 at 19:18

Nate S.

1,027
14
29

score 2 · Answer 4 · answered Feb 09 '18 at 07:06

2

I am using VS 2010 and Ctrl + Alt + D worked for me. You have to click somewhere on the report to work this.

Similarly:

Ctrl + Alt + L for Solution Explorer

Ctrl + Alt + S for Server explorer

F4 for Properties

answered Feb 09 '18 at 07:06

rchacko

1,591
18
23

score 0 · Answer 5 · edited Jan 18 '13 at 23:24

0

If there's no Data in your top menu, there's no option DataSource Window to click. Luckily often Ctrl + Alt + D works.

edited Jan 18 '13 at 23:24

APC

137,061
19
153
266

answered Jan 18 '13 at 22:16

sef

1

I lost datasets pane in Visual Studio

5 Answers5