DataSet panel (Report Data) in SSRS designer is go

2019-01-29 17:38发布

问题:

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 rmeember 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?

回答1:

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

It is a shortcut of Ctrl+Alt+D.



回答2:

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.



回答3:

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

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



回答4:

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



回答5:

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



回答6:

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