Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
149
questions with no upvoted or accepted answers
1
vote
0
answers
5k
views
SSRS Error : Could not connect to server, ( since the TLS 1.0 was disabled)
Since the recent patch where TLS 1.0 was disabled and 1.1, 1.2 Enabled , we are having issues where the SSRS in the server cannot make connections to the Database server.
We had to re-enable TLS1.0 ...
1
vote
0
answers
991
views
SSRS 2016 Connect to SQL Server with Force Encryption Enabled
I have 2 Windows 2012 R2 servers in different VLANs. One is an IIS app with SSRS 2016 installed and the other is running SQL Server 2016. I can successfully open the SSRS site on the app server side ...
1
vote
0
answers
874
views
SSRS reports broke after upgrading from 2014 to 2016
One of my team members upgraded the SSRS and SQL servers from 2014 to 2016. Now, rather than doing an upgrade i.e. use existing databases - they uninstalled 2014 and did a fresh install of 2016 for ...
1
vote
1
answer
119
views
An SQL update query works fine unless it is invoked by an SSRS subscription. Why?
A stored procedure that updates data in production data tables was written by a very talented staff member (with developer-only rights) and works fine when executed in SSMS. However, the same SP does ...
1
vote
0
answers
273
views
SSRS - Embed Rich Text (including images) in report
An application my organization is developing includes a rich text editor. The content from this editor (text, tables, images, etc.) is HTML5 and is saved to the database. I'd like to find a way of ...
1
vote
0
answers
33
views
SSRS 2016 WebURL not opening
I have configured my SSRS 2016 weburl after installation.When opening weburl it is given error ..
HTTP Error 503. The service is unavailable.
Tried all the possible options given on internet.
Could ...
1
vote
0
answers
2k
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 ...
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 ...
1
vote
0
answers
233
views
Setting user accounts for Form Authentication SSRS
Is there a separate procedure to set up user/log in accounts for Form Authentication in Reporting Service? Can you refresh me on this? I am having difficulties with Log in to my report server. All I ...
1
vote
0
answers
70
views
Connection to Reporting service fails in SQL Server 2012
I am trying out Form authentication in Reporting Service to work. But not successful. The problem is I can't connect to report server both from Management Studio and Report Manager.
Actually I am ...
1
vote
1
answer
46
views
Why SSRS use Share point server for deployment of reports?
I switched from Oracle platform to Microsoft SSRS.
Currently I am working on SSRS.
What is the use of Share point server for deployment of SSRS reports ?
1
vote
0
answers
150
views
Tracking Changes
I have an SSRS report with hierarchies for the company and their contact info. As these hierarchies change overtime, is there a way to track what has changed since the last run(run on a weekly basis)? ...
1
vote
0
answers
362
views
SSRS: UserName value in Subscriptions table, ExtensionSettings column
SSRS subscription to a Windows File Share. Is there a way to query for all the "credentials used to access the file share" in plain text? It appears that the UserName value in the ExtensionSettings ...
1
vote
0
answers
617
views
Select where table and column name are from another table
I know I need dynamic sql, but haven't gotten this to work:
I want to loop through a table and for each row, return the value of the field that is located by two columns for that row.
Master ...
1
vote
0
answers
17
views
Missing emails from a scheduled report
I have a scheduled report with a query used to determine the recipients. Every time the report runs, there seems to be a few people who are not receiving the emails.
I enabled SMTP logging, and indeed ...
1
vote
0
answers
744
views
Reporting services database was NATIVE, now it's UNKNOWN
After migrating a database from Sql Server 2012 to Sql Server 2014, we found a little problem.
It was told me that the reporting server was not used, so I just installed the SQL Server 2014 and ...
1
vote
0
answers
135
views
Date picker is dynamic in SSDT but not in SSRS
Running SQL Server 2012 SP1 and SSDT from same distribution. (VS2010)
When I display a report in SSDT the date selector on a date parameter is dynamic or responsive. When you click on the date (month/...
1
vote
0
answers
293
views
SSRS Dynamic Columns with Sub-report
I have a SSRS report with a set of dynamic columns presenting summary data. I want to run a sub-report under the grouped columns but the only way I can do this is to put the sub-report outside of the ...
1
vote
0
answers
195
views
SSRS Datasource Escape Password
I am using a dynamic datasource inside a SSRS report to display detailed metrics about an instance. This dynamic datasource uses a SQL Login to connect to each instance listed by this report.
The ...
1
vote
0
answers
1k
views
SSRS Consuming a Single Core
I have production SQL Server machine with 10 separate instances on it: The last instance that was added included an install of SSRS. Since that time I've seen high CPU usage on a random single core (...
1
vote
0
answers
38
views
Will SSRS User rights be over-ridden by Windows account?
If a Reporting Services user group has all rights on SRS Report Server folder, and one of the group member's Windows Account has been added to the folder with Browse only, will SQL server cause that ...
1
vote
0
answers
829
views
How to handle many columns / variable schema?
I apologize in advance in case this question has been asked already.
I'm working on revamping a reporting application used within my company. The requirements are:
Support addition of new fields (...
1
vote
0
answers
3k
views
SSRS 2012 - Dynamically change value of textbox in report header
I am in the process of converting some MS Access 2003 reports to SSRS 2012 (using VS 2010 to develop the reports). I have a report with a number of parameters. Some of the parameters are populated ...
1
vote
0
answers
1k
views
SQL Server Reporting Services (MSSQLSERVER) Process using high memory
We have the Reporting Services installed on our database but we are not actually using it. Generally, the running process takes up a few MB but all of a sudden it has jumped to 4GB. We have restarted ...
1
vote
0
answers
256
views
Using #temp to work around Reporting Services blocking issue
Having utterly failed to resolve why a perfectly acceptable but admitidly large stored procedure was suffering the blocking process lck_m_s when called via a report in SQL Reporting Services I have ...
1
vote
0
answers
2k
views
SSRS 2008 report fast in test, slow in production: parameter sniffing problem?
We recently had an issue with reports running in an integrated SharePoint environment where the report runs fine in development, test and staging, but very slow (times out) in production. Running ...
1
vote
0
answers
1k
views
SSRS Remote Database Connection Issue
I have installed SSRS 2008 R2 on Windows 2012 server. It is up and running. In the Configuration Manager, I have set it to point to remote Database on same network.
Then on my own PC (also on network)...
1
vote
0
answers
137
views
SQL Server Reporting Services Upgrade/Migration
I couldn't find any documentation on this. I'm currently doing a dry run of SSRS 2005 to SSRS 2008 R2 upgrade/migration. I've backed everything up (encryption key and configuration files) and did a ...
1
vote
0
answers
978
views
SSRS switch statement
I have a report with a variable number of columns. I can hide columns with the ismissing function based on an expression like Iif(Fields!Site.ismissing, true, false). However, the hidden columns still ...
1
vote
0
answers
3k
views
How to change x-axis labels in a report
I am creating a trend report, in which the x-axis labels are first laywr as year (2014), second quarter (1,2), third period (month) (3,1), fourth week (3,4,5,1,2).
I need to change these labels as ...
1
vote
0
answers
1k
views
Problem with sorting matrix groups in SSRS
I've hit the following issue in SQL Server 2005 Reporting Services
This is a slightly odd and complicated situation: I have a table containing various groups and within each group is also embedded a ...
1
vote
0
answers
2k
views
SSRS Timeline Chart for each day / minute
I'm asked to make a Timeline Bar Chart with SSRS 2012.
There should be 1 chart per day/employee, and this chart should have a x-axis of 1440 minutes (or 24 hours).
The bar should have 2 different ...
1
vote
0
answers
5k
views
SSRS report viewer - log on failed (rsLogonFailed)
I was redirected here from StackOverflow...
I have set up a web based report viewer using the SSRS reportviewer control (sql server 2008 r2) including the ability to specify credentials.
When I ...
1
vote
0
answers
85
views
summary column in ssrs2005 matrix
Hi I create a monthly sale report. there is a week-to-date column at the end of each week, then the end of report, I need to a month-to-date column. The the column will display date and the row will ...
1
vote
1
answer
1k
views
how to rebuild / reinstall ssrs (reportserver, reportservertempdb) databases?
Our server crashed. We got it back up and running however, the mentioned databases have been corrupted.
Is there a programmatic / automatic way of rebuilding or reinstalling the SSRS databases?
If ...
1
vote
1
answer
527
views
SSRS Encryption Key backup location
I would like to know if there is any metadata table/registry entry where we can find the backup location of SSRS Encryption Key.
I am working on a power shell report to display the Encryption Key ...
1
vote
1
answer
427
views
Does reporting webservice url contain the function that helps to export the report to the client version?
The reporting webservice url contains the webservice url that contains all the information of the Reports which are created in SSRS. As the report has been created on reporting service, i want to ...
0
votes
1
answer
31
views
Bulk Fix Datasources on imported SSRS Reports
I've been using ReportingServicesTools, a powershell tool for managing SSRS to migrate from a 2016 SSRS server to an SSRS 2022 server. Reports came over, datasources came over, yet every report gives ...
0
votes
0
answers
32
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, ...
0
votes
0
answers
16
views
SSRS Health check \ assessment scripts
I m looking to do an health check on SSRS instance similar to the health checks we have for a SQL Server. How would one go about this? Which kind of metrics that can be collected for this?
0
votes
0
answers
100
views
How to add logout button IN SSRS web page?
I have such question. Is it possible to add logout functionality for current user IN SSRS web page in browser?
0
votes
1
answer
178
views
UPDATE table vs JOIN performance
I currently have a query with roughly 10 JOIN statements that takes about 10 seconds to run. I have this displayed as a report on SSRS.
Would it be better to create a table in SQL server and run ...
0
votes
0
answers
456
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 ...
0
votes
1
answer
94
views
Need to urgently stop a data driven subscription from sending a multitude of emails
can someone please help me so that I can have a job tomorrow. Fairly new at this and I've searched and tried several suggestions on this site to no avail. I made an error in my data driven script ...
0
votes
1
answer
178
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
78
views
Stop column names from being altered in SSRS Report Builder 15.0
I'm encountering an issue where Report Builder is arbitrarily removing characters from field names, and also adding spaces in front of capital letters in others. See image for example: two of them had ...
0
votes
0
answers
40
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 ...
0
votes
1
answer
141
views
SSRS - Backup Encryption Key from SSMS
I have a SQL Server with SSRS installed.
Note that SQL runs as NT Service\MSSQLSERVER
SSRS runs as NT SERVICE\SQLServerReportingServices
Version: SQL Server 2017
I am trying to automate the backing up ...
0
votes
0
answers
63
views
SSRS - Query CMS and Get Disk Space
We're using SQL Server 2019
I have CMS setup and have a query that returns current disk space usage on each registered instance. I can run the query successfully from CMS and get the results I'm ...
0
votes
2
answers
202
views
server trigger for Always On failover
I am working on a solution for a quite specific problem with environments (SQL Server using AO, with two replicas) having SSRS in scale-out, each node has MSSQL and SSRS installed, and when there is a ...