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
0
votes
0answers
11 views

SSRS Filter Expression in Query Designer

I have a report that I need it to filter the results from last month. I have tried adding =Format(DateAdd("M", -1, Today()), "yyyy-MM") but this only works in the report itself and not in the query. ...
1
vote
1answer
115 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 ...
0
votes
1answer
26 views

Dont' see option to download/upload some SSRS reports

I have a SSRS 2016 instances with 100s of reports on one of my server. I want to migrate these reports from this instance to an existing new instance which already has some reports for different ...
0
votes
0answers
26 views

Getting extra " double quotes while downloading report to TEXT or CSV

Recently developers created a report where they are concatenating each value of each column with " (double quote) in between. Like select '"'+first_name+'"'+last_name+'"' from table_name; On the ...
0
votes
0answers
9 views

SSRS Fileshare subscriptions overwrite options

We are running subscriptions on a nightly basis that saves the output in Excel format to a corporate fileshare.The subscriptions run at 2AM in the morning and set to overwrite the existing file. We ...
0
votes
2answers
21 views

Migrating ssrs reports between different domains

I have an SSRS server in Domain A and i was asked to copy all the folders and reports from domain A to an SSRS server in domain B. The network team has opened the ports between the two servers in the ...
0
votes
0answers
309 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 ...
2
votes
0answers
33 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
195 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
31 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
95 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
27 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
23 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
29 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
43 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
165 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 ...
1
vote
1answer
29 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
62 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
47 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
59 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
417 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
1k 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 ...
1
vote
1answer
73 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
2k 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
3k 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
3k 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
408 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
27 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
831 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
90 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
58 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
2k 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. ...
5
votes
2answers
3k 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
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" ...
0
votes
1answer
294 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
265 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 ...
2
votes
1answer
2k 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
57 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
102 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
463 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
298 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 ...