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
1answer
8 views

SSRS output to file subscription not working

I'm new to Reporting Services. We have SSRS 2017 set up on a Windows Server 2019 Standard box. I've got my report all written and tested but given the size of the output, I'm trying the subscription ...
0
votes
0answers
21 views

SSRS report stuck on loading screen

We use SSRS on SQL Server 2016 and on it have a skype usage report run. This report is completly third party and was installed along with skype. All other reports seem to work fine but on this one ...
0
votes
0answers
50 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 ...
1
vote
1answer
39 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, ...
1
vote
1answer
18 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 ...
0
votes
2answers
25 views

What triggers the SSRS to generate a log file or modify a current one?

When running a trace on my new SSRS Reporting Services 2016, after troubleshooting some problems related to migrating from SSRS 2008, I find the following pattern running continuously: Here is the ...
0
votes
0answers
54 views

An item with the same key has already been added Error in Report Builder

An item with the same key has already been added Error in Report Builder Relevant SQL Server stored procedure executed successfully when we attach the data set to the Report builder after refreshing ...
1
vote
1answer
191 views

how to list the SSRS permissions in each folder in the reporting services server?

I have the following powershell script that downloads all the RDL from a reporting services server. I am not the author to whom I am very thankful. It has been very useful for downloading the RDLs. ...
1
vote
0answers
19 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 ...
0
votes
0answers
38 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
578 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
32 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
12 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
48 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
1k 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
34 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
310 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
41 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
12 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
31 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
1
vote
0answers
26 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
54 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 ...
1
vote
1answer
307 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
35 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
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
55 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
67 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
685 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
91 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
4k 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
4k 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
519 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
35 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
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 ...
1
vote
0answers
97 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
69 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
2k 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
54 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
4k 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
310 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
273 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
77 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
112 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 ...