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
1
vote
0answers
18 views

SSRS managed shared subscriptions data from from database

While running an ETL process we need to pause the shared managed SSRS subscriptions and then enable them and run them accordingly when our ETL has progressed. In order to do that we take a backup of ...
1
vote
0answers
8 views

SSAS Design 2 Fact tables (1 Weekly, 1 Monthly) [closed]

I am currently busy building a sales cube for a customer. However they would also like to see their current stock count in the same cube. The Sales Fact table is on a daily grain, where as the Stock ...
0
votes
0answers
9 views

PowerBI ReportServer: Deviceinfo Name already exists Parameter name: deviceinfoName

We have a few reports that autorefresh. On occasion users get the following error: Deviceinfo Name already exists Parameter name: deviceinfoName This sounds like the same problem described here: ...
2
votes
0answers
113 views

Sporadic SSRS Report Performance

I have an SSRS instance with a dashboard report that frequently runs 100-200 times per minute throughout the organization. Most of the time, the report runs quickly with consistent times for data ...
0
votes
2answers
24 views

SSRS report does not work with multiple parameters

My data set has the following where clause: WHERE a11.PDPOID LIKE '%' + @POID + '%' My parameter @POID properties are set to single value. The report works, but if I change the parameter properties ...
0
votes
1answer
15 views

SSRS Security Audit

Is there a way to audit access given to reports \ folder in SSRS ? Trying to figure out who granted browser access to a user to a specific folder. Thank you.
1
vote
2answers
20 views

Reporting Services Database on different version

Just wondering if anyone has come across this scenario and can provide some advice. We have a vendor application that only runs on SQL Server Reporting Services 2014. However, all of our other ...
0
votes
1answer
22 views

How to change the reporting services report service mode from Native to integrated?

In SSRS-2016, I am trying to change the Reporting services report service mode from Native to integrated. I added 2 new shared features to existing installation (See in the Pic) I am trying to ...
2
votes
1answer
34 views

How to combine date and time with a string value in column created by Case in SQL Query

I am in the process of creating a query for an SSRS report that will show a column that has DATETIME values. The column can have NULL values. In my query I would like to use a CASE expression. I ...
0
votes
2answers
28 views

Aggregating Multiple COTS Databases into a Data Warehouse or similar for Reporting

I am sure this is a very basic question, so I apologize, but I've read lots of articles and done a lot of google searches and have not found any leads for this particular challenge I am looking to ...
0
votes
1answer
60 views

I cannot get my data source to connect to an SQL Server named instance using SSRS Report Builder

I have a report in SSRS and I want to update the data source to use a named instance instead of the default instance. The server host will remain the same. I thought this would be easy. I simply ...
1
vote
1answer
64 views

SSRS 2016 report is failing with 'EXCELOPENXML' render format error

Few reports are failing with 'ExcelOpenXML' render format error after rs migration from 2014 to 2016. I made following change to the RS config file so I can use old excel format however some of the ...
1
vote
1answer
34 views

How can I configure a connection string in SSRS 2012 using named pipes?

I have SQL Sever 2012 and I want to create a data source that uses named pipes rather than TCP. This is when I have tried: Data Source=np:\\.\pipe\MSSQL$MSSQLSERVER02\sql\query;Initial Catalog=...
0
votes
0answers
10 views

Different security levels for one SSRS report

I am trying to grant limited access for one report per user. For example, the report consist of multiple cities and each city has profit info within them but the users should only be able to see the ...
1
vote
0answers
20 views

SSRS: Oracle Data Sources Breaking After Server Updates\Restart

Our SSRS instance has several Shared Data Sources that hit Oracle databases. Whenever we do patching or the server restarts, these Data Sources seem to break. Any reports hitting them come up with the ...
1
vote
1answer
52 views

SSRS 2017 - Client found response content type of '', but expected 'text/xml'

I've got SQL Server 2017 Developer installed on my workstation, and just installed SSRS 2017. I am able to navigate in the SSRS portal, and upload files of dummy data, and create KPIs. However, when ...
0
votes
0answers
14 views

ReportServer.Config file <SMTPConnectionTimeout> property is blank.. what is the default value?

I have looked at the MS Docs for this: https://docs.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-2017 Which states (emphasis mine)...
0
votes
0answers
15 views

best option for moving from SSRS to Power BI?

One of my customers have an On Premise SQL Server Express edition, using a few SSRS reports for about 20 users. In order to maintain their system, I need one of their PCs to login to their intranet. ...
1
vote
1answer
14 views

Unable to connect to the Reporting Services instance through SSMS with windows authentication

I am trying to connect to Reporting Services instance SSRS with SSMS so that I can update some of the parameters on display of remote errors and retention of execution log statistics. I receive the ...
0
votes
1answer
24 views

Fail-over or switching the Reporting server database

I have two databases in server, dbs-01.One is a transactional database and a reporting server database.Reporting is minimum,that is why we have it together in the same instance. I have transactional ...
0
votes
0answers
33 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
19 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
23 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
21 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
102 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
30 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
31 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
32 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
25 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
10 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
30 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
19 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
51 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
21 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
22 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
407 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
21 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
23 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
34 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
79 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
106 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
159 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
53 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
41 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
84 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
46 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
13 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
30 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
105 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
35 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 ...