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
-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 ...
user avatar
  • 1
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 ...
user avatar
  • 407
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 ...
user avatar
  • 309
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 121
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 ...
user avatar
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.
user avatar
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 ...
user avatar
  • 7,100
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 ...
user avatar
  • 309
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 ...
user avatar
  • 421
-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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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/...
user avatar
  • 19
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 (...
user avatar
  • 1
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 ...
user avatar
  • 99
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 ...
user avatar
  • 141
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.
user avatar
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 ...
user avatar
  • 637
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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 =============================...
user avatar
  • 101
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 ...
user avatar
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 ...
user avatar
  • 1,007
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 ...
user avatar
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 ...
user avatar
  • 141
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]....
user avatar
  • 101
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!...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 133
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) ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 656
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 ...
user avatar
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, ...
user avatar
  • 405
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 ...
user avatar
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 ...
user avatar

1
2 3 4 5
12