Questions tagged [ssrs-2016]
SQL Server Reporting Services 2016, a web based reporting tool produced by Microsoft and bundled with SQL Server 2016.
77
questions
0
votes
1
answer
14
views
Applying SpaceAfter/SpaceBefore to a Placeholder
I can't figure out how to increase/decrease the space between paragraphs for Textbox content that comes from a placeholder.
If I type multiple paragraphs of text directly into a Textbox, the ...
0
votes
0
answers
29
views
SSRS 2016 compatibility with SQL 2017 after SQL2016 upgrade
We have an SQL Server database engine on the 2016 version. We also have SSRS in the 2016 version. I plan to upgrade the SQL database engine from the 2016 version to the 2017 for it to participate in ...
- 5
0
votes
0
answers
25
views
SQL SSRS 2016 Page Not working Remotely
The SSRS link works locally and works on some users laptops but not others. Now I have checked, and its not a firewall issue - can access on port 80 from the problematic laptops to the SSRS server. It ...
- 193
0
votes
2
answers
59
views
SQL Server Reporting Server (SSRS) separation of dev, stg, and prd data
I have a single SSRS server available to me (it's a HA cluster) and am looking for a solution to logically separate dev/stg/prd data that isn't too burdensome to maintain. There is no option to stand ...
0
votes
0
answers
30
views
Checking Scale Out Deployment of SSRS using PowerShell
I logged on the SSRS server and from the SSRS Configuration Manager, I can check if it's a scale out deployment. But is there a way to check it using PowerShell? I want to automate this process and ...
- 1,039
0
votes
2
answers
253
views
Centralized reporting of SQL agent job status
We have a requirement to design some sort of reporting the status of SQL agent job status for all the sql servers in the org.
I am able to do it via querying dmvs in msdb directly for that instance ...
- 763
0
votes
0
answers
25
views
2016 - 2019 - Wrong SSRS Instance Processing Report Render Request
I have inherited a very weird anomaly in SSRS. A new SSRS instance was created using 2019 and it appears it is using the same ReportServer DB as previous 2016 instance. This may have been done to ...
- 463
1
vote
1
answer
287
views
SSRS 2016 Server capacity Planning - Hardware sizing
I wanted to estimate the required hardware configuration for SSRS 2016 with below user, and reports. SQLServer is used only for ReportServer db and datawarehouse is on another server.
Total Users base:...
- 111
1
vote
1
answer
94
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
1
answer
286
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 ...
- 11
1
vote
1
answer
28
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 ...
- 131
0
votes
1
answer
2k
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 ...
- 307
1
vote
0
answers
2k
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 ...
- 11
3
votes
2
answers
2k
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, ...
- 794
1
vote
1
answer
259
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 ...
- 11
0
votes
2
answers
725
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 ...
- 15.7k
1
vote
1
answer
3k
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.
...
- 15.7k
1
vote
0
answers
31
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 ...
- 507
2
votes
0
answers
3k
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 is ...
- 1,898
0
votes
1
answer
940
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 ...
- 1,898
0
votes
2
answers
661
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 ...
- 335
0
votes
0
answers
4k
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 ...
- 1,922
2
votes
0
answers
45
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 ...
- 121
3
votes
0
answers
1k
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 ...
- 875
0
votes
1
answer
581
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 ...
- 337
0
votes
0
answers
92
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
1
answer
45
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, ...
- 309
0
votes
0
answers
680
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 ...
- 763
1
vote
1
answer
2k
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 ...
- 255
1
vote
1
answer
241
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 ...
- 320
0
votes
1
answer
54
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
0
answers
80
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,295
0
votes
0
answers
113
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-...
- 1,295
0
votes
1
answer
3k
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,093
1
vote
1
answer
2k
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 ...
- 45
1
vote
1
answer
174
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 ...
4
votes
2
answers
4k
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 with SSRS 2016. I can get it running but it clashes with SSRS with URL reservations.
I've configured ...
- 3,175
0
votes
1
answer
23
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 ...
- 95
0
votes
1
answer
7k
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. I have not really worked on SSRS (the reporting part), so I need ...
- 387
1
vote
2
answers
11k
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 ...
- 335
0
votes
1
answer
1k
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 ...
- 320
1
vote
0
answers
67
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 ...
- 97
2
votes
0
answers
2k
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 ...
- 9,282
1
vote
0
answers
122
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 ...
- 857
1
vote
1
answer
294
views
how to update SSRS execution account automatically through powershell?
I need to update the password for the SSRS Execution account for every 15 days. How can I automate this process using powershell or some other scripting?
0
votes
0
answers
4k
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....
- 293
3
votes
3
answers
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 ...
- 197
0
votes
1
answer
57
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.
...
- 63
6
votes
2
answers
8k
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 ...
- 289
2
votes
1
answer
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"
...
