Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssrs]

SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.

SQL Server Reporting Services (SSRS) is a web based reporting system produced by Microsoft. Originally made available as a free download, from SQL Server 2005 onwards it is bundled with SQL Server and is not available separately.

Reporting Services comes with several major components:

  • The report server, which publishes reports through a web interface, manages security on reports and various other functions.

  • Report Designer, included in B.I. Development Studio (bundled with SQL Server) this allows a developer to make reports backed by bespoke queries. It can consume data from relational, OLAP and various other sources. Reports built with Report Designer can be published to a report server.

  • Report Builder, an ad-hoc reporting tool that can act as a front-end to database or OLAP data sources. Report builder provides a drag/drop style interface for building reports, which can be published to a report server and viewed through the server's web interface.

597 questions
81
votes
5 answers

Are SQL Server in-place upgrades as ill advised as they used to be?

I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade. I'm currently upgrading my 2008 R2 DEV and TEST systems to SQL Server 2012 and need to use the same…
DamagedGoods
  • 2,591
  • 6
  • 34
  • 48
25
votes
1 answer

Reporting Service and Application Role

First poster, long time lurker here. What is the best way to activate application role in a report ? I've tried different things and so far the only method that works is to embed the call to the application role like so :- EXEC sp_setapprole…
YS.
  • 351
  • 2
  • 4
18
votes
1 answer

Will running a large query on a secondary database in an availability group affect transaction performance in the primary database?

I need to provide real-time, or almost real-time, data for SSRS and Tableau reporting. I don't want the production OLTP system to be negatively impacted by long running queries. Will running a large query on a secondary database in an availability…
Tarzan
  • 557
  • 1
  • 5
  • 17
14
votes
2 answers

Will SSRS be extinct soon, and PowerBI the new model?

I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft will eventually try to deprecate SSRS? Should our…
user129291
13
votes
1 answer

How can I tell which data sources are being used in SSRS?

We have a bunch of SSRS (2008) reports deployed to our web portal. We have edited some of the reports to use a shared data source different than the one with which it was originally deployed. I am looking for a way to query the ReportServer…
JHFB
  • 2,874
  • 6
  • 39
  • 64
12
votes
4 answers

Get SSRS Datasources from ReportServer

Housekeeping on an old SSRS, this particular server is 2008R2. I have the query below which gets me the name, location, creation and modification overview for all the reports. I would also like to include the 'Connection String' at least, and some…
James Jenkins
  • 6,318
  • 6
  • 49
  • 88
12
votes
4 answers

Is it poor practice to aggregate data from different tables into one?

Background I write a lot of large reports for and generally maintain a large health records DB (write SPs, functions, jobs, etc.). The original schema, and software that uses it, is from a different vendor, so I can't change much about it…
jreed121
  • 273
  • 2
  • 6
11
votes
3 answers

general memory requirements for sql server 2008 r2

I'm not experienced with DBA work, but I'm trying to make a case for requesting additional resources for our sql server and was hoping I could get some smart folks to provide a rough rough estimate of what we should be running. I'm suspecting that…
RMuesi
  • 213
  • 1
  • 2
  • 6
11
votes
1 answer

8000 character limit on OPENQUERY against a linked server

I have a query that I'm trying to run through OPENQUERY on SSRS/SQL Server 2014, but I keep getting an error of: The character string that starts with [...] is too long. Maximum length is 8000. Is there any way to work around this limitation? For…
Salmononius2
  • 441
  • 2
  • 6
  • 15
11
votes
2 answers

alert when any job in a job category fails

Is it possible to set up an alert in SQL Server 2008 that will send an e-mail anytime a job in a specific category fails? I am wondering because I would like to set up an e-mail anytime an SSRS subscription fails - and all of these subscriptions are…
JHFB
  • 2,874
  • 6
  • 39
  • 64
10
votes
3 answers

SSRS Blocking Processes

We have a busy SSRS Reporting server (SQL Server 2008 R2) on which we see frequent blocking between the below processes: [dbo].[CheckSessionLock] [dbo].[WriteLockSession] We are aware that some reports are running unacceptably slow. What I need…
Yasin
  • 193
  • 2
  • 2
  • 9
10
votes
3 answers

How to hide rows in SSRS report?

I'm trying to figure out, how I can hide those rows in my report where Total Allocation and Total Cost IN BOTH COLUMNS TOGETHER are 0 in SSRS 2008. For example: Total Allocation Total Actual Cost 0 0 <----…
Pawel85
  • 451
  • 4
  • 6
  • 10
10
votes
2 answers

How to configure SSRS (SQL Server 2012) to run on a different instance, but same server as SharePoint

I have an instance of SQL Server 2012 running on Windows 2008R2 along side another instance of SQL Server 2012 that is running SharePoint (I think it is SharePoint 2010). When I try to access the http://localhost/Reports_ I am…
wilsjd
  • 281
  • 1
  • 9
10
votes
4 answers

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 it should use. Both AD and MSSQL instance are…
Bartosz X
  • 503
  • 1
  • 5
  • 17
10
votes
1 answer

Is it safe to change the Recovery Model of SSRS database ReportServer to SIMPLE?

I'm changing the recovery model of ReportServer database from FULL to SIMPLE. Is there any reason why i would not want to do this? Besides the obvious answer of losing point-in-time recovery? (i am not doing transaction log backups on this database…
littlefuzz
  • 173
  • 1
  • 7
1
2 3
…
39 40