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
2
votes
1answer
257 views

SSRS ReportServer_XXX.log is giving incorrect CPU count

I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
0
votes
1answer
384 views

Should I upgrade compatibility level of MS Report Server database

Recently upgraded from SQL Server 2008 to SQL Server 2012. The MS Report Server databases did not automatically upgrade compatibility level. Should I force the upgrade?
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 ...
2
votes
1answer
302 views

Security implications of running SSRS and an OLTP database on the same server

I am in the process of building a new environment for my company's Customer Relationship Management (CRM) system. This system is a commercially available product which uses SQL Server as its back end ...
1
vote
2answers
564 views

SSRS and Informix connection

I have the IBM drivers installed, created a data source that successfully tests from SSRS front end. Create a report from my machine which also has the drivers installed and the ODBC testing ...
1
vote
0answers
17 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 ...
2
votes
0answers
112 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
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: ...
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 ...
2
votes
1answer
1k views

'Refreshing' SSRS subscriptions (parameter values not valid due to lack of data in the tables)

In a place where I work we have lots of subscriptions set for SSRS reports. Some reports have as many as 100 subscriptions set up. Our data warehouse is refreshed every night, with all the data ...
1
vote
1answer
625 views

Data driven subscription query parameters in SSRS

I am looking at customizing my data driven subscription query in SSRS so that depending on the results of the original query it will notify the correct department. For example the query returns: ID ...
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.
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
2k views

Use Group Managed Service Account for SSRS

We have a production environment running SQL Reporting Services 2014. The service is running as a group managed service account domain\SSRSProdSvc$ We are now trying to change our test environment to ...
1
vote
1answer
119 views

SSRS Reports Blank on Zebra Printer

I need assistance getting labels to print from SSRS 2014 to a Zebra GK420D direct thermal label printer. The labels show up when running the report but when I print them to the label printer, all that ...
2
votes
1answer
483 views

What does SSRS technically do when it expires the cache?

Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a ...
0
votes
2answers
168 views

SSRS - select where parameter and fixed value

So there is a lot of stuff about using SSRS parameters to select multiple values but nothing about using both a parameter and a fixed value using the in select statement. So what I'm trying to do is ...
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 ...
1
vote
1answer
63 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 ...
0
votes
1answer
59 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
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
1answer
878 views

SQL Server Replication tools [closed]

We're trying to create an exact copy of our prod database to later use it for reporting. I was told that some of my colleges tried to use the out of the box replication tools that SQL Server ...
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 ...
1
vote
1answer
403 views

SSRS2016 external parameters for mobile report

How can external parameters be passed to a SSRS 2016 mobile report in order to pre-select values / settings for the report? The same scenario is possible for paginated reports as it always was. It's ...
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
203 views

Report Builder Indicator showing incorrect symbol

I have a report on which I am using about a dozen indicators as a check boxes. The data source for the report is a SharePoint list. About half of the check boxes are displaying correctly. The other ...
1
vote
1answer
153 views

Windows Managed account to report subscription file share

Is it possible to used a Windows Managed account to access a file share in a Report subscription? When creating a Windows file share report subscription, on Step 4 - Create a data-driven subscription,...
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
129 views

SSRS Configuration

I'm trying to configure SSRS to use email subscription feature. This SSRS server is hosted on AWS and I have an SMTP relay to use. This SMTP relay requires an userid and password to authenticate. I ...
0
votes
1answer
220 views

How to execute OPENROWSET from SSRS

Trying to create a Dataset in SSRS that executes a stored procedure that imports data from an Excel file. The sproc transforms the imported data and outputs the reformatted data for the SSRS report. (...
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 ...
1
vote
1answer
120 views

Do SQLPWD and TERADATA have any affect to Report server?

Do SQLPWD and TERADATA have any affect to Report server? To which certain extent do they go and affect reporting service?
1
vote
1answer
1k views

Protecting Virtualized SSIS and SSRS servers

I have a stand alone instance of SSIS and SSRS running on 2 seperate VM's in production. And I want to know if the Servers can be protected with some kind of Snapshot method like Veeam to restore them ...
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
949 views

View the role assigned to each user (Report Server)

Is there anyway I could list down the roles assigned to each user on the different folders on ReportServer Database and in that SQL statement I should be able to declare something like @User_Name ...
2
votes
2answers
339 views

Is it possible to host pbix and rdl files on the same report server instance?

Just upgraded an existing instance of SQL Server 2014 to 2016. That instance has an instance of Reporting Services installed. My end goal is to connect Power BI Desktop (March 2018) to my existing ...
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
101 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 ...
3
votes
1answer
360 views

Creating Report Subscriptions on report that are using a Shared data source that uses Windows Integrated Security

We've recently deployed a new SSRS Server 2012, that can use Windows Integrated Security. We configured the servers to properly use Kerberos authentication and we solved the double hop issue. Now, ...