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

learn more… | top users | synonyms (1)

1
vote
1answer
19 views

SSRS error - A scope is required for all aggregates in the page header or footer which reference fields

I had the following textbox expression in my SSRS report and it was working fine. = First(Fields!FirstName.Value) +" " + First(Fields!LastName.Value) + ", MD" When I moved the textbox to the ...
4
votes
1answer
167 views

SSRS URL Changes while navigating

I am trying to track down the root cause of this issue I keep seeing. We have SSRS running with a custom URL like https://reporting.companyname.com/reports. When I connect to that address I can ...
1
vote
0answers
11 views

SSRS Scale-Out Deployment: cannot decrypt the symmetric key

I have a single 2008 ssrs instance (#1) up and running and need to add a 2nd server also running ssrs 2008 (#2). The error message on the 2nd server is: The report server cannot decrypt the ...
0
votes
1answer
20 views
1
vote
1answer
25 views

Documenting SSRS and SSIS jobs that are the Job Activity Monitor

We are running a SQL Server 2014 database using SSRS as a reporting tool. We have data coming in via SSIS jobs and linked servers. We have developers creating various SSRS jobs and scheduling them. ...
1
vote
0answers
31 views

Report subscription deletion failed due to FK constraint

We have many SSRS report timed subscriptions (SQL Server 2008R2 SP4). One of our report developers tried to delete a report subscription, and got the following error: An error occurred within the ...
0
votes
1answer
182 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 ...
1
vote
1answer
261 views

How to get past the 5000 row limit in a SQL Server Reporting Services tablix report?

I have a report whose data returned exceeds 5000 rows in a tablix in SSRS 2012. When I Google this, I get all kinds of info concerning settings in Sharepoint, but this instance is running in Native ...
3
votes
0answers
23 views

Change the value of a cell based on the hidden value of another cell

On a 2012 SSRS report I have the following: You can see that "Site", 0098110, has a total of 13 "tests" associated with it. This is what I want to show while the group is in the collapsed state. ...
11
votes
1answer
155 views

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 ...
8
votes
2answers
290 views

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 ...
0
votes
1answer
450 views

SSRS CROSS Domain Reports Server Authentication

I have a pretty complicated situation at hand, let me try to explain. I have a SQL Server and a Web Server in a separate domain (lets call it domain A). SQL Server has the databases for Reporting ...
0
votes
1answer
243 views

SSRS Domain Migration

My company is currently going through a data center migration. We are now down to the SQL Servers and this includes SSRS. The bad thing that is going to hit us is the current SSRS server is being ...
0
votes
2answers
278 views

need information on a deleted SSRS report

In SSRS, once a report is deleted, the ItemPath no longer appears in the ExecutionLog because the Catalog no longer has the report information. I can track down the ReportID, but I can't find ...
1
vote
1answer
374 views

SSRS minus first two dates as the header

I have a SSRS report that has one column called startime that is listed in mm:dd:yyyy hh:mm:ss format. For the header of this column I want to minus the first date from the second date to give me an ...
1
vote
0answers
7 views

How to configure email alert when SQL Server Reporting service stops working.

The SQL Server Reporting Service stops sporadically. Does any one know on how to send email alert/Configure a job to notify when the SQL Server Reporting service stops working. Thanks
0
votes
1answer
383 views

Reporting Services service restart fixes slow reports

SQL 2012, the reports are displayed on a WEB page or rendered to PDF I have an ongoing problem with reports suddenly slowing down. The only way to "fix" this problem is to restart the service. This ...
1
vote
0answers
10 views

How to collapse cell borders in ssrs

I have been creating some reports in SSRS 2008 R2. When I need to make borders that show up for all rows, both on the top and bottom of the report, as well as all the rows in between I can tell that ...
1
vote
0answers
9 views

Tracking Changes

I have an SSRS report with hierarchies for the company and their contact info. As these hierarchies change overtime, is there a way to track what has changed since the last run(run on a weekly basis)? ...
1
vote
2answers
45 views

SSRS 2008 Broken in Chrome

Note, this is 2008, not 2008 R2. This isn't an unknown problem, but I can't seem to get it to work. Seems like all of the solutions I've tried relate to 2008 R2 and above versions. Chrome updated and ...
0
votes
0answers
24 views

Grouping and Row limit in SSRS

I want to have row limitation(for example, display only 10 rows in every page) to my table in the report. I could limit the rows with Ceiling method where I could find refer. However, I have to group ...
0
votes
1answer
179 views

SSRS - Data missing when running report from server

I have an extremely strange issue with an SSRS report i'm working on. We use SQL Server 2012 availability groups and as number of groups and the nodes they run on has swelled, confusion on the part of ...
2
votes
1answer
232 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 ...
0
votes
3answers
257 views

Replacing the results of a row

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...
0
votes
1answer
121 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 ...
0
votes
0answers
20 views

Reporting Services Maintenance and Performance Best Practices

I'm simply looking for what most folks do to keep their SSRS servers in top shape. Beyond performing backups of the databases, symmetric key, custom extensions, configuration files, IIS settings, ...
1
vote
0answers
20 views

SSRS: UserName value in Subscriptions table, ExtensionSettings column

SSRS subscription to a Windows File Share. Is there a way to query for all the "credentials used to access the file share" in plain text? It appears that the UserName value in the ExtensionSettings ...
0
votes
0answers
52 views

SQL Server 2008 R2 Reporting Services: “Exception of type System.OutOfMemoryException was thrown”

When I run a report on SSRS reporting services to fetch 600000 row.. I get a error "Exception of type System.OutOfMemoryException was thrown". I read so many blog's for solving this issue but still I ...
4
votes
1answer
198 views

How do I enable both PowerShell Remoting and SPN for SQL Server Reporting?

I'm struggling with remoting servers with SQL Server Reporting Services running. My Reporting Services are running with individual domain-accounts, and I have set up SPNs for them (HTTP/<Machine>...
1
vote
0answers
30 views

Select where table and column name are from another table

I know I need dynamic sql, but haven't gotten this to work: I want to loop through a table and for each row, return the value of the field that is located by two columns for that row. Master ...
1
vote
0answers
5 views

Missing emails from a scheduled report

I have a scheduled report with a query used to determine the recipients. Every time the report runs, there seems to be a few people who are not receiving the emails. I enabled SMTP logging, and indeed ...
4
votes
2answers
127 views

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 ...
0
votes
1answer
44 views

extract values from different stored procedures and create one report

At the company I work, the third party taking care of the database. So there is giant complex stored procedure that produces the result for one parameter only. When management needs a desirable ...
2
votes
2answers
94 views

Completion of SQL Job triggers start of job on a different SQL Server

I want the completion of a SQL Server agent job to trigger the start of a job on another server. More specifically, I want my SSRS server to email a subscription report whenever an FTP/Import job ...
0
votes
1answer
26 views

How to set SSRS parameter Default to uncheck specific options?

In a multi-select Parameter for SSRS (2008), I want the default state of an input parameter to be such that one option is unchecked while all others are checked. Like in the image that follows: Is ...
0
votes
0answers
21 views

Grab value from the group SSRS

How can I grab a value for a particular month in SSRS if it's in a group? I have all 12 months as a group, in a column outside of the group I need to get the value for March that is in the group?
0
votes
0answers
66 views

Reporting Services Configuration Manager - error message “Could not connect to server…server was not found..”

I am attempting to install and configure SQL Reporting Services (SSRS). I have a windows 8.1 Pro OS laptop. Running SQL Server 2012 Express with SQL Server 2012 Management Studio. I downloaded and ...
0
votes
0answers
26 views

Migrate 2008 R2 SSRS DB to 2014?

I am working on upgrading/migrating our SSRS from 2008 R2 on Windows 2008 R2 to SQL 2014 on Windows 2012 R2. I was originally going the route of just recreating side by side. I already have the new ...
0
votes
0answers
39 views

How to have static and dynamic columns in one table with calculation?

How can I have static rows with 12 months along with dynamic rows and have it look like one table? I don't have column Budget, I created separate helper table with budget amount for whole year. So I ...
2
votes
1answer
54 views

Can mirroring be used to upgrade SSRS?

Can you use mirroring to upgrade SSRS? For instance, I've upgraded from SQL 2005 to SQL 2014 with mirroring. SSRS is running on the same box as my database server. I'm going from SQL 2012 (11.0....
1
vote
1answer
64 views

ReportServerTempDB in AlwaysOn Availability group

ReportserverTempdb logfile is 6TB in size and growing and I need help. I am supporting a huge reporting server farm and the client wants reporting services to be in AlawysON Availability group(AAG) ...
4
votes
1answer
829 views

Keep original column names in SSRS report designer 3.0?

I have a query that returns over a hundred columns. The column names contain important underscores, >, < and Uppercase/lowercase characters. However, when creating the reports, SSRS designer (3.0) ...
5
votes
1answer
1k views

Reporting Service 2014 Service Pack 1 Failing to work with error - wrong database version

Tonight we upgraded our SQL Server 2012 (SP2+CU6) cluster with SQL Server 2014 Service Pack 1. On that cluster nodes, we have Native mode Reporting Services scale-out configuration. After in-place ...
2
votes
3answers
70 views

Cannot create SSRS subscription for a report using SSAS as datasource

My questions is : how should I config SSRS subscription a report, which consumes SSAS datasource. I already googled and lookup stackoverflow a lot and still couldn't make it work. Problems: I ...
1
vote
0answers
192 views

Problem connecting to SSRS reporting services

When I try to connect to my reporting services server (SQL Server 2005) from my local machine, SQL Server 2014 I get the error message below Invalid Namespace (System.Management) But when I ...
1
vote
1answer
66 views

Report Builder CTP 2.3 Installation DLL Error

I was attempting to install Report Builder CTP 2.3 and cannot get it to install on any of three tested systems. First system was Windows Server 2012 R2 Datacenter - MS Azure SQL 2016 preview image ...
0
votes
0answers
11 views

Convert spatial points data to line data for use in Line Layer in SSRS Map

I want to create a SSRS Line map report by creating a line between my booking country and delivery country and vary the line width based on the number of orders. I've added my shape file using ESRI ...
1
vote
1answer
2k views

Convert spatial points data to line data for use in Line Layer in SQL Server Reporting Services (SSRS)

I have a query that returns the fields Order, Lat, Long, SpatialData, <OtherStuff>. SpatialData is a point. I want to create a line layer that draws lines between my points based on the order ...
1
vote
1answer
179 views

Loading subscription slow in SSRS

I have a SQL Server 2014 test box with SSRS installed. The site loads ok and reports are quick. When I try to go to Subscribe the page takes over a minute to load. From there if I pick a schedule it ...
2
votes
1answer
190 views

Reporting Services will not connect to SQL Server

I have set up a new SQL Server 2014 default instance. In SQL Server 2014 Configuration manager I see my 32 and 64 bit SQL Native Client 11.0 configurations and all protocols, pipes, tcp/ip,shared ...