Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
532
questions
3
votes
1answer
32 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
26 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
0answers
7 views
SSRS schedules/snapshots are randomly not running as scheduled. Looking to write a query to show me jobs that didn't fire off
We are having random issues where SSRS reports are not firing off their scheduled subscriptions and snapshots, or they're randomly firing off when they weren't scheduled.
We've confirmed things are ...
0
votes
1answer
19 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
29 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
119 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
26 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
22 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
80 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\...
0
votes
0answers
15 views
SSRS Render params into a URL
We have a private SSRS database and have created a public atom url to import the data into Google Sheet. It works, but returns each row as a string. It doesn't return in table format.No columns.
URL ...
0
votes
0answers
27 views
Add a page for Terms and Conditions after Footer SSRS
I need to add some terms and conditions to print after my report on a separate page. So what I’ve done is add a rectangle, after the tablix that contains the detail of the report. Set that to add a ...
1
vote
0answers
24 views
SQL Server Report how to create multiple groups with hidden details
I have created a report that has multiple rows returned from one query.
I have a chart that is created for all the row and I have it grouped on the server location. the group properties of the ...
0
votes
0answers
34 views
Query Editor Connection Error With Unattended Service Account
ERROR:
When editing a report in report builder, opening the query editor gives the following error
You have specified integrated security or
credentials in the connection string for the
data ...
0
votes
1answer
27 views
fn_LShortNameToLCID in SQL Database
My question sound stupid but i didn't understand and searching on google didn't helped either.
I have a SQL query which i use in SCCM Reporting.
I just want to say that my hands are bit tight in SQL ...
1
vote
1answer
30 views
SQL Server Setup: Report Server and RAM Considerations
DISCLAIMER
I am a software developer by trade, but sometimes have to put on my 'dba' hat in the absence of a true dba.
SETUP
I am working on a project where:
SQL Version is SQL Server 2008 R2 (...
1
vote
0answers
70 views
Ambiguous Error Message when running report
I have a database that is used to track container contents as they are shipped in and out of a facility. I am attempting to create a report off of the table containing all of the cylinders. At ...
0
votes
0answers
336 views
SSRS 2016 : HTTP Error 503. The service is unavailable
We have SSRS 2016 on Windows Server 2016.
Reporting Server configured with virtual directories
http://ServerName:80/Reports
http://ServerName:80/ReportServer
While I'm trying to connect to reports ...
0
votes
0answers
16 views
SSRS Custom Code with wildcard?
Is it possible to create a wildcard in custom code to change font color, size or bold?
example
Function BoldText(Text As String) As String
return Text.Replace("Cx", "<font color=Purple size=3&...
1
vote
0answers
25 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
9 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
38 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
196 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
242 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
19 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
21 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
32 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
41 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
1answer
38 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
284 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
260 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
80 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
58 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
21 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 ...
2
votes
1answer
165 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
19 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
16 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
23 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
26 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
39 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
26 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
28 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
32 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
199 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
33 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
33 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
96 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
27 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
31 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
44 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=...
