Skip to main content

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
0 answers
43 views

SSRS - Microsoft.ReportingServices.Diagnostics.Utilities

I am troubleshooting an error in SSRS we want to alter a subscription and set it to the next 5 min from now, but when it gets there it does not run. other than that, I see these error messages in the ...
Marcello Miorelli's user avatar
0 votes
0 answers
82 views

How to find a deleted SSRS subscription that still runs

In troubleshooting an 'SSRS won't email subscriptions' problem I created a test subscription. I then found the SQL Agent job and changed the owner (I read the disclaimer in the job description, ...
dogyog's user avatar
  • 101
0 votes
0 answers
112 views

SSRS 2016 running slow with blocking

SSRS 2016 - Standard Default Settings. Work Horse for Reporting. Some large reports can run 5 hours+. Most reports cannot be optimized/tuned - 3rd party vendor. On occasion noticed procs "...
jay's user avatar
  • 31
0 votes
0 answers
641 views

Report Server WMI Provider Error: Invalid namespace when connecting to Report Server Instance on Reporting Services Config Manager

I have two SQL Server 2016 instances (Instance A and Instance B) on the same server. Both instances have SSRS. At one point I upgraded Instance A to SQL Server 2019 but then due to the changes made to ...
Solizmi's user avatar
0 votes
1 answer
247 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 ...
iAwardYouNoPoints's user avatar
0 votes
0 answers
49 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 ...
mk SQL's user avatar
  • 5
0 votes
0 answers
45 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 ...
Daniel Nash's user avatar
0 votes
2 answers
212 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 ...
iAwardYouNoPoints's user avatar
1 vote
3 answers
491 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 ...
Newbie-DBA's user avatar
0 votes
0 answers
30 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 ...
Ross Bush's user avatar
  • 567
1 vote
1 answer
437 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:...
Sudhakar Chavan's user avatar
1 vote
1 answer
115 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 ...
Marcin Wilczek's user avatar
1 vote
1 answer
476 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 ...
Josh's user avatar
  • 11
1 vote
1 answer
29 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 ...
halfwind22's user avatar
0 votes
1 answer
3k 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 ...
user1664043's user avatar
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 ...
Mister_Moto's user avatar
3 votes
2 answers
3k 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, ...
NateJ's user avatar
  • 804
1 vote
1 answer
415 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 ...
user203633's user avatar
0 votes
2 answers
897 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 ...
Marcello Miorelli's user avatar
1 vote
1 answer
4k 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. ...
Marcello Miorelli's user avatar
1 vote
0 answers
34 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 ...
Feivel's user avatar
  • 507
2 votes
0 answers
4k 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 ...
SQLPRODDBA's user avatar
  • 1,908
0 votes
1 answer
2k 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 ...
SQLPRODDBA's user avatar
  • 1,908
0 votes
2 answers
832 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 ...
sql_girl's user avatar
  • 345
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 ...
Rajesh Ranjan's user avatar
2 votes
0 answers
46 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 ...
Sethen's user avatar
  • 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 ...
Dave Mason's user avatar
0 votes
1 answer
812 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 ...
user3325655's user avatar
0 votes
0 answers
108 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
Nethaji.R's user avatar
1 vote
1 answer
51 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, ...
jdids's user avatar
  • 309
0 votes
0 answers
884 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 ...
Newbie-DBA's user avatar
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 ...
DBA Greg14's user avatar
1 vote
1 answer
373 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 ...
Thorin's user avatar
  • 320
0 votes
1 answer
64 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 ...
Nishley Fagoone's user avatar
1 vote
0 answers
82 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 ...
user9516827's user avatar
  • 1,315
0 votes
0 answers
126 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-...
user9516827's user avatar
  • 1,315
0 votes
1 answer
4k 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!...
Geoff Dawdy's user avatar
  • 1,133
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 ...
Vladimir's user avatar
  • 145
1 vote
1 answer
195 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 ...
Andrej Hafner's user avatar
4 votes
2 answers
5k 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 ...
Sir Swears-a-lot's user avatar
0 votes
1 answer
25 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 ...
Bill Hughes's user avatar
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 ...
SSS's user avatar
  • 397
1 vote
2 answers
14k 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 ...
sql_girl's user avatar
  • 345
0 votes
1 answer
2k 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 ...
Thorin's user avatar
  • 320
1 vote
0 answers
77 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 ...
JonDBA5420's user avatar
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 ...
John Eisbrener's user avatar
1 vote
0 answers
123 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 ...
Shooter McGavin's user avatar
1 vote
1 answer
351 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?
hadrian blackwater's user avatar
1 vote
0 answers
5k 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....
GregDBA's user avatar
  • 303
3 votes
3 answers
4k 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 ...
Moby Duck's user avatar
  • 197