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
2
votes
0 answers

Post JSON data to Sql Server report services 2016 with web api

I am trying to post JSON data from web app to SQL Server reporting services 2016. So far I was able to create stored procedure in SQL server to read file with json data and convert it to table format. In SSRS, I am using that stored procedure as…
kaplievabell
  • 759
  • 1
  • 11
  • 27
2
votes
2 answers

SSRS 2016 Report Manager Blank Page

I recently installed SSRS 2016 on a Windows 2012 R2 machine and when I go to the Report manager URL I get a blank page. I used the defaults when configuring SSRS except I changed the port from 80 to 8080. The version of SQL Server that SSRS is…
Bugz Codes
  • 33
  • 2
  • 6
2
votes
1 answer

RS 2016 Unable to use Expression to filter in bar chart

I am using Reporting Services 2016. I have 6 charts that I need to only show the top 10 results. Currently, if the report only returns a value for 9 of the category groups, the report shows all of the category groups (values on x-axis), instead of…
HLines
  • 21
  • 2
2
votes
1 answer

SSRS group variables do not shown in expression editor window

I just found that in SSRS the group variables do not shown in the "variables" category of expression editor Windows. So that means I can't double click the variable name to use them and I have to type them manually. I confirmed this issue on SSRS…
Just a learner
  • 26,690
  • 50
  • 155
  • 234
2
votes
0 answers

Unable to access SSRS 2016 portal externally

I have installed SSRS 2016 on windows 2012 server R2. The SQL server 2016 is configured correctly and TCP enabled. It seems like I can not access the report portal from my machine using my network ID even though I can access it from some servers…
michael hanna
  • 21
  • 3
2
votes
2 answers

No data shown in tablix of SSRS 2016 when retreiving columns with Always Encrypted

I am working on a prototype for an upcoming big solution and wish to use Always Encrypted to encrypt certain sensitive database columns. My setup is a follows: Database Server: SQL Server 2016 installed Application Server: Reporting Server 2016…
J Pace
  • 21
  • 5
2
votes
1 answer

Parameter Layout in ASP.NET Report Viewer (SSRS 2016)

The 2016 SQL Server Report Builder allows users to arrange how the parameters will be laid out when the report renders. This gives you much more flexibility than previous versions which just shoved the parameters into a 2-column stack at the top of…
Chris Schnyder
  • 23
  • 3
2
votes
1 answer

Gradient fill based on column value

I want to set the background color (gradient) of a column based on another field's value from largest value to smallest. Refer to the following table: As shown in above table, the background color of SysName column (instead of Hours column) should…
Rameshwar Pawale
  • 632
  • 3
  • 17
  • 35
2
votes
2 answers

Howto create or change SSRS2016 default palettes?

I need to define my company-branded color palette for SSRS. This should be re-usable over several reports. I realized that I sometimes need to redefine the custom palette again and again, sometimes even on different controls in the same report, but…
Magier
  • 437
  • 1
  • 6
  • 18
2
votes
1 answer

How to make report on 2016 SSRS Report Server and upload it to 2014 SSRS Report Server?

It seems like there is not a backward compatibility option to upload the new version report to a older version server.
Kevin Zhang
  • 21
  • 2
2
votes
1 answer

Why do I get a 500 when trying to download an SSRS report using URL access?

I have a report that seems to work fine, but when trying to download it in my asp.net MVC application, I get a 500. I am simply trying to download a pdf version of it using URL access. To do this I do the following: WebClient client = new…
Jon
  • 278
  • 8
  • 23
2
votes
1 answer

Setting up SSRS 2016 to use office 365 SMTP server

Within the configuration screens for SSRS 2016 you are now able to specify a username and password to allow connection to a secure smtp server. I've been trying to configure it to use smtp.office365.com with basic authentication selected and secure…
GregP
  • 67
  • 1
  • 6
2
votes
1 answer

VS2015 - SSRS 2016 Shared Dataset

I am having an issue with VS2015 using SSDT to build new reports (SSRS 2016). When using a Shared Dataset and referencing that in the report, it does not work and gives a very vague error. I am connecting to a SQL 2008 R2 database for the…
The Faan
  • 33
  • 6
2
votes
1 answer

Chart group lines in multiple groups in SSRS

In SSDT 2014 there is some lines in ultiple groups that show group bound: but in SSDT 2016 there is not such this lines. How I can add them? Thanks
Arian
  • 12,793
  • 66
  • 176
  • 300
2
votes
2 answers

Access SSRS 2016 New Reporting Portal

I have been trying out the SQL Server CTP 3.1 for a while. For a couple a weeks ago Microsoft released CTP 3.2 (http://blogs.msdn.com/b/sqlrsteamblog/archive/2015/12/17/introducing-mobile-reports-and-a-brand-new-web-portal.aspx) which should…
Adam
  • 113
  • 1
  • 10
1 2 3
…
30 31