Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
521
questions
1
vote
0answers
16 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
8 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
111 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
23 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
55 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
60 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
19 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
50 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
14 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
97 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
30 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
49 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
392 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
78 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
104 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
156 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
40 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
82 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
29 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
102 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
34 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 ...
