DataSet panel (Report Data) in SSRS designer is gone

Question

In the layout screen of an SSRS designer e.g. Visual Studio, I have lost the report data panel.

It has disappeared and I can't remember what it is called in order to get it back.

This usually lists the following items:

Built-in Fields
Parameters
Images
Data Sources
Datasets

Previously it was in the same area as the general Toolbox and Server explorer panels.

Does anyone know how to restore it?

I have seen cases where an error dialog has displayed upon first report load, and this seemingly prevented the Report Data window from appearing. Even after displaying the window using suggestions on this page, it was still blank. Reopening the report (without closing it) finally fixed the problem. — ErikE, Jun 18 '13 at 23:55
@ErikE i have exactly the same problem. It also occurs with the properties window. The error I get is 'Value cannot be null. Parameter name: name' — Nick.McDermaid, Feb 10 '14 at 05:21

Kevin · Answer 1 · 2017-12-15T20:08:31.853

350

With a report (rdl) file selected in your solution, select View and then Report Data.

It is a shortcut of Ctrl+Alt+D.

edited Dec 15 '17 at 20:08

answered Apr 06 '09 at 16:13

Kevin

4,287
1
26
36

4

+1 Spent over 30mins looking for this. Funny how something so essential is so hidden. One would think it would be placed under View or Report menus without having to select the report. If the UI has to be dumbed down let it be dumbed down all the way – user919426 Mar 25 '14 at 07:32
7

I assume everyone (like myself) stopped looking once they got past the 'Other Windows' sub-menu? – chrnola May 13 '14 at 19:32
5

i still don't see it in VS 2012 but the keyboard shortcut worked. – FistOfFury Jun 03 '14 at 20:34
of course, right after i post my comment i looked at the bottom of the view menu and there it was. =p – FistOfFury Jun 03 '14 at 20:36
7

I found that rdl file has to be selected and active in main workspace area for Report Data to be available in View dropdown. If report is selected in solution explorer only Report Data will remain hidden. – Bartosz Apr 15 '15 at 09:40
I think [here](https://stackoverflow.com/a/36819822/1042705) is how it should become visible – Irfan Apr 04 '20 at 15:55
some people don't have Report Data in View for some reason. ctrl alt d did the trick though, thank you. this was vs 2015 ent ssdt 14.1.xxx – renaissanceMan Jun 01 '20 at 19:37
@Microsoft - when you have a stackoverflow question to find something in your menu that has over 128k views with 167+ and the answer 340+ - then you have to think - is it the user or an issue with the software and usability? (Spoiler - It's the software!) – Richard Housham Oct 16 '20 at 12:24

score 49 · Answer 2 · answered Jun 16 '13 at 22:56

49

If you are using BIDS with SQL 2008 R2 you can only get the "Report Data" menu by clicking inside the actual report layout itself.

Click inside the actual report layout.
Now select "View" from the main menu bar.
Now select "Report Data" which is the last item.

answered Jun 16 '13 at 22:56

SonicVader

491
4
2

1

This works with VS2012 if you have the SQL Server Tools installed – Guy Starbuck Sep 06 '13 at 00:19
1

Oh godddd. step 1 is so important – dejjub-AIS Jul 12 '18 at 22:14

score 36 · Answer 3 · edited Apr 12 '17 at 13:36

36

With a .rdl, .rdlc or similar file selected, you can either:

Click View -> Report Data or...
Use the keyboard shortcut CTRL + ALT + D

edited Apr 12 '17 at 13:36

WonderWorker

7,388
3
52
71

answered Aug 19 '15 at 05:50

pedram

6,199
8
52
79

1

Just a tip - if the report is in Preview mode, the Report Data option will be greyed out (VS 2013 at least) – Jeff Dec 13 '16 at 02:42
4

This is strange - you come 6 years later and copy my answer? – Kevin Jun 07 '17 at 15:45

score 11 · Answer 4 · answered Mar 21 '19 at 18:37

11

For future people CTRL+ALT+D or just view > report data in ancient ssrs 2008 VS BI. In newer 2017 SSRS, it's still the same. Funny how they change a bunch of things around, yet kept this the same.

answered Mar 21 '19 at 18:37

Nick G

111
1
4

Interesting caveat: I have one monitor scaled to 125% for recording a presentation. When I opened VS 2017 / SSRS 2017 on that monitor there was no Report Data option in the View menu. I guess somehow Windows rendered the View menu so that the Report Data option fell off the bottom. It still looked the same when I dragged it across to the monitor that was scaled to 100%. It was only when I closed Visual Studio and reopened it afresh on the 100% scaled monitor that I could see the Report Data option in the menu. – Simon Tewsi Jan 22 '21 at 02:17

score 9 · Answer 5 · answered Mar 24 '09 at 17:15

9

View -> Datasets (bottom of menu, above Refresh)

answered Mar 24 '09 at 17:15

CodeMonkey1313

14,477
17
71
109

score 7 · Answer 6 · answered Feb 28 '18 at 06:24

7

First you have to click on the report, Then View -> Report Data

answered Feb 28 '18 at 06:24

dgcharitha

323
3
12

score 5 · Answer 7 · edited Mar 01 '13 at 06:07

5

If you are working with SQL 2008 R2 then from View---->Report Data option at bottom

edited Mar 01 '13 at 06:07

Ram kiran

20,129
14
55
74

answered Mar 01 '13 at 05:47

user2122346

51
1
1

DataSet panel (Report Data) in SSRS designer is gone

7 Answers7

Linked