CODEWITHSUNDEEP
sqlvisual-studiouser-interfacereporting-servicestoolbox
bigoteetoe
bigoteetoe

Reputation:

DataSet panel (Report Data) in SSRS designer is gone

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:

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

Does anyone know how to restore it?

Upvotes: 204

Views: 166186

Answers (8)

Hira Zahid
Hira Zahid

Reputation: 11

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

Upvotes: 0

Nick G
Nick G

Reputation: 351

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.

Upvotes: 25

dgcharitha
dgcharitha

Reputation: 345

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

Upvotes: 7

Kevin
Kevin

Reputation: 4747

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

It is a shortcut of Ctrl+Alt+D.

enter image description here

Upvotes: 394

Pedram
Pedram

Reputation: 6508

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

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

Example

Upvotes: 38

SonicVader
SonicVader

Reputation: 551

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.

  1. Click inside the actual report layout.

  2. Now select "View" from the main menu bar.

  3. Now select "Report Data" which is the last item.

Upvotes: 55

user2122346
user2122346

Reputation: 51

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

Upvotes: 5

CodeMonkey1313
CodeMonkey1313

Reputation: 16031

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

Upvotes: 9

Related Questions