Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssrs-2016]

SQL Server Reporting Services 2016, a web based reporting tool produced by Microsoft and bundled with SQL Server 2016.

80 questions
8
votes
1 answer

SSRS 2016 Report Portal - KPI option no available in drop down

Is there a way to enable the KPI selection in reporting services 2016 web portal? I eagerly wanted to try this feature, I then wasted 2 hours looking for it, still haven't found it. In most examples it seems to be under the "New" drop down. I'm on…
davey
  • 679
  • 1
  • 12
  • 26
7
votes
2 answers

SSRS 2016 - Change connection string in all reports

We have migrated from SSRS 2012 to SSRS 2016, and moved it to a new domain. Using below code, we are able to list all datasources and their connection strings. How can we change the connection strings of nearly 700 reports using PowerShell or T-SQL?…
user3657339
  • 309
  • 1
  • 6
  • 13
7
votes
1 answer

Standards or Best Practices for Error Handling in SSRS

I have encountered a recurring issue with SSRS where "bad" reports go out to clients. The issue is that we have reports with a number of subreports, and one or more subreports will fail to process. When the subreport fails to process, the report…
JNK
  • 18,064
  • 6
  • 63
  • 98
4
votes
2 answers

SSRS and PowerBI Report Server on same server

I've just installed the August 2018 release of PowerBI Report Server onto the same Win 2012 server with SSRS 2016. I can get it running but it clashes with SSRS with URL reservations. I've configured them to use different Virtual directories and…
Sir Swears-a-lot
  • 3,253
  • 3
  • 30
  • 48
3
votes
2 answers

SSRS Report by URL with parameter-value AND retain full top menu

TL;DR: How can I link to an SSRS (2016) report by URL, with a parameter in the query-string, AND retain (show) the FULL MENU bar (the top "SSRS chrome" that has the Favorites, Browse, Settings, breadcrumb navigation, etc.). Why: I'm phasing out an…
NateJ
  • 824
  • 2
  • 9
  • 20
3
votes
0 answers

Sporadic SSRS Report Performance

I have an SSRS instance with a dashboard report that frequently runs 100-200 times per minute throughout the organization. Most of the time, the report runs quickly with consistent times for data retrieval, processing, and rendering. The rowcounts…
Dave Mason
  • 875
  • 1
  • 8
  • 19
3
votes
3 answers

SSRS 2016 report manager using m/d/y date parameter format in Chrome

I've got a 2016 SSRS server, set up with UK regional settings. When using Chrome, date parameter fields are using the US mm/dd/yyyy format instead of the expected UK dd/mm/yyyy: Edge and IE are fine: The date picker itself works fine, and the…
Moby Duck
  • 197
  • 3
  • 7
3
votes
1 answer

Migrating SSRS 2008 to 2016 - ReportSync cannot see Data Sources

I am trying to migrate our SSRS 2008R2 server to a fresh install of SSRS 2016. I am using ReportSync and have managed to get connect to both servers OK. I created a test folder with a test report on the 2008 server and have migrated that fine to the…
SE1986
  • 2,142
  • 4
  • 30
  • 61
3
votes
0 answers

SSRS 2016 Generates SQL Server log entry daily

First, a bit about our environment. We run two instances of SQL Server 2016 Enterprise (13.0.4435.0) on Windows 2016 Servers. To save money, we run SSRS 2016 alongside SQL Server on both servers We have SSRS configured for Scale-out Deployment We…
ChrisK
  • 43
  • 5
3
votes
0 answers

Users can create SSRS subscriptions but can't edit them

I'm using SSRS 2016. Users can successfully create subscriptions to reports but if they go back to update a parameter (change a date range for example), it throws a "delivery error has occurred" message when they try to save. When you look in the…
Kris
  • 143
  • 1
  • 5
3
votes
0 answers

Weird SSRS reports error while Depolying reports

I have created the reports by using SSRS 2016 and Visual Studio 2015. When I build the reports it shows success, then deploying the report to the Target server URL I get the following error: Microsoft SQL Server Report Designer: Could not connect…
CR241
  • 1,565
  • 3
  • 18
  • 32
3
votes
2 answers

SQL Server 2016 - SSRS Unable to Upload Report Models - smdl Files

SSRS 2016 has major improvements and we've decided to migrate our 2008 servers. However, we and ran into a issue where we can't upload our old Report Models (.smdl files) via the web interface. All of the documentation states that these old models…
Brickpack
  • 119
  • 1
  • 6
2
votes
0 answers

SSRS 2016 subscriptions error - Something went wrong. Please try again later

I have a SSRS 2016 instance which gives me below error whenever I try to view my existing report subscriptions: An error has occurred. Something went wrong. Please try again later. Strange thing is subscriptions are working fine and I can even…
SQLPRODDBA
  • 1,928
  • 2
  • 33
  • 48
2
votes
0 answers

How can I quickly update cache expiration schedules for 100s of datasets?

I have over 100 different datasets on an ssrs-2016 site. Each one of those datasets needs a new caching schedule. I have created a shared schedule to apply to each dataset, but I am wondering if there is a quick way to apply that schedule to each…
Sethen
  • 121
  • 1
2
votes
0 answers

Investigating Failures of a Subreport in SSRS 2016

I have a SSRS report, MainReport, that basically just calls a series of sub-reports to compile everything into a nice and tidy Excel Document (users love their Excel reports), with each sub-report occupying its own tab. On occasion, one of the…
John Eisbrener
  • 9,547
  • 6
  • 31
  • 65
1
2 3 4 5 6