DataSet panel (Report Data) in SSRS designer is gone

SqlVisual StudioUser InterfaceReporting ServicesToolbox

Sql Problem Overview

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?

Sql Solutions

Solution 1 - Sql

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

Solution 2 - Sql

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.

Solution 3 - Sql

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

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

Example

Solution 4 - Sql

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.

Solution 5 - Sql

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

Solution 6 - Sql

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

Solution 7 - Sql

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

Categories
Recommended Sql Solutions
Recommended Visual Studio Solutions
Recommended User Interface Solutions
Recommended Reporting Services Solutions
Recommended Toolbox Solutions

Previous Solution:

Can I stop 100% Width Text Boxes from extending beyond their containers?

HtmlCss

Next Solution:

Freeing up a TCP/IP port?

LinuxNetworkingTcpPort

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionbigoteetoeView Question on Stackoverflow
Solution 1 - SqlKevinView Answer on Stackoverflow
Solution 2 - SqlSonicVaderView Answer on Stackoverflow
Solution 3 - SqlpedramView Answer on Stackoverflow
Solution 4 - SqlNick GView Answer on Stackoverflow
Solution 5 - SqlCodeMonkey1313View Answer on Stackoverflow
Solution 6 - SqldgcharithaView Answer on Stackoverflow
Solution 7 - Sqluser2122346View Answer on Stackoverflow