Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
592
questions
0
votes
1
answer
25
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 ...
- 121
0
votes
0
answers
15
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 ...
0
votes
0
answers
154
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 ...
- 1
-1
votes
1
answer
207
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 ...
0
votes
1
answer
44
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
55
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
1
answer
24
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 ...
- 83
0
votes
1
answer
67
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 ...
- 303
0
votes
1
answer
169
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 ...
- 303
0
votes
1
answer
164
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 ...
- 303
0
votes
1
answer
156
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 (...
- 103
1
vote
1
answer
263
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 ...
- 21
0
votes
0
answers
37
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 ...
- 1
0
votes
0
answers
33
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
75
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 ...
- 15
0
votes
2
answers
93
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 ...
1
vote
0
answers
28
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 ...
- 11
1
vote
0
answers
120
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
0
votes
1
answer
83
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 ...
- 319
0
votes
0
answers
210
views
Using ReportingServicesTools to change the connection string of a PowerBi report
We're migrating to a new SQL Server instance and I'm trying to change the connection strings in our PowerBI reports via PowerShell and ReportingServicesTools.
Basically, all I need to do is to change ...
- 43
0
votes
0
answers
78
views
How to address issue on dtsx job failing that has © symbol on the package
We're on the process of upgrading the ssis/ssrs sql server from sql 2014 to sql 2019, There are a couple of jobs that has a copyright symbol © that keeps on failing with error below. When we tried to ...
- 1
0
votes
0
answers
68
views
SQL Server Reporting Services (SSRS) running on an Amazon RDS for SQL Server Certificate Question
We're attempting a POC using an Amazon RDS for SQL Server instance as our SSRS backend and the question came up whether or not we can use our own certificates instead of the default RDS CA. Haven't ...
- 31
1
vote
0
answers
92
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 ...
- 33
0
votes
0
answers
37
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,157
0
votes
0
answers
101
views
Is there a built-in field or other way to put the rdl date/time stamp on a SSRS report template?
I've put the built-in fields for the report server and the report name at the bottom of my reports. I want to also put the date/time stamp of the report's .RDL file on it so we can see if the report ...
0
votes
0
answers
47
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 ...
- 309
0
votes
2
answers
137
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 ...
0
votes
2
answers
86
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 ...
- 1,087
0
votes
1
answer
226
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(...
0
votes
1
answer
134
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 ...
0
votes
1
answer
400
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 ...
- 412
0
votes
0
answers
382
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 ...
- 427
1
vote
1
answer
599
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 ...
- 13
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 ...
- 1
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") ...
0
votes
0
answers
28
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 ...
- 495
0
votes
1
answer
494
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 ...
- 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 ...
user3306489
0
votes
0
answers
56
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 ...
- 131
0
votes
1
answer
91
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 ...
- 1
0
votes
1
answer
91
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.
Curious Kid
0
votes
1
answer
2k
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 ...
- 7,364
0
votes
2
answers
5k
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 ...
- 309
-1
votes
1
answer
69
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 ...
- 53
0
votes
0
answers
418
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 ...
- 1
1
vote
1
answer
579
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 ...
- 191
1
vote
0
answers
795
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/...
- 19
0
votes
1
answer
46
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 (...
- 21
0
votes
1
answer
448
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.
- 113
0
votes
0
answers
144
views
Report server (SSRS) email delivery delayed for 10 hours
Weird thing happened the other day.
Around 2 am there are lots of subscriptions fires on report server that sends emails.
Users received some of them, but not all.
Then around noon, all of the sudden ...
- 657