CODEWITHSUNDEEP
reporting-servicesvisual-studio-2015sql-server-data-toolssql-server-2016
Elshad Shabanov
Elshad Shabanov

Reputation: 603

Visual Studio 2015 SSDT 17.1 report designer issue

Lately, I have installed SSDT on my Visual Studio, and find out that I cannot do anything in the designer window.

The first - when I create a new report file (.rdl), it comes with 8 cells, instead of working body area of the report.

And second - I cannot drag any tools from the toolbox. When I drag, the mouse cursor turns to be a crossed circle (not available sign).

Any ideas, what it can be? I have reinstalled Visual Studio and components several times, with different scenarios. Nothing helps.

My platform is: Windows 10 Home 64-bit, SQL Server 2016 Std 64-bit (Database and Reporting Services), SSDT 17.1, Visual Studio 2015 Enterprise (Update 3)

P.S: screenshot is attached enter image description here

Upvotes: 0

Views: 798

Answers (2)

Alan Schofield
Alan Schofield

Reputation: 21683

It looks like your entire windows is covered by the parameter layout pane. So it looks something like this.

See you see the thick bar above the groups pane (just over halfway down)

enter image description here

Drag that up and you'll see you report layout pane.

enter image description here

Upvotes: 1

Arulkumar
Arulkumar

Reputation: 13237

Those 8 cells for the input parameters, you can't place the toolbox items directly.

Right click on any of the cell -> Add Parameter -> General -> Select any Data Type from the dropdownlist to create the parameter.

Also in the Name and Prompt box provide valid details to show the input parameter details. Also you can Delete Row or Delete column by right click on the cell.

In the Report Data, you can add the Datasets for the input parameters (in case if it is dropdownlist) and for the body of the report.

Upvotes: 0

Related Questions