Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DataSet panel (Report Data) in SSRS designer is gone

People also ask

Where is the report data pane in SSRS?

To display the Report Data pane In Design view, on the View menu, select Report Data, or use CTRL+ALT+D.

How do I view datasets in Visual Studio?

Click the Data Sources tab in the left margin of Visual Studio, or type data sources in the search box. Right-click the dataset node and select Configure Data Source with Wizard.

How do I get report data in Visual Studio?

In Visual Studio, on the View menu, choose Report Data. In the Report Data pane, expand DataSets, right-click DataSet_Result, and then choose Refresh.


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


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.


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

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

Example


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.


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