Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ssrs]

SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.

0
votes
0answers
29 views

Multiple condition in if

I am making a new Report in SSRS. I have an If condition based on a SSRS STRING Parameter. This Parameter have 3 values; EX : john, Albert and sara. I have do something like this in sql and it works ...
2
votes
1answer
11 views

How many nodes can you install SSRS on when using basic availability groups?

I have migrated a SQL Enterprise standalone SSRS installation to a new SQL Standard 2 node Basic AG recently. I got the expected "scale-out-deployment is not supported error", and I resolved that by ...
1
vote
1answer
21 views

How assigning a value to Variable is working in SSRS

Recently started learning Reporting Services using Microsoft SQL Server 2016 Reporting Services, Fifth Edition, Brian Larson. I am creating this one report which uses UNION to create a dataset, ...
0
votes
1answer
15 views

reportserver will not join basic availabiltiy group

I am running into a strange situation that I have not been able to resolve.  I have a 2 node Basic AG running sql server 2016 standard.  I am trying to add the reportserver DB to an AG, but it keeps ...
0
votes
0answers
24 views

SSRS 2016 issue - Web Portal URL is showing “Could not load folder contents ”

I need help for one if report server issue, We have migrated the SQL server from 2014 to 2016 using in-place upgrade. After upgradation we are having issue with web portal URL and it is showing "Could ...
1
vote
1answer
22 views

SSRS on 2008 R2 and its Database on 2016

Can we have SQL Server Reporting Service on SQL Server 2008 R2 and its Database(ReportServer and ReportServerTempDB) on SQL Server 2016? PS: Both are enterprise edition.
1
vote
1answer
28 views

Is there any special configuration for SQL Server implementing Routing List in a heterogeneous enviroment (Client and Server in different domains)?

I had implemented successfully SQL Server Routing List Feature many times... but I have a very special scenario where our Reporting Services Node is located in a different Domain than SQL Server Nodes....
0
votes
0answers
10 views

Disabling SSRS Scale out feature during migration to non-enterprise edition

Server A is SQL Server 2008 R2 Enterprise which has SSRS installed. I have migrated across the reporting database, reporting tempdb, etc. On Server B is SQL Server 2017 standard edition with SSRS. I ...
0
votes
0answers
21 views

How to export the SSRS report in excel

I have 7 pages in my SSRS report and also I'm used page break option. Is there any way available to export all the pages in single excel sheet. Please provide me solutions
0
votes
0answers
7 views

how to set the page break in SSRS report

I achieved the page break for every 8 rows but I have 33 rows in my SSRS report, if 33 rows is divisible by 8 i get 5 pages and I could see there is only one row in 5th page I don't to display in 5th ...
1
vote
0answers
25 views

Proc For SSRS Report shows a high number of executions ExecutionLog shows low Execution count for Report

So, I am using SolarWinds DPA tool to monitor DB activity and obv do things based on that information. I found a stored procedure that is being used for a SSRS report that has a high number of ...
0
votes
0answers
7 views

SSRS 2016 / VS 2015 Editing text in tablix's textbox very slow in designer

Same issue as described here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6bf89cd-75de-49f9-8a3a-743419ecd631/ssrs-2016-editing-text-in-a-textbox-very-slow-in-the-designer?forum=...
0
votes
1answer
26 views

Missing Encryption Key when migrating Reporting Services from SQL Server 2008 to SQL Server 2016

Owing to a ransomware attack on our production server Reporting Services went down. This server was installed few years ago and its been in production for long. We have quite a few reports on this ...
1
vote
0answers
17 views

After SSRS to PowerBI Reporting Server migration, parameters are rendering goofy when trying to enter data

We just successfully migrated a SSRS 2016 instance to PBIRS. Users are reporting weird behavior when trying to enter data in a multi value parameter. When they click on a parameter to enter in data, ...
0
votes
0answers
20 views

Update password across all SSRS reports within a folder in Reporting services 2016

I am going through a manual intervention of manually updating the password in data source section for all the reports in SSRS2016. This is very tedious as i need to update this across 40+reports ...
5
votes
1answer
135 views

Can we download SSRS 2017 to use with SQL Server 2016?

We are using our organization's SQL Server 2014 SP3 servers. (They also have 2016 SQL Servers, but we elected to skip 2016 and just move to the next SQL servers when they get installed.) We have a ...
0
votes
0answers
18 views

What are SSIS ,SSRS and DB engine SQL server 2008R2 to 2012 IN PLACE UPGRADE steps and cautions? [duplicate]

I am trying to find, SSIS ,SSRS and DB engine SQL server 2008R2 to 2012R2 IN PLACE UPGRADE steps and cautions ? Thanks, DL
0
votes
0answers
16 views

SQL Server login accounts while configuring SQL Server Reporting Services

I configured reporting server in a new app server for my .NET application and, since I am new, I looked at the old app server reporting service config and did the work. So after installation, I ...
0
votes
0answers
31 views

SSRS update record on SQL when run [duplicate]

I am using SSRS on SSAS to generate a report for invoices, all I want to do is when running the report it takes the current date and inserts it in the record in the SQL table based on the selection ...
0
votes
0answers
40 views

SSRS Report - 'Go to URL' not working. Link does nothing

I have a report that I moved from one location to another. The report has several 'Go to URL' links and the location of the files has changed from the original report. The files I am trying to link ...
1
vote
1answer
45 views

What is Report ID used for in SSRS reports?

While looking the XML file of my solution I saw this Does this ID have any practical use or is only for internal use?
2
votes
0answers
68 views

Enabling Kerberos for Microsoft SQL Server Reporting Services

I am trying to enable Kerberos for MS SQL Server Reporting Services. I am fairly familiar with Windows security and how it works. However, I am new to Scale Out Deployment and Clustering of Windows ...
0
votes
1answer
39 views

Are there any extension/add-on tools to improve report-writing in SSRS? [closed]

My company is implementing some software which uses SSRS as the engine for report presentation both in and out of the application, so we'll be customizing a lot of SSRS reports soon. Microsoft has ...
0
votes
0answers
33 views

Any way to get a key stored in the Azure Key Vault when retrieving Always Encrypted data through SSRS?

If you are using Always Encrypted and the key is stored in the Azure key vault, is there any way to use on-prem SSRS to view the encrypted data? Obviously with the client application this can be coded....
1
vote
0answers
41 views

SSRS Azure SQL Database Active Directory - Universal with MFA

Does anyone know when support for Active Directory - Universal with MFA will be included in Reporting Services? It's available in SSMS. Visual Studio 2017 Data Source Properties Reporting Server ...
0
votes
3answers
45 views

Comparing Tool for Reporting Services Objects [closed]

I have three Reporting Services Instances (Server), all in version of SQL-Server 2017. All instances have the same tree structure with hundreds of objects (datasources, datasets and reports) Now I'm ...
2
votes
0answers
11 views

SSRS Web Reference Service Not Found

I'm attempting to add a Web Reference to my Visual Studio Web API to link my existing SSRS server to said API. I'm on the Add Web Reference page and I enter the proper URL and the webpage appears in ...
0
votes
0answers
17 views

SSRS - Report orientation based on parameter

My "Report" is basically 2 images stacked on top of each other. One is hidden, other one is visible depending on the source. I need an option to show some of those as portraits and some as landscapes,...
0
votes
1answer
36 views

User unable to edit a subscription after migration of SSRS from 2008 R2 to 2017

I performed a migration of our SSRS 2008 R2 instance to a brand new SSRS 2017 instance. This was accomplished via Microsoft's documented instructions "Migrate a Reporting Service Installation (Native ...
0
votes
0answers
17 views

Visual Studio or Report Manager for deploying SSRS Reports created using Visual Studio - Pros and Cons

Not sure if this is the best site for this question because I am looking for opinions rather than a technical answer. Sorry, in advance if this posting is not appropriate. Just let me know and I will ...
0
votes
0answers
10 views

In SSRS 2008, how are parameters passed down to the DatSet Query… or can they?

In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? I have a simple question. I think this is pretty straight-forward. If necessary, I can include screen shots of what I ...
-1
votes
1answer
26 views

order britsh date format SQL / SSRS

I have the following query in which I am trying to order dates in British format using SQL in a SSRS package for a parameter SELECT DISTINCT convert(varchar, date, 103) AS Date ,convert(varchar, ...
0
votes
0answers
30 views

SSRS 2016 (under Power BI RS) Shared data source change won't save for paginated reports!

I am running the Jan 2019 build of Power BI Report Server. For paginated (SSRS) reports, I am UNABLE to change a report to use a different shared data source on the portal. I click "Manage" on the ...
1
vote
1answer
86 views

Where/When is the use of RBAR buffering related to ASYNC_NETWORK_IO waits negotiated between the Client/SQL Server [closed]

Where/When is the use of RBAR buffering related to ASYNC_NETWORK_IO waits negotiated between the Client/SQL Server, or Is it always utilized as in that is just how SQL Server spools data to the client?...
0
votes
1answer
18 views

Report-builder: How can I show the labels in a List when the dataset is empty?

An equivalent question was answered for a tablix, but I would like to do this for a list: "how to keep the structure of a tablix where there is no data". I am showing about half a dozen fields in the ...
0
votes
1answer
49 views

Using SQL Server Reporting Services for monitoring database performance

I'd like to know whether it is a good idea to use SSRS for db monitoring or not? I want to check different parameters of a db such as Deadlock, page splits, and page reads/sec to improve db ...
1
vote
0answers
37 views

SSRS default URL not being referenced from Windows application

I have installed and configured SSRS and when I check the URL via HTTP it works fine (I haven't configured SSL). When I try to run a report from the Windows application, I get the following error ...
0
votes
0answers
23 views

SSRS version installation

I need to install two for two SSRS server system The questions are: Do I have to set up the servers according to the SQL version that the system works with? Can I consolidate systems? as is?, there ...
0
votes
0answers
36 views

Reporting server configured in a separate Web server

I am new into configuring Reporting server and I did install and configured reporting server in a separate app server (lets say on app-01). I have my database server running on a separate server, sql-...
0
votes
1answer
94 views

SSRS Configuration

I'm trying to configure SSRS to use email subscription feature. This SSRS server is hosted on AWS and I have an SMTP relay to use. This SMTP relay requires an userid and password to authenticate. I ...
1
vote
1answer
67 views

Dynamically changing tables in datasource in SSRS

I have an SSRS report that I have set up to query two tables, let's call them ABC_Audit and ABC_AuditDetail. I have now added XYZ_Audit and XYZ_AuditDetail to the same database, and want to be able to ...
1
vote
1answer
105 views

Error while trying to create a database for SSRS

I have installed SQL Server Reporting Services 2017, and my database engine is developer edition 2017. Now, while trying to configure SSRS from its Configuration Manager I get this error I have found ...
0
votes
0answers
11 views

Decrypt KPI data from ReportServer database in SSRS/PBIRS

Does anybody know if there is a way to decrypt via SQL the KPI data that's stored in the Catalog table in SSRS/PBIRS? The KPI functionality is useless to me if there's no way for me to query it ...
1
vote
1answer
28 views

Validity period of an open ssrs report

We have SSRS 2008 r2 rdls. I open an SSRS report and keep it open in my browser for more than 30 mins. If I now click any drill downs either through an action or go to report. I don't want the report ...
1
vote
0answers
110 views

How to improve performance of SSRS report using Cubes as data source?

I am trying to build an SSRS report with SSAS as the data source. It has 4 cascading parameters. I used the SSRS Query designer to generate MDX because I am not very familiar with Cubes/MDX. It works ...
1
vote
1answer
509 views

Migrate SSRS Reports to Power BI Report Server

I have to servers: one with the SSRS Report Server and a second server with the Power BI Report Server. The issue is I'm trying to migrate the SSRS Reports to the Power BI Report Server instance on a ...
0
votes
0answers
178 views

SQL Server 2008 R2 SSRS Failure sending mail: At least one of the From or Sender fields is required, and neither was found

I am trying to set up a subscription for a SSRS report in SQL Server 2008 R2 and I am getting the following message: Failure sending mail: At least one of the From or Sender fields is required, and ...
0
votes
0answers
38 views

Input field / form embedded in SSRS report

I understand that this is not what SSRS is for, but I don't have the option of picking a tool. Ideally, nothing other than SSRS would be used. We would like to implement commenting on our test ...
1
vote
1answer
36 views

Same SSRS report, two different subscription names

I would like to know how to change same SSRS reports from one subscription name to two different “from” names?
0
votes
1answer
31 views

Redirecting Report Server connections using host file

I am connected remotely to a server called New_Server and trying to connect to the Report Server which is installed on it by referring to another server: I've changed the host file on NEW_SERVER to ...