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

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 ...
7
votes
1answer
943 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. ...
5
votes
2answers
5k 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 ...
4
votes
2answers
3k 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 ...
3
votes
3answers
3k 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 ...
3
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 ...
3
votes
2answers
1k views

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 ...
3
votes
1answer
714 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
871 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
3answers
4k views

Why does SSRS not update a report's description?

I created a SSRS 2016 solution and deploy my reports. Each report has a "DESCRIPTION" property, that gets visible in the report's properties in report manager. There in the report manager, this ...
2
votes
1answer
706 views

Report Builder CTP 2.3 Installation DLL Error

I was attempting to install Report Builder CTP 2.3 and cannot get it to install on any of three tested systems. First system was Windows Server 2012 R2 Datacenter - MS Azure SQL 2016 preview image ...
2
votes
1answer
203 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?
2
votes
1answer
3k views

How to remove Report Server only?

I've gone ahead and configured the Report Server after SQL Server installation, and as part of that I've ended up with: 1) a report server database and 2) a link (I think in 2016 they call it Web ...
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
622 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
139 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 ...
2
votes
1answer
2k views

How can I start the SSRS 2016 Report Server?

I restarted my SSRS 2016 server. When I navigate to the Web Portal URL I get a "Service Unavailable - HTTP Error 503. The service is unavailable." message. How do I start the SSRS 2016 Report Server?
1
vote
1answer
19 views

Installation of SSRS

I have a doubt regarding SSRS installation. I see two methods on the web.However I am not sure if both lead to same solution. 1)Install SSRS via installer OF SIZE 105 mb. 2)Install Visual Studio ...
1
vote
1answer
111 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 ...
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. ...
1
vote
1answer
6k views

How do I add an existing shared data source and dataset to my SSDT/Visual Studio SSRS Project?

I am trying to add a shared data source and data set to an SSRS project in SSDT/Visual Studio, also called Report Designer. There are plenty of ways to add this into a Report Builder. I am looking on ...
1
vote
1answer
1k 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
1answer
778 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
57 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 ...
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
28 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
1answer
35 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, ...
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
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
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
1answer
1k 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!...
0
votes
1answer
5k 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
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 ...
0
votes
1answer
3k 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. ...
0
votes
1answer
6k 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
2answers
1k 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 ...
0
votes
2answers
90 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 ...