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
0
votes
0answers
3 views

SSRS - Cannot deploy a report (timeout)

I am trying to deploy a new report to a SQL 2016 Enterprise SSRS server. Previously I never have any issue with deploying report. When deploying, I get an error saying The request was aborted. The ...
-1
votes
1answer
58 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
1answer
41 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
0answers
44 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
1answer
46 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
0answers
77 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
1answer
13 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
0answers
55 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
0answers
37 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
1answer
99 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
0answers
25 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
1answer
423 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 ...
0
votes
0answers
22 views

Which authentication mode to connect to SSRS from .NET 5?

I wonder which authentication mode to use when accessing to an SSRS report server via .NET 5 app. I would like to use an HttpClient class, with the SendAsync method. I saw things like Basic ...
0
votes
0answers
48 views

Reporting & Logging Failing on SQL Server Job

System Info: SQL Server 2014 Enterprise, Windows Server 2012 R2, running on a VM I have a Maintenance Plan set up to perform a log backup of a database every 17 minutes. The job normally runs fine ...
1
vote
1answer
29 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
0answers
759 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
2answers
66 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
1answer
154 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
2answers
318 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
1answer
68 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
0answers
14 views

SSAS : 2 linked facts, how to get number of items in dimension attribute?

In an SSAS project there is a TRANSFUSION fact, linked to a PATIENT fact. A transfusion has many attributes, and among them there is the patient who received the transfusion. A patient can receive ...
0
votes
0answers
83 views

Decrypt the DSN section of RsReportServer.config file

The DSN section of the RsReportServer.config file contains the encrypted connection string to the PowerBI Report server databases. I noticed that the DSN string changes everytime I make any changes ...
0
votes
0answers
191 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
2answers
60 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
1answer
203 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
1answer
438 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
1answer
31 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
2answers
28 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 ...
0
votes
1answer
1k 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
1answer
59 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
1answer
41 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
1answer
199 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
1answer
60 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
2answers
31 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
1answer
131 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
1answer
125 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
1answer
226 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
0answers
152 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
0answers
87 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
0answers
1k 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
1answer
23 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
1answer
176 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
1answer
679 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
2answers
538 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 ...
1
vote
1answer
849 views

Adding checkboxes in SSRS reports to filter values on a table

I am trying to create a report that would list records but I need some way to include or exclude some values probably by using some form of option like a checkbox or a custom element in SSRS. For ...
3
votes
3answers
436 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, ...
0
votes
1answer
44 views

Should every job, SSIS project, SSRS have its own sql login

Apologies for asking an opinion type question, but I'd like to know what is best practice. I have a bunch of sql servers and every job as well as every connection manager for every SSRS report & ...
0
votes
1answer
395 views

Configuration file missing after successful SSRS migration

Getting the backup of all SSRS databases including compressing and encrypting can be straight forward. However, when planning a complete solution for SQL Server Reporting services backup, following ...
3
votes
1answer
1k views

SSRS Report by URL with parameter-value AND retain full top menu

TL;DR: How can I link to an SSRS (2016) report by URL, with a parameter in the query-string, AND retain (show) the FULL MENU bar (the top "SSRS chrome" that has the Favorites, Browse, Settings, ...
0
votes
1answer
98 views

SSRS Report returning old data

I have created and tested a report in Visual Studio and it returns data from a SQL server database. Once uploaded to SSRS, the report returns old data. What would I need to check as it appears the ...

1
2 3 4 5
12