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
4
votes
1 answer

SSRS Group Variables SUM & VB.NET Custom Code

I have an SSRS report built using group variables with expressions that do field calculations. The group varaibles are providing correct results between 3 datsets using lookups, arithmatic, and logic operations. I need to SUM total the results of…
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
4
votes
1 answer

SSRS 2016 report or shared dataset has user profile dependencies and cannot be run unattended

I am building an SSRS report that is designed to be flexible so that I don't have to create several copies of the report based on your role in the company. I am using the User!UserID built in parameter to drive one of my report parameters (this…
JBirrer
  • 171
  • 3
  • 13
4
votes
4 answers

Can you force a label on top of a bar chart in SQL Server Reporting Services?

I would like to ensure the labels of my bar chart are above the bars. Can you force a label on top of a bar chart in SQL Server Reporting Services? If so, how? The issues are the colors are so dark, it's hard to read them if they are not above the…
JM1
  • 1,595
  • 5
  • 19
  • 41
4
votes
2 answers

SSRS 2016 Adding Columns or Unmerging Cells gives "Undocumented/RDL structure invalid" Error

Recently, I've been going through and converting/recreating a number of SSRS reports for the new 2016 version. For the main part things are going well and the reports end up looking better, but I've run into one pretty glaring issue. And that's an…
bitnine
  • 1,752
  • 1
  • 17
  • 20
4
votes
2 answers

SSRS2016 - Web portal error

Yesterday I upgraded Sql server 2014 to Sql server 2016 RTM. When i go to reporting services web portal i get error popup "Could not load folder contents Something went wrong. Please try again later. " I tried: Repair instalation Restore…
Peter M.
  • 1,028
  • 2
  • 10
  • 27
3
votes
1 answer

How to have one central location for all report subscriptions in SSRS?

We have a team of report developers and when each person tries to setup a subscription (i.e. report delivery subscription/method), what we do is that we go to the report, click on Manage/Subscription/New Subscription. This way of doing it, is the…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
3
votes
3 answers

SSRS 2008 R2 to SSRS 2016 Migration

I have to migrate 770 SSRS Reports (Includes both Native mode and Sharepoint Mode Reports) from 2008 R2 version to SSRS 2016 version. Which is the best tool for this SSRS migration ? I have seen few tools like Microsoft Reporting Services Migration,…
Sunjith
  • 76
  • 1
  • 11
3
votes
1 answer

Error receiving large report using Reporting Services Execution Web service

I have an application which stores photo data in database. An SSRS report is used to generate reports of photos related to a specific entity. The information required to generate this report is stored in a separate database and very simply links a…
Dave
  • 457
  • 4
  • 15
3
votes
2 answers

SQL Server : get size of longest value in column and include column name in that total

I have the following query that returns the number of the longest word it finds within that column: SELECT MAX(LEN(id)) AS id, MAX(LEN(linkToTbl2)) AS linkToTbl2, MAX(LEN(description)) AS description, MAX(LEN(number)) AS number,…
StealthRT
  • 10,108
  • 40
  • 183
  • 342
3
votes
2 answers

SSRS Reportviewer Cannot add duplicate collection entry of type 'add' with unique key attribute 'name' set to 'ReportViewerWebControlHandler'

Hey all I am pulling out my hair trying to figure out why this is telling me that there are duplicates of the key for ReportViewerWebControlHandler. This is what my web.config file looks like (omitting things that do not apply here)
StealthRT
  • 10,108
  • 40
  • 183
  • 342
3
votes
2 answers

SSRS 2016 Vertical Alignment Middle not Working

I am using SSRS 2016 to make a report. I use MIDDLE for the Vertical Alignment so the text is in the middle of the box. It changes to look correct in Design View but when I view it in Report Viewer, it looks like it's set to TOP. More bizarrely,…
Hannover Fist
  • 10,393
  • 1
  • 18
  • 39
3
votes
3 answers

SSRS 2016 Report Viewer V13 Toolbar Icons not displaying

When i was looking solution for the problem, i saw a topic on microsoft forums. The same question is asked by a user and i want to quote that question: The Report Viewer control is not rendering the toolbar correctly. I'm following the instruction…
Ceylan B.
  • 564
  • 9
  • 23
2
votes
2 answers

Automating Configuration of SSRS 2016 with powershell (Need to change URL from "https" of "http")

I have already installed Report server database(SSRS 2016). I know how to configure Report server through RS Configuration Manager, but I want to do this automatically with power shell. I want to change Webservice and WebPortal URL to "https" and…
Karthik Karnam
  • 170
  • 11
2
votes
1 answer

Unified xslt for multiple SSRS reports (xml export)

I have SSRS 2016 and some reports (similar structure but different names and data) to be transformed during xml export. Report xml example:
Serhii Proskurnin
  • 23
  • 5
2
votes
0 answers

SSRS adds return carriage to each cell when coping data from table in a report

I have a report generated with SSRS. I have a table that is generated with results (just like running a query in SQL Server Management Studio and getting results). For some reason when I copy the data from the table in the report then paste it in…
Arvo Bowen
  • 4,524
  • 6
  • 51
  • 109
1
2
3
…
30 31