Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [ssrs]

SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.

Filter by
Sorted by
Tagged with
1 vote
1 answer
26 views

Create variable column pivot table for RDLC

I need to create a rdlc report that has variable columns. Here is a sample of the data: select '123abc' as SchoolId, 'Hoover' as SchoolName, 'JoeBob' as StudentId, 'Jumping' as Activity, 12 as amt ...
Deleted_User's user avatar
0 votes
0 answers
24 views

Seeking Guidance on Automating SSRS Report Deployment Using a DevOps CI/CD Pipeline

I'm a DevOps engineer with some experience in automating the deployment of Tableau workbooks via GitHub Actions and Python and Tableau API. My current setup involves: Utilizing GitHub Actions with ...
Tony Adolph's user avatar
0 votes
1 answer
50 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 ...
Ben Brocka's user avatar
  • 2,063
-1 votes
1 answer
24 views

SQL statement with multiple subqueries (as separate fields in same recordset)

I am trying to create SQL statement for a DataSet (in SSRS) that selects the sum of a field - grouped at different date ranges within the table - and make them separate "fields" available ...
CoachChris53's user avatar
0 votes
0 answers
47 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
22 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?
Maharajan Eswaramoorthy's user avatar
0 votes
0 answers
146 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?
Robert Margaryan's user avatar
0 votes
1 answer
297 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 ...
Bigbob23's user avatar
  • 121
0 votes
1 answer
106 views

SSRS 2016 - How to Add Custom Web Portal Connection

We are replacing an old VM which was configured with reporting services 2016. The Web Service and Web Portal URL's were configured for both a "public" URL which looks nicer as well as a URL ...
rickandm00rty's user avatar
0 votes
0 answers
537 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
2k views

SSRS 2019 not available/working

I installed 2019 SSRS on 2019 SQL Server and after I configured everything in the configuration manager, I can't see the services for SSRS under sql server config manager and also when I tried to run ...
WhoIsNotActive's user avatar
0 votes
1 answer
112 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 ...
Wondering's user avatar
0 votes
1 answer
217 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
1 answer
30 views

SSRS with remote ReportServer db - where to focus cpus/memory for processing

On an SSRS instance with a remote ReportServer db, where is the processing done? Should the SSRS instance vm get additional cpus and memory or the sql instance where the ReportServer db is? The ...
Bobogator's user avatar
0 votes
1 answer
124 views

Installing SSIS, SSAS and SSRS on a separate Server

Please is there any benefit from installing SSIS, SSAS and SSRS on a separate server from the SQL Engine instance? Apart from additional license implications, are there any other considerations for ...
PTL_SQL's user avatar
  • 341
0 votes
1 answer
594 views

Service Account in SSRS 2019 Configuration

I have two questions please: BOL tells me that Group Managed Service Accounts (gMSAs) are not supported as a report server service account. BOL Reference - Configure the Report Server Service Account ...
PTL_SQL's user avatar
  • 341
0 votes
1 answer
501 views

Adding SQL Server Reporting Service to an existing SQL Server 2019 instance

Can anyone help please? I have an existing SQL Server 2019 instance to which I am trying to add Reporting Server. The Installation Centre takes me to a link on the internet where I can download the ...
PTL_SQL's user avatar
  • 341
0 votes
1 answer
383 views

Add parameterised hyperlink to SSRS report list

We have a single SSRS report with a lot of parameters. End-users would like to have a single-click hyperlink that runs the SSRS report with the parameters pre-selected - that appears to be possible (...
user1913559's user avatar
1 vote
1 answer
657 views

How to pass parameters to a Snowflake query in SSRS

Where SQL Server is a data source, one can simply, write: SELECT name, age FROM egTable WHERE age = @age in the dataset query part of an SSRS report. However, if your dataset is connected via ...
Koketso M's user avatar
0 votes
0 answers
43 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
151 views

SQL Server/SSRS is using case to build where a clause feasible?

What I'm doing seems like it should be an SSRS/SQL trope with best practices, but I spent the better part of yesterday trying to google and test this with no luck: I have two parameters: param_date ...
Jimbus's user avatar
  • 25
0 votes
2 answers
181 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
0 answers
29 views

SSRS not using MSA or gMSA account on Domain [duplicate]

I am trying to install SSRS on a new server to report on our new database server and want to use a MSA account on our domain (server is on our domain) but I keep getting errors when trying to start ...
Nik's user avatar
  • 11
1 vote
0 answers
194 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 ...
divyasridhar's user avatar
0 votes
1 answer
153 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 ...
Sicilian-Najdorf's user avatar
1 vote
0 answers
108 views

Get e-mail addresses of failed subscriptions for SSRS data driven subscription

We are using SSRS Enterprise and have implemented data driven subscriptions. We have implemented a monitoring solution to inform us of failed sends. However, even after increasing verbosity to the max ...
Evan Barke's user avatar
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 ...
jdids's user avatar
  • 309
0 votes
2 answers
215 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 ...
Carlos DBA's user avatar
0 votes
2 answers
93 views

How to limit which NUMA nodes are used by SQL Server / SSRS?

I have SSRS and SQL Server running on same physical server (2 NUMA nodes). How do you configure SQL Server and SSRS to use separate NUMA nodes? I just didn't want SQL Data Engine to potentially ...
user2368632's user avatar
  • 1,097
0 votes
1 answer
381 views

Divide by 0 error in ssrs

I have an SSRS Report with a lot of calculations. I have a function with the report that supposed to take care divide by 0 error but I still get the error. The function code is ` Function Divide(...
Jeannie Ramirez's user avatar
0 votes
1 answer
209 views

Microsoft SSRS - Can users view a report based on a database they have no permissions to?

I'm having trouble understanding the report server permissions mechanism. If I were to create a report based on a database, would other users be able to view it even though they have no permissions ...
עומר אנגי's user avatar
0 votes
1 answer
563 views

SSRS Encryption errors post reinstall services

Initially, I installed and configured SSRS and backed up Encryption Keys, able to run reports successfully. Then I uninstalled the SSRS from the VM, dropped report databases, renamed the SSRS folder ...
Kris's user avatar
  • 432
0 votes
0 answers
495 views

SSRS Delete Users Via TSQL

We want to remove SSRS users via TSQL rather than manually deleting their permissons via the reporting services admin page. Testing on SQL 2017 dev edition We have a script that does run and does ...
Stockburn's user avatar
  • 419
1 vote
1 answer
777 views

Can you merge multiple SSRS instance databases to a new instance on 2019

I have a customer consolidating and upgrading two different SQL instances into a new 2019 cluster. Both of those older instances have an SSRS deployment on them. 2019 doesn't allow multiple SSRS ...
Gavin Harris's user avatar
0 votes
2 answers
31 views

SQL Report Services on AOAVG

We have 2 SQL Servers in a SQL Server 2016 AOAVG. When we fail over to the secondary replica, the reports do not work. Am I right in thinking that this is because we need to stop the SQL Server ...
AngryDog's user avatar
0 votes
0 answers
1k views

Unable to configure SQL Reporting Services to use Kerberos

We are trying to enable Kerberos with our SQL Server Reporting Services reports manager website (for ex, instructions in the article "Configure Windows Authentication on the Report Server") ...
ifandelse'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
  • 505
0 votes
1 answer
603 views

Return SQL Agent Job status in SSRS when executing job from SSRS

I'm calling a SQL Agent job from SSRS and using a parameter to determine which job to run. I can run the job(s) just fine. What I'm looking to do is return a message back to the user based on the job ...
jdids's user avatar
  • 309
0 votes
0 answers
1k views

How to identify slow-running SQL Server reportng ssrs reports

I want to list all the reports that run slow so I can review the SQL code to see if any performance improvements can be made. On the ReportServer database I have the executionlog table, which columns ...
user avatar
0 votes
0 answers
63 views

Product Version for Analysis Services and Report Server using T SQL

How can I find the product version for both analysis services and report server using Transact-SQL? I'm trying to put together a query that will get me the details of each SQL instance with their ...
Drewbert's user avatar
  • 131
0 votes
1 answer
110 views

SSRS Portal Menus missing on remote node

New security maybe? The Data Source added to the root is not seen on the remote node but the Reports folder is and if I create a Data Source in the Reports folder I can then see them on the remote ...
Tanquen's user avatar
0 votes
1 answer
100 views

I changed permission of SQL Server Reporting Services through SQL Server Management Studio

Now I can't access Reporting Services through SSMS. I can't even connect to Reporting Services now.
user avatar
0 votes
1 answer
3k views

Find what queries are reports using on SSRS

EDIT: It seems they're using "semanticQuery" and this is why I cant see usefull information? We will be decommissioning one of our functions, and we noticed that some reports are still ...
Racer SQL's user avatar
  • 7,386
0 votes
2 answers
6k views

Anonymous Access to SSRS Report

We're looking to have a RaspberryPi run in kiosk mode and automatically pull up a report on our SSRS portal without any user interaction. I'm hoping I can allow anonymous access to this specific ...
jdids's user avatar
  • 309
-1 votes
1 answer
70 views

Question about Key lookups

I have a table with 100 columns. The Primary key and clustered index are on the column Id - IX01_Id. I have a non-clustered index on Col2 - IX02_Col2. I have 3 stored procedures that return the ...
joemac12's user avatar
0 votes
0 answers
468 views

Report Builder "Select All"

I have SSRS Report that is based on user's decision to bring data from selected Procedure. I have 5 parameters: @Country, @StartDate, @EndDate, @MinLenght, MaxLenght When user Selects Just one value ...
Hamza's user avatar
  • 1
1 vote
1 answer
782 views

SSRS second entry never shows up in scale out deployment screen

I am trying to setup two SSRS servers in a scale-out deployment that use a Always-On availability group for the database. The AG is setup and working. I have both SSRS servers using the AG listener ...
Chuck Herrington's user avatar
1 vote
0 answers
934 views

To add data source in SSRS 2019 and prompt saying "Something went wrong, please try later"

On my machine I installed SSRS 2019 and connecting with the remote DB Server (SQL Database engine 2019) and connection is OK. While creating a data source in web portal (http://SERVERNAME/ReportServer/...
DRST's user avatar
  • 19
0 votes
1 answer
57 views

How to access & display measure description in SSRS?

I have an SSAS tabular model with many measures. Each measure has a the Description property defined in the tabular model. In my SSRS report, I would like the measure Descriptions to be displayed (...
Steve's user avatar
  • 21
0 votes
1 answer
497 views

Will an SSRS report on Azure SQL Database work?

Can we build an SSRS report using Visual Studio 2019 with Azure SQL server as PaaS mode? We migrated to Azure Database from VM SQL Managed instance.
Ramakrishna.p's user avatar

1
2 3 4 5
12