Questions tagged [ssrs-2016]

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

Filter by
Sorted by
Tagged with
2
votes
0answers
110 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 ...
0
votes
1answer
22 views

How to change the reporting services report service mode from Native to integrated?

In SSRS-2016, I am trying to change the Reporting services report service mode from Native to integrated. I added 2 new shared features to existing installation (See in the Pic) I am trying to ...
0
votes
0answers
9 views

SSRS 2016 - Encryption Key Issue

i need help for one of SSRS 2016 issue. After every reporting service restart encryption keys are lost.. every time we have to manually restore the keys. Is anyone faced such scenario? Any help ...
0
votes
0answers
29 views

Disabling SSRS Scale out feature during migration to non-enterprise edition

Server A is SQL Server 2008 R2 Enterprise which has SSRS installed. I have migrated across the reporting database, reporting tempdb, etc. On Server B is SQL Server 2017 standard edition with SSRS. I ...
0
votes
0answers
25 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
10 views

how to set the page break in SSRS report

I achieved the page break for every 8 rows but I have 33 rows in my SSRS report, if 33 rows is divisible by 8 i get 5 pages and I could see there is only one row in 5th page I don't to display in 5th ...
1
vote
0answers
21 views

After SSRS to PowerBI Reporting Server migration, parameters are rendering goofy when trying to enter data

We just successfully migrated a SSRS 2016 instance to PBIRS. Users are reporting weird behavior when trying to enter data in a multi value parameter. When they click on a parameter to enter in data, ...
0
votes
0answers
22 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
0answers
33 views

I am migrating SSRS from SQL server 2008 r2 to sql server 2016 on another server. Finding and backing up the right web.config and machine.config

I am following "https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-native-mode?view=sql-server-2017#bkmk_backup". Under "Backup Files and ...
0
votes
1answer
92 views

Is Scale out deployment for SSRS needed in an Availability group?

This is my first attempt at setting up SSRS, so I apologize if any question appears basic. I've researched as much as I can and am confused about the below things. I have my environment described ...
0
votes
1answer
22 views

Microsoft SQL secondary read-only DB for SSRS?

I know that Microsoft SQL has AlwaysOn with a read-only secondary replica. However the cost of enterprise edition for all of our SQL servers makes this not possible. We have SSRS configured to run ...
0
votes
0answers
51 views

SSRS 2016 (under Power BI RS) Shared data source change won't save for paginated reports!

I am running the Jan 2019 build of Power BI Report Server. For paginated (SSRS) reports, I am UNABLE to change a report to use a different shared data source on the portal. I click "Manage" on the ...
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 ...
1
vote
0answers
41 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 ...
0
votes
0answers
47 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
262 views

SSRS report expression FormatDateTime changes Nulls to '1/1/0001'

I have a report where I need to remove the time from a datetime column. I've found this expression to work but it changes all the null values to '1/1/0001' =FormatDateTime(Fields!...
1
vote
1answer
756 views

Migrate SSRS Reports to Power BI Report Server

I have to servers: one with the SSRS Report Server and a second server with the Power BI Report Server. The issue is I'm trying to migrate the SSRS Reports to the Power BI Report Server instance on a ...
0
votes
0answers
20 views

SSRS 2008R2 to 2016 report manager - has permissions model changed?

Has the permissions model changed in report manager from 2008R2 to 2016? I am working on a migration project at the moment and after doing a successful backup/restore of the ReportServer database to ...
1
vote
1answer
57 views

SSRS 2016 on SQL Server 2014

I have question about using SSRS 2016 on SQL server 2014 First of all, I don't have much experience with Reporting services. Company use SQL server 2014 and they have SQL database on it (DB is ...
3
votes
2answers
1k views

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 as SSRS 2016. I can get it running but it clashes with SSRS with URL reservations. I've configured ...
0
votes
1answer
16 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
1answer
2k views

Migrating SSRS from SQL Server 2012 to 2016

I have a requirement of migrating my whole SQL Server from SQL Server 2012 to 2016. I have already migrated the database engine part. Since I have not really worked on SSRS (reporting part), so need ...
0
votes
1answer
2k views

SSRS report ERROR “Could not load folder contents Something went wrong. Please try again later. ”

One of our report servers is raising errors when trying to reach it from clients computers and works just fine from the actual server. the error is: I found that it was a bug in sql 2016 using this ...
0
votes
1answer
293 views

Unable to log into SSRS through SSMS

I am trying to log into SSRS with SSMS to make a custom role. I am using my domain admin account that is able to log into the database engine side of things fine but when I try to go to reporting ...
1
vote
0answers
26 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 ...
2
votes
0answers
587 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 ...
1
vote
0answers
75 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
47 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?
0
votes
0answers
1k 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....
3
votes
3answers
1k views

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 ...
0
votes
1answer
51 views

SQL Server 2016 Licence [closed]

Hope you can help me out. My current SQL setup is as following Two SQL Instances (2012 and 2016) stacked on a single virtual machine. With the SQL components SSRS and SSIS 2016 installed on same. ...
4
votes
2answers
2k views

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 ...
1
vote
1answer
1k 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" ...
0
votes
1answer
271 views

SSRS 2016 Scale out deployment

Got 2 Servers in Scale out deployment and connection is through a load balancing URL. 1) SSRS01 2) SSRS02 Everything works fine when the session is running from SSRS02 but keep getting the error ...
1
vote
0answers
257 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
1answer
1k views

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 ...
0
votes
1answer
52 views

ssrs how to make the report available to my local machine

I have been struggling in Configuring Report Server URLs for a certain reporting services server. when I am in the server itself, the url works fine as you can see on the picture below. but trying ...
1
vote
0answers
94 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
434 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
246 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 ...
0
votes
1answer
65 views

How to implement Sql Server 2016 mobile publisher on existing Report Server

Currently working on sql server 2014 (SSRS 2014) on window server 2012 R2. Requirement is to publish Sql Server mobile publisher report on report manager on SSRS 2014. I installed Sql Server 2016 ...
3
votes
0answers
1k 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" ...
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 ...
0
votes
2answers
694 views

Reporting Services 2016 Multiple Email Accounts

Is there a way to configure SSRS 2016 to be able to send email from more than one email account? I am looking to setup something that is department specific for our organization. Right now its ...
3
votes
0answers
540 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: ...
1
vote
1answer
1k views

Unable to access SSRS web URL outside Azure VM

I've configured SSRS in SQL Server 2016 on Azure VM. However I am unable to access the web URL outside of the VM. Since it is my test box I've tried disabling the firewall as well. Still didn't help. ...
2
votes
1answer
174 views

SSRS 2016 Datasource - SQL Server 2000 database

Looking to upgrade SSRS from 2008R2 to 2016. Can SQL Server 2000 databases be used as data source in SSRS 2016? And are there any other known issues that could come up with the migration?
1
vote
0answers
680 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
1answer
2k views

Can I use SSRS 2016 with SQL Server 2008 R2 database engine?

I don't know that much about the state of products offering reporting/analytics, but I first got into OLAP in the late 90s, with a data warehousing tool, but then didn't touch it again for a while. ...
7
votes
1answer
530 views

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. ...