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 234 · Accepted Answer · edited Mar 30 '18 at 08:15

234

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

edited Mar 30 '18 at 08:15

Xavier Guihot

54,987
21
291
190

answered Oct 31 '11 at 23:30

user194076

8,787
23
94
154

20

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
14

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

40

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

11,186
8
79
110

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,117
15
31

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

3

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,965
23
24

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

144,005
19
170
281

answered Jan 18 '13 at 22:16

sef

1

I lost datasets pane in Visual Studio

5 Answers5