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
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 ...

1
2 3 4 5
11