Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
542
questions
0
votes
0answers
6 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
0answers
30 views
How to configure a single report server with 2 different SQL servers? [closed]
I have the SQL report server configured in a web server(server1).
It used to be pointing to a single SQL server called sqlserver1.
Now I have set-up a new server called sqlserver2. I want to set-...
0
votes
1answer
8 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
44 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
21 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
21 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
1answer
22 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
39 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
16 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
11 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
1
vote
1answer
35 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
11 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 ...
0
votes
0answers
28 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
25 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
180 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
0answers
9 views
is it possible to create a Master report with 4 sub reports and the master report and subreports have differents parameters?
I have 4 reports that I run with different parameters. Each report creates a a table.
i want to create a master report that contain the 4 reports
The problem is that i dont know how to have ...
0
votes
0answers
52 views
SSRS ReportServer blocking from a CREATE PROCEDURE
We have a PowerBI Report Server that will just continue to load on the homepage (http://reportserver/reports) and just times out after certain minutes. When we investigated the ReportServer database, ...
0
votes
2answers
35 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, ...
1
vote
2answers
144 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 ...
6
votes
1answer
377 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 ...
3
votes
1answer
108 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
27 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
8 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
24 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
68 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
557 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
32 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
37 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
179 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
17 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
66 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
81 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
50 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
36 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
121 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
1k 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
17 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
42 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
55 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
309 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
591 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
20 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
26 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
41 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
45 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
43 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
440 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
590 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 ...
