Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
575
questions
-3
votes
0
answers
16
views
How to hide unwanted rows for each group?
I am working with my report where I have multiple locations so needed to group it by locations. In each location, I have two months of data to calculate the variance % but I want to show calculation ...
0
votes
0
answers
11
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 ...
0
votes
1
answer
43
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 ...
0
votes
0
answers
15
views
SSRS hanging when pulling a report through a web browser but not when running the SQL query directly from the DB
Good day
I need some advice I am having an issue when running a report from SSRS it hangs and eventually times out. However when I run the query from the SQL DB it completes within a few minutes.
The ...
0
votes
0
answers
37
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 ...
0
votes
0
answers
35
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 ...
0
votes
1
answer
15
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 ...
0
votes
1
answer
17
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.
0
votes
1
answer
40
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 ...
0
votes
3
answers
651
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 ...
0
votes
0
answers
30
views
SSRS - Cannot deploy a report (timeout, fixed by renaming the file from 37 to 28 characters long)
Edit: I have discovered I can deploy the file if I rename it to be shorter. The file name is 37 characters long. The path is 47 characters long, including the http prefix, server name and folder ...
-1
votes
1
answer
60
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 ...
0
votes
1
answer
68
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 ...
0
votes
0
answers
268
views
SSRS - User is in different domain - Failure sending mail: The permissions granted to user '' are insufficient for performing this operation
I have my servers in one domain, my users in a different domain (lets call this LAN1) and then some other users that are in still another domain (LAN2). For users in LAN1 there is no problems. They ...
0
votes
1
answer
102
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 ...
1
vote
0
answers
167
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/...
0
votes
1
answer
18
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 (...
0
votes
0
answers
142
views
The permissions granted to user '' are insufficient SSRS/Power BI
Does anyone know where to configure the account from this error message?
It does not seem to be set as it is blank and I can't find any documentation
on it.
The error message is coming when a ...
0
votes
0
answers
53
views
I can't deploy SSRS project due to timeout for a shared dataset
I can deploy my SSRS project to SSRS on one computer, but not on my laptop.
It belongs to an ASP.NET 5 solution.
The SSRS projects uses a shared datasource which connects to an SSAS instance(correctly ...
0
votes
1
answer
194
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.
0
votes
0
answers
44
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 ...
0
votes
1
answer
866
views
PL/SQL: Selecting multiple values from the same column
We have a table in which all kinds of different Words are stored with a unique id each. In other tables, certain fields which should contain words instead only contain the id of these words. Let's ...
1
vote
1
answer
43
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 ...
0
votes
0
answers
1k
views
Using Office 365 as mail server with SSRS 2019 on Server 2019 Azure VM - error message 'Failure sending mail:'
We have a Windows Server 2019 with SSMA 2019 installed. We also use Office 365.
in the mail settings I have smtp.office365.com, and a the username and password for an account that is set up in our ...
0
votes
2
answers
124
views
Delete rows from report based upon specific field value [closed]
I have found how to hide rows based upon a specific field value.
But is it possible to actually delete the rows from the report and not just hide them?
Steve
0
votes
1
answer
449
views
How do I use "Not Equal to" in SSRS?
How do I show a message if none of the rows returned have a specific value?
If all of the results in a report have a status of "OK", I want to return a message indicating that there were no ...
0
votes
2
answers
582
views
I want to exclude rows from an SSRS report based upon a field value and display a message if, as a result of filtering, there are no results
I have a report where I want to exclude most of the rows based upon a field value. That part is not so hard. The value that I am filtering out is "OK". so in the end the report only displays ...
1
vote
1
answer
140
views
Disabling the recycle timeout settings in SSRS
In order to prevent periodic recycling of the SSRS service it's been suggested to disable the <RecycleTime> setting in the RS server's config file. I believe disabling would require setting ...
0
votes
0
answers
319
views
Using gMSA account for SQL server reporting services
I am trying to configure SSRS on my VM:s via gMSA account which does not seem to work and unable to access the reporting url ( Web Portal URL) link to check configuration.
The requirement is to have ...
0
votes
2
answers
75
views
Delegation: Bulk Insert failed when executed from SSRS dataset but success from SSMS
I've configured delegation for SQL server engine and SSRS and it works fine.
SQL Server (2017) engine and SSRS installd on the same machine. Let's call it SqlSrv1.
What we should attain to:
User opens ...
0
votes
1
answer
310
views
SSRS subscriptions after failover
Shortly I will be migrating a 2008 R2 SSRS installation to a new SQL 2019 Always on AG in AWS. This one will contain subscriptions, and I have never dealt with them before. I read the documentation ...
0
votes
1
answer
692
views
SSIS cannot deploy package to SQL server - An error occurred during decryption 15466
After recovering and re-importing a backup of a SQL Server 2019 instance none of my SSIS packages will deploy from Visual Studio.
Whenever I try and deploy I get the error
=============================...
0
votes
1
answer
40
views
creating a Pie Chart in SSRS
how can I create the pie chart that displays the Count of columns with filters like ( Active Paths / Courses / Sections /----- this is my column name )from 4 different tables and combined them in one ...
0
votes
2
answers
31
views
SQL Server Reporting Server Migration
I have a separate database server and a separate reporting server. I would like to upgrade and migrate the database server to a separate server and do not to touch the reporting server. Since the ...
1
vote
1
answer
2k
views
Copy SSRS Subscriptions from one SSRS server to another
I am having to migrate reports and subscriptions from one SSRS server to another. I have already migrated the RDL and Datasources. I only have the subscription information to move. I am trying to use ...
0
votes
1
answer
77
views
SSRS : How to give parameter values in URL Http requests?
I created a dataset in an SSRS report and this dataset uses a parameter. Here is the request:
select { [Measures].[ID Distinct Count]} on COLUMNS,
non empty filter({ [DIM ANESTH].[PBM ANE NOM].[PBM ...
0
votes
1
answer
69
views
Report server scheduled job location
I inherited a SQL Server environment. In (database engine) SQL Server Agent are two jobs defined that apparently belong to the report server.
First and only step in the first job:
exec [ReportServer]....
1
vote
1
answer
288
views
SSRS - : How to make a conditional formatting for matrix by group?
I currently have a report produces a matrix, displayed per user group. (1 user group per page, with 35 user groups/pages)
I want to highlight the row in pink in this condition:
=IIf(Fields!...
0
votes
1
answer
337
views
Split value from a date range in to individual values per date
I am modifying a SSRS sales report for my customer. I have already calculated the number of days and based on that the daily value. In the software you set the start and end date of the agreement ...
1
vote
2
answers
53
views
in-place upgrade native SSRS without the SQL Server portion
We have a single server (2012R2) running SQL 2008R2 + reporting services native mode 2008R2
Can the reporting services portion be upgraded alone without the database engine?
Or can the SSRS db be ...
0
votes
1
answer
171
views
Handling Reporting Services and SharePoint Integration considering deprecation
With one of our clients, we're currently faced with a dilemma. SQL Server Reporting Services Report Server (SharePoint mode) seems to have been deprecated, since the last version to support it is SQL ...
0
votes
1
answer
150
views
SSRS Standalone install license [closed]
For performance reasons we are thinking about moving our SSRS installation to a separate server.
Since you can have a standalone installation of SSRS.
Question being, if we install SSRS (standalone) ...
0
votes
1
answer
285
views
Upgrade Advisor Or DMA (Database Migration Assistant)
We are migrating from SSRS 2012 to SSRS 2017.
MS documentation suggests - "Even though you are migrating rather than upgrading the installation, consider running Upgrade Advisor on your existing ...
0
votes
0
answers
247
views
Highlight Rows with Duplicate Column in SSRS Report Builder
I have used the below expression to highlight duplicate column
=IIf(Fields!BankAccount.Value=Previous(Fields!BankAccount.Value),"Firebrick","LightSteelBlue")
I have added another ...
1
vote
0
answers
98
views
SSRS Encryption key error after failover
I recently encountered an error after a planned failover of an AG to the secondary node after patching it. I am on SQL 2016 enterprise. we have the reportserver in the AG, but after failover I got ...
1
vote
0
answers
2k
views
SSRS 2019 with an oracle data source
I am working on migrating a number of reports from an SSRS 2012 install to a SSRS 2019 install. These are all pretty simple and straight forward reports, built in microsoft report builder. A number ...
1
vote
1
answer
26
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 ...
1
vote
1
answer
284
views
Reporting Services - Host header and Windows Authentication
SQL 2016 - Enterprise Edition
Windows 2016
Reporting Services runs on domain account (SPN registered for new host header)
Problem:
When adding a host header in Reporting Services Configuration tool, ...
0
votes
1
answer
1k
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 ...
0
votes
2
answers
754
views
In SQL Server Always On 2019 environment should SSRS/SSIS be on a separate server?
I am looking for some advice in setting up a new SQL Server 2019 Always On instance.
We have a 2 server cluster right now, moving to Always On with a similar two virtual server setup.
I want to ...