Stack Overflow
Stack Overflow

Questions tagged [ssrs-2016]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2016.

463 questions
16
votes
3 answers

Custom Authentication (Security Extension) with SSRS 2016

I am trying to implement custom forms authentication with SSRS 2016. Within this article, a reference is made to the SQL Server Reporting Service Product Samples. It appears that the latest supported version on the samples page (with regards to…
Jason Richmeier
  • 1,595
  • 3
  • 19
  • 38
15
votes
6 answers

There is an error in XML document (2, 2): Visual Studio, SSRS Project file errors (VS2015-VS2017)

I have a solution file that was developed with VS2015, and it has about 20 project files. When we opened the file with VS2017 a prompt appeared: "The version of the report server project is not supported and the project must be upgraded". We chose…
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
14
votes
1 answer

SSRS report files (.rdl) how to upgrade to latest?

I have been using Visual Studio 2010 for Reporting Services projects, with a SQL server 2012 reporting services back-end. To display the report we went from version 10,to 11 with the Reporting viewer in asp.net like so with no problems. <%@…
Michael Rudner Evanchik
  • 867
  • 1
  • 8
  • 19
12
votes
3 answers

SSRS file error message: The number of defined parameters is not equal to the number of cell definitions in the parameter panel

I have converted a report file from Crystal (.rpt) to SSRS (.rdl) using an automated service tool. When I preview the report in Viusal Studio SSDT I am getting a very strange error message: “The number of defined parameters is not equal to the…
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
11
votes
1 answer

Embedding SSRS 2016 reports into another webpage without iFrame?

Reporting-services 2016 (currently only available as a technical preview) comes with big-upgrades including HTML5 rendering and compliance. See: https://msdn.microsoft.com/en-us/library/ms170438.aspx My desire is to embed SSRS 2016 reports into…
Wollan
  • 929
  • 1
  • 13
  • 23
7
votes
3 answers

SSRS 2016 Report Viewer Control

We are looking at installing SSRS 2016. We currently use ReportViewer Control 11 (2012). Do we need to upgrade to ReportViewer Control 12 (2015) in order for us to view reports? I'm assuming there isn't any 2016 version yet. Just want to make sure…
Joe Starnes
  • 471
  • 1
  • 6
  • 20
6
votes
2 answers

How to upgrade SSRS 2005 report project for use with modern SSRS versions?

I have installed SQL Server Data Tools for Business Intelligence (SSDT-BI) version 14.0.61705.170 and SQL Server Reporting Services (SSRS) version 14.0.608.142. I'm trying to upgrade and edit a collection of older report files for use with the…
Hydrargyrum
  • 3,378
  • 4
  • 27
  • 41
6
votes
0 answers

How to embed web portal from SSRS 2016 into web page?

We were using SSRS 2014 and had our web portal embedded in another enterprise internal web page using iFrame, everything is on the same network and it was working fine. We upgraded SSRS to 2016 and now we get the message: "This content cannot be…
Sandra
  • 175
  • 1
  • 2
  • 11
5
votes
1 answer

Logout functionality on SSRS WebPortal

I am able to setup and run the SSRS 2016 environment for reporting purposes https://learn.microsoft.com/en-us/sql/reporting-services/web-portal-ssrs-native-mode When i try to access the portal [ similar to the one explained in above link] i can…
Sebastian
  • 4,625
  • 17
  • 76
  • 145
5
votes
2 answers

SSRS - Display only Top N Category Groups excluding duplicate groups at the end in Bar Chart

Consider the following table I need to generate a bar chart with the Category Group = "Country". The chart should only display the top 3 Groups based on the count of records for a country. I have already applied a filter for the Category Group…
Denzil Soans
  • 667
  • 1
  • 7
  • 27
5
votes
3 answers

SSRS IIF Statement showing #Error when value is non numeric

I have a value that will either be a decimal or string. Sample 0.41 0.91 "0 / 2" 0.75 My current expression is =IIF(IsNumeric(Fields!currentRate.Value), Format(CDBL(Fields!currentRate.Value), "P2"), Fields!currentRate.Value) This properly returns…
eknofsky
  • 163
  • 1
  • 9
5
votes
1 answer

SSRS 2016 Automate deployment to SQL Server 2008R2 using rs.exe

Currently the reports we have are written using Visual Studio 2012 and SQL Server 2008 R2. We also use the RS.exe utility to automate the deployment of our reports to our different environments. We are looking at jumping to Visual Studio 2017 and…
user980916
  • 51
  • 2
5
votes
0 answers

SSRS 2016 web portal very slow, especially off network

We recently migrated from a SQL Server 2008 SSRS server to a new SQL Server 2016. The entire report catalog was restored and upgraded to this new server. Everything is working, except the horrible performance of the web portal. The performance…
user3066650
  • 51
  • 1
5
votes
4 answers

ssrs error Maximum request length exceeded

I open a report file (created in SSRS 2014) in report builder of SSRS 2016 in order to save it into report manager site OR preview it, I get this error: System.Web.Services.Protocols.SoapException: There was an exception running the extensions…
sqluser
  • 393
  • 1
  • 4
  • 22
5
votes
1 answer

Visual Studio Report Designer 2015 Not Building to Target Server Version Correctly

I have an SSRS report project I'm working on in Visual Studio 2015, and I am unable to deploy my reports to the correct target server version. The reports need to be able to deploy and run on SQL Server 2012, 2014 and 2016. Visual Studio 2015 allows…
mcol2007
  • 61
  • 8
1
2 3
…
30 31