Questions tagged [ssrs-2014]
SQL Server Reporting Services 2014, a web based reporting tool produced by Microsoft and bundled with SQL Server 2014.
31
questions
0
votes
0
answers
35
views
Whats needed to be changed if I'm moving SSRS DBs from a prod env to a test one?
I’m a bit confused on how I move the reporting database (and the temp one) from prod to test.
I know after moving DBs I need to export its encryption key, but I would like to not cause any report to ...
- 7,428
1
vote
0
answers
224
views
SSRS 2014 Report parts and Subreports redirects to http: instead of https:
I am looking to find a solution for the SSRS 2014 server redirects to http url instead of https for all the subreports and other report parts like subscription , security , datasources etc .
What I ...
- 11
4
votes
4
answers
4k
views
Copy SSRS reports to another server
I am new to SSRS and I have been tasked to copy the SSRS reports(from PROD) to another Server(QA).
I found many documentations that show how to migrate the reports by Restoring ReportServer, ...
- 41
0
votes
1
answer
398
views
Does SSRS report user needs database level permission?
I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...
- 1,061
0
votes
1
answer
991
views
SSRS 2014 Report - looking up single row from dataset
I have a table that I'm trying to report out on in SSRS-2014.
A cut down version of the table:-
TABLE_NAME FEE_NAME FEE_VALUE
PDE 1st year 100.00
PDE 2nd year 120.00
PDE ...
- 25
1
vote
2
answers
903
views
Reporting Services Database on different version
Just wondering if anyone has come across this scenario and can provide some advice.
We have a vendor application that only runs on SQL Server Reporting Services 2014. However, all of our other ...
- 51
1
vote
0
answers
50
views
SSRS: Oracle Data Sources Breaking After Server Updates\Restart
Our SSRS instance has several Shared Data Sources that hit Oracle databases. Whenever we do patching or the server restarts, these Data Sources seem to break. Any reports hitting them come up with the ...
- 733
2
votes
0
answers
443
views
How to Configure SSRS Web Service Port via Command Line
It is straightforward to change the TCP port of SSRS using the GUI (Reporting Services Configuration Manager) but I am trying to fully script the installation and config of our SSRS servers.
Is it ...
- 397
1
vote
1
answer
428
views
SSRS Reports Blank on Zebra Printer
I need assistance getting labels to print from SSRS 2014 to a Zebra GK420D direct thermal label printer. The labels show up when running the report but when I print them to the label printer, all that ...
- 97
0
votes
1
answer
343
views
SSRS Label Orientation
I'm trying to print labels on a Zebra printer in SSRS 2014 and the orientation is coming out wrong. In report builder, I set the page size to 4.15 x 1.15 with correct margins. Also, in report builder, ...
- 97
0
votes
1
answer
36
views
SSRS 2014 Exec Log gives the Service Account as UserName instead of Actual User name
I am using the below query for accessing the Users who are using the Application Reports.
SSRS 2014 gives the Service Account(IIS Account used for Application) as User Name instead of Actual User ...
- 1,590
1
vote
0
answers
581
views
Collation Conflict when patching SSRS
We recently upgraded our test database servers from SQL 2014 SP2 CU3 to 2014 SP2 CU10. Most of the servers are fine, but on 2 of them we are getting the following error when connecting to the ...
- 3,272
1
vote
1
answer
745
views
SSRS bulk permission update 2008R2 to 2014
I'm moving SSRS reports from a 2008R2 server to a 2014 server. I've moved all the RDLs with a 3rd party tool only to find none of the permissions exist on the target. I'm attempting to copy the ...
- 21
2
votes
0
answers
723
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 ...
- 21
0
votes
1
answer
66
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 ...
- 373
0
votes
1
answer
2k
views
SSRS Data Source enabled/disabled
This is completely lame that I cannot find it, so I have to ask. I know in the reportsmanager site where to enable and disable data sources. But where in the tables of the reporting database is this ...
- 642
0
votes
1
answer
356
views
sp_whoisactive in SSRS
I have setup sp_whoisactive as a report in SS Reporting Services so people less familiar with SSMS can run it and see what is happening when needed. I have it working good and BUT I can't seem to ...
- 501
2
votes
0
answers
251
views
Reporting Services Printing Issue
Whenever we apply a patch (recently with CU5), end users need are prompted for administrator credentials to print. In googling, I see many different suggestions, but nothing seems to work.
I have ...
- 1,126
2
votes
1
answer
3k
views
SSRS : Bug using SSL (https://)
We have an SSRS 2014 already in production and we want now use a secure site by linking it to a certificate (URL like "https://..."). So now the URL is fully qualified domain name(FQDN).
We can ...
- 2,838
1
vote
0
answers
4k
views
SS Reporting Services Issue
I am getting below issues while accessing SSRS.
Can anyone let me know if you have faced this issue before.
The RSReportServer.config file has been modified.
Report ServerWindows Service (...
- 1,590
1
vote
0
answers
2k
views
Changing row colour based on a group toggle - SSRS 2014
One of the tables in my report looks somewhat like:
Row Colour
Total grey
+Category white
+Category white
+Category white
+Category white
It's expandable to
Row Colour
Total ...
- 155
0
votes
1
answer
372
views
SSRS 2008 to 2014 Migration Excel Export error
We are working on migrating our SSRS from SQL Server 2008 to SQL Server 2014. After brining the reports over I have a set of reports that will execute just fine but when I try to perform a standard ...
- 2,109
2
votes
2
answers
354
views
Configuring SSIS,SSRS, and SQL Server - three server model
I have a requirement for a third party vendor application which requires SSIS and SSRS. The vendor had suggested this 3 server model, and my management is going ahead with the same. Three VMs are ...
- 625
0
votes
2
answers
2k
views
how to add a data source to SSRS - reporting services 2014?
For infomation as Create, Modify, and Delete Shared Data Sources (SSRS)
but I want to get this done quickly, so when I have been requested to add a new data source to our reporting services:
This is ...
- 16.4k
2
votes
2
answers
3k
views
SSRS 2014 - query running fine on management studio - report timing out - how to troubleshoot?
I had a problem in reporting services 2014 - all the queries in a report were running fine from management studio but timing out when running the report.
here is the message from the user:
what to ...
- 16.4k
3
votes
1
answer
2k
views
SQL Server 2014 Reporting Services issues
I have set up SSRS on MS SQL 2014 Dev Edition using the ReportServer built in account as the Service Account.
My machine name is: POUYASAGER
My local login is pyous
I have given the ReportServer ...
2
votes
1
answer
68
views
Can mirroring be used to upgrade SSRS?
Can you use mirroring to upgrade SSRS?
For instance, I've upgraded from SQL 2005 to SQL 2014 with mirroring.
SSRS is running on the same box as my database server. I'm going from SQL 2012 (11.0....
- 1,385
3
votes
1
answer
890
views
What does SSRS technically do when it expires the cache?
Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a ...
- 2,874
2
votes
1
answer
3k
views
Use Group Managed Service Account for SSRS
We have a production environment running SQL Reporting Services 2014. The service is running as a group managed service account domain\SSRSProdSvc$
We are now trying to change our test environment to ...
- 3,272
2
votes
1
answer
2k
views
Loading subscription slow in SSRS
I have a SQL Server 2014 test box with SSRS installed. The site loads ok and reports are quick. When I try to go to Subscribe the page takes over a minute to load. From there if I pick a schedule it ...
- 403
2
votes
1
answer
1k
views
Are there limits to SSRS 2014 RDL files going over to SSRS 2008 (or 2012)?
Is there any incompatibility with reports developed in SQL Server SSRS 2014, and then exported to .RDL files that will be imported into SQL Server 2008?
- 351