DataSet panel (Report Data) in SSRS designer is gone

A

8

201

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?

Armin answered 24/3, 2009 at 17:5 Comment(2)

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. – Bulkhead 18/6, 2013 at 23:55

@Bulkhead 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' – Twinflower 10/2, 2014 at 5:21

K

386

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

It is a shortcut of Ctrl+Alt+D.

Knowall answered 6/4, 2009 at 16:13 Comment(9)

+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 – Whipstock 25/3, 2014 at 7:32

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

i still don't see it in VS 2012 but the keyboard shortcut worked. – Janey 3/6, 2014 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 – Janey 3/6, 2014 at 20:36

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. – Poultice 15/4, 2015 at 9:40

I think here is how it should become visible – Wetzel 4/4, 2020 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 – Barna 1/6, 2020 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!) – Mavilia 16/10, 2020 at 12:24

After VS crashed (and auto-restarted) the Report Data dissapeared on me, and was looking like a madman where it is, and eventually seen this, but still wasn't there! After restarting Visual Studio manually, and re-opening the project, it reappeared. – Illuminance 17/9, 2021 at 10:36

P

55

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.

Pagepageant answered 16/6, 2013 at 22:56 Comment(2)

This works with VS2012 if you have the SQL Server Tools installed – Northern 6/9, 2013 at 0:19

Oh godddd. step 1 is so important – Schiller 12/7, 2018 at 22:14

H

38

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

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

Hyonhyoscine answered 19/8, 2015 at 5:50 Comment(2)

Just a tip - if the report is in Preview mode, the Report Data option will be greyed out (VS 2013 at least) – Spinach 13/12, 2016 at 2:42

This is strange - you come 6 years later and copy my answer? – Knowall 7/6, 2017 at 15:45

P

23

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.

Poignant answered 21/3, 2019 at 18:37 Comment(3)

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. – Amylene 22/1, 2021 at 2:17

Same for VS2019 – Legitimist 20/7, 2022 at 0:1

I'm in VS 2022 and I don't know WHAT happened. It was there yesterday. I had the report rdl file selected in the object explorer. Design view was displayed. Report Data was nowhere to be found on the View menu. CTRL+ALT+D saved the day. Thanks! – Circle 1/3 at 20:53

B

9

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

Berns answered 24/3, 2009 at 17:15 Comment(0)

R

7

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

Ripen answered 28/2, 2018 at 6:24 Comment(0)

H

5

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

Hamburg answered 1/3, 2013 at 5:47 Comment(0)

W

0

First Click any where on the Report layout in Visual Studio and then go to View/Report Data at the bottom of View Menu

Wilbourn answered 12/3, 2023 at 16:11 Comment(1)

Other than omitting a precondition, this seems to repeat answers from about 2011. – Thief 20/3, 2023 at 10:26

Recommended topics

Hot tags