Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
555
questions
0
votes
0answers
37 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
33 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
53 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
25 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
57 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
16 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
22 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
85 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
44 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
26 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
31 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
21 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
23 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
40 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
0answers
18 views
SSRS: Make tables start from the top of the new page
I am trying to create a report with multiple tables. The report will be exported to Excel though. I want to have 2 tables in one page so I "Add a page break after" to every second tables. ...
0
votes
0answers
33 views
visual studio 2012 ssrs report preview error failed to load assembly could not load file reportingservices
I had used visual studio 2010 data tools earlier. Since i couldn't find it on Microsoft site, had to install visual studio 2012 data tools on my new laptop. When i click preview, i get the error ...
0
votes
1answer
62 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
0answers
11 views
Report Builder - databases missing in connection properties drop down
I'm putting together a new paginated report using Report Builder, but when it comes to adding the datasource, there are a number of databases that aren't showing in the drop down after entering the ...
0
votes
1answer
77 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
73 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 ...
0
votes
0answers
39 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
460 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
18 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 ...
0
votes
0answers
158 views
SSRS 2017 Subscription - Permissions granted to user '' are insufficient for performing this operation
I've seen lots of issues relating to 'permissions....insufficient for performing this operation' which can arise in a variety of places when related to SSRS - deploying reports, running reports etc.......
0
votes
1answer
44 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
0answers
11 views
Is it possible to configure SMTP relay on SSRS 2012 RTM?
I am trying to configure SSRS 2012 RTM to work with user and password to a remote SMTP server.
In 2016 its working just fine but for some reason on 2012 it doesn't- when i add the SMTP configuration ...
0
votes
1answer
154 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
210 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 ...
0
votes
0answers
37 views
SSRS report stuck on loading screen
We use SSRS on SQL Server 2016 and on it have a skype usage report run. This report is completly third party and was installed along with skype.
All other reports seem to work fine but on this one ...
0
votes
1answer
369 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 ...
2
votes
2answers
73 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
40 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
129 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 ...
0
votes
0answers
21 views
Querying the SSRS ReportServer db to find snapshots without a schedule
We have a report that debugs snapshot scheduling issues and I'm looking to find where this value is in the ReportServer database
3
votes
1answer
514 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
28 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 ...
2
votes
1answer
170 views
Trying to use SSRS rsconfig.exe in silent mode to create the ReportServer and ReportServerTemp databases on a local instance
I have installed a brand new SQL 2017 Enterprise instance on a Windows 2019 Datacentre VM.
I have then installed SQL Server Reporting Services via the command line (/quiet, /norestart, etc) and all ...
0
votes
2answers
72 views
What triggers the SSRS to generate a log file or modify a current one?
When running a trace on my new SSRS Reporting Services 2016, after troubleshooting some problems related to migrating from SSRS 2008, I find the following pattern running continuously:
Here is the ...
1
vote
1answer
902 views
how to list the SSRS permissions in each folder in the reporting services server?
I have the following powershell script that downloads all the RDL from a reporting services server.
I am not the author to whom I am very thankful. It has been very useful for downloading the RDLs.
...
0
votes
2answers
42 views
Reporting services 2008 reports connection to azure sql database
Due to the end of support of sql server 2008 R2 we are planning to move the database to azure as a paas service (azure sql database). Right now the application server has reporting services 2008 R2, ...
2
votes
2answers
455 views
Setting up Availability group for report server databases
I am reading msdn article on using SSRS with AG and have few doubts on setting up the same:
Server A - Will host Report Server services with scale out deployment
Server N1 - Node 1 with ReportServer ...
9
votes
3answers
3k views
SSRS error “something went wrong please try again later” in web portal
I have a brand new installation of SQL Server Reporting Services 2019 on top of MSSQL 2019 Enterprise CU1. SSRS has been installed and configured using default settings, apart from the service account ...
4
votes
1answer
483 views
SSRS Query Timeout settings: rsreportserver.config verses RDL Query.Timeout
I'm trying to understand the interaction between the SSRS DatabaseQueryTimeout (set at the server level, defaults to 120 - does this only apply to connections to the ReportServer internal database?)
...
-1
votes
1answer
31 views
Help with joining to date table
There is an existing report that takes two parameters (BeginDate, EndDate) from the user. When a user inputs two date ranges, it produces a result in the LeadTime column of the difference between the ...
0
votes
1answer
33 views
Was SSRS installed in SharePoint Integrated Mode?
I've inherited an old QA database server with SQL Server 2008R2 (yes, yes, I know it's beyond EOL; there's nothing I can do about it!) and SSRS installed.
It's the back end of a SP server on a ...
1
vote
1answer
228 views
SSRS connection string Encryption
i am working on porject to encrypt the connection between ssrs reports and sql server. we have already installed ssl certificate on sql server. can i know how to encrypt the connection string in SSRS ...
1
vote
1answer
1k views
SSRS 2016 subscriptions error - Something went wrong. Please try again later
I have a SSRS 2016 instance which gives me below error whenever I try to view my existing report subscriptions:
An error has occurred. Something went wrong. Please try again later.
Strange thing ...
0
votes
1answer
96 views
Dont' see option to download/upload some SSRS reports
I have a SSRS 2016 instances with 100s of reports on one of my server. I want to migrate these reports from this instance to an existing new instance which already has some reports for different ...
2
votes
1answer
64 views
Trigger SQL Agent job based on text in error log for an AG failover
I have a 2 node AG setup (Not an FCI). I need to configure an alert to trigger a job based on a string found in the error log showing that the node is now the new primary.
The string I want to use is:
...
0
votes
1answer
378 views
SSRS Tries to Upgrade Itself every morning at 2 am
I have a Windows 2019 Server running both SQL Server 2017 Enterprise (14.0.3238.1) and SQL Reporting Services 2017 (14.0.600.1109). In noticed in the RSManagement logs (located here: C:\Program Files\...
