Questions tagged [ssrs-2016]

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

34 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
723 views

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, ...
3
votes
0answers
2k views

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" ...
3
votes
0answers
872 views

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: ...
2
votes
1answer
2k views

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

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

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 ...
2
votes
0answers
1k views

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

SSRS Scale Out Deployment URLs

I have successfully setup a scale out deployment of 2 2016 Enterprise Edition SSRS servers connecting to a single shared database. So far, I have not setup a URL for the servers (they are each using ...
2
votes
0answers
509 views

In-Place SSRS 2014 to 2016 Upgrade Failed. Cannot start new SSRS 2016 instance

We have a SQL server 2014 and SSRS 2014 instance set up on two different 2012 R2 servers. This has been our setup for years, and everything has worked fine. We did an in place upgrade of the SQL ...
2
votes
0answers
412 views

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 ...
2
votes
1answer
46 views

Sql Server Reporting

I have a report parameter which depends on a query from the Dataset. The query needs one parameter and sql server reporting has no parameter drop down version - Microsoft SQL Server 2016 Report ...
1
vote
1answer
17 views

SSRS HA Deployment Advice

wanted to ask if my design is on the right track for installing SSRS. Currently i have 2 nodes in an Always ON AG (2017 Enterprise Edition). There is an application update coming up that will require ...
1
vote
1answer
35 views

SSRS and Power BI on same server

I understand that as of the 2016 versions it is now possible to run SSRS and Power BI on the same server. I would like to know if anyone is currently running this combination and what are the pros and ...
1
vote
1answer
29 views

How can I first sort by color & then in alphabetical order in ssrs?

I'm still new to ssrs. In my query the color is determined by location. In my query I did ORDER BY [Location], Underwriter. Now this works perfectly fine in my query, but when I run it in SSRS it ...
1
vote
0answers
22 views

SSRS 2016 ReportServer DBs in Basic AG

I have a 2 node cluster on which I need to setup AlwaysOn since it is a standard edition we would be going with Basic AGs. I can easily get the user databases added into the AGs but I am not sure ...
1
vote
0answers
64 views

SSRS default URL not being referenced from Windows application

I have installed and configured SSRS and when I check the URL via HTTP it works fine (I haven't configured SSL). When I try to run a report from the Windows application, I get the following error ...
1
vote
0answers
39 views

SSRS Export Pop-Up Warning

I'm building a new reporting server using SSRS 2016 and have been given one specification I'm not sure is even possible. My supervisor wants a pop-up message whenever someone exports a report that ...
1
vote
0answers
105 views

KPI's don't transfer on RS.exe SSRS Server Migration

I'm attempting to do a server migration with SSRS 2016 to Power BI (March 2018 release). I have been successful at getting my Data Sources, Data Sets, Folders, Reports, settings and subscriptions to ...
1
vote
1answer
113 views

how to update SSRS execution account automatically through power-shell?

I need to update the password for the SSRS Execution account for every 15 days. How can I automate this process using power shell or some other scripting?
1
vote
1answer
2k views

SSRS encryption keys are broken

I had an SSRS service account password expire. This is on an Azure Windows server. I've tried the following: Updating the password caused "The report server can’t access or use the encryption key" ...
1
vote
0answers
289 views

Patching SSRS on Always On Availability Groups

I have SSRS 2016 installed on Always On Availability Groups. I have patched my secondary servers with SQL Server patches. When I failover SSRS will not connect to the databases, it has an error ...
1
vote
0answers
1k views

SSRS dataset query not ordering by properly

I have a dataset text query and I would like to have an ORDER BY in it. The issue is in SSRS, the ORDER BY is not working as desired. However, when I run the query in SSMS, the output is ordered as I ...
0
votes
0answers
7 views

SSRS reports resets the parameters to default after I click on “View Report”

We are using SSRS version 16(build 13.0.x) in Native mode. I built a report using Report Builder with 2 parameters(independent). Everything works as it should when I run the report in Report Builder. ...
0
votes
0answers
11 views

Power BI Scale Out Data model Refresh Control

What, if anything, controls which server in a PBIRS scale out performs the refresh? I have 3 servers. One is a Back End server where SQL is installed and contains on premise Power BI Report Server ...
0
votes
0answers
30 views

Migrating Reports issue. The report server isn’t configured properly

I am migrating a ton of reports to a new server and am getting the 'The report server isn’t configured properly' error. Steps I have taken: Backed up and restored ReportServer and ReportServerTemp ...
0
votes
0answers
613 views

Generic “An Error Has Occurred” When Editing SSRS Subscription - No Parameters Appearing

I'm relatively new to SSRS Reporting. I'm attempting to manage a data-driven subscription for a two-part report on a SQL Server 2016 Developer instance that is acting as a dedicated SSRS server. At ...
0
votes
0answers
2k views

SSRS 2016 : HTTP Error 503. The service is unavailable

We have SSRS 2016 on Windows Server 2016. Reporting Server configured with virtual directories http://ServerName:80/Reports http://ServerName:80/ReportServer While I'm trying to connect to reports ...
0
votes
0answers
41 views

How to export the SSRS report in excel

I have 7 pages in my SSRS report and also I'm used page break option. Is there any way available to export all the pages in single excel sheet. Please provide me solutions
0
votes
0answers
175 views

Update password across all SSRS reports within a folder in Reporting services 2016

I am going through a manual intervention of manually updating the password in data source section for all the reports in SSRS2016. This is very tedious as i need to update this across 40+reports ...
0
votes
1answer
24 views

Trying to add another field for SSRS

I have a union all that combines two statements for an SSRS report. I would like to create a third column that is based on a where clause from the table as the third field (col1, and col2 being the ...
0
votes
0answers
76 views

Reporting server configured in a separate Web server

I am new into configuring Reporting server and I did install and configured reporting server in a separate app server (lets say on app-01). I have my database server running on a separate server, sql-...
0
votes
1answer
18 views

SSRS table populating data into a field that should be blank

I am having trouble resolving an issue. I have a table on an SSRS report. The query for the table gets the definition, the total count of that definition and calculates the percentage of all the ...
0
votes
0answers
3k views

SSRS 2016 Report Manager screen hanging on “Loading…” when creating a subscription to a report

I am planning a migration to 2016 Reporting Services and have noticed a particular problem. On two separate new installs for SSRS 2016 Developer Edition, I am unable to save a subscription to a report....
0
votes
1answer
418 views

SSRS2016 external parameters for mobile report

How can external parameters be passed to a SSRS 2016 mobile report in order to pre-select values / settings for the report? The same scenario is possible for paginated reports as it always was. It's ...