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

learn more… | top users | synonyms (1)

0
votes
0answers
12 views

about SSRS 2014 subscriptions? [on hold]

How email subscriptions work in ssrs 2014?Is there any difference between ssrs 2008 And 2014?
0
votes
1answer
116 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
2answers
163 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 ...
0
votes
1answer
156 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
0answers
7 views

Place a footer on bottom of last page of report, and have it work with Excel export

I'm helping a client with implementing some electronically-generated shipping forms, and most of them need a footer section on the last page of the report with some summary details, signature section, ...
1
vote
0answers
13 views

SSRS Lookup #Error on some rows

I'm having trouble working out the details with an IIF containing some lookup statements. The setup: Dataset 1: Transactions Fields: itemid, transactionnotes, rdesc Dataset 2: EmployeeInfo Fields: ...
0
votes
0answers
14 views

Setting up SSRS on multiple servers on network

I have a group of virtual machines on the same domain running Windows server 2003 and sql server 2005 standard edition. I already have SSRS set up on one of the virtual machines which is working fine ...
6
votes
2answers
257 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 ...
1
vote
1answer
295 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 ...
0
votes
1answer
189 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 ...
1
vote
1answer
125 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
1answer
21k views

Page setup and print layout in SSRS Report

I'm creating a SSRS report using BID 2008 and have a couple of questions: Why is the page layout on the report different from print set up? For example I have set the page layout of the report in ...
0
votes
0answers
24 views

Date is not sorted in reporting services consecutively and correctly

I am trying to generate a report using the SSRS,but the date is not being sorted as I want when running the query. It is being shown as follow (consecutive months are mixed): 28/05/2014 ...
1
vote
1answer
44 views

Phantom comparison data in SQL Server Reporting Services - How do I remove it? [closed]

I'm trying to write a query that will allow me to include or exclude a filter in my where statement based on whether a parameter passed in is set to true or false. So far my statement is IF ...
0
votes
3answers
220 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 ...
2
votes
1answer
87 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 ...
-4
votes
1answer
37 views

SQL Server and msbi relation and difference [closed]

With SQL Server 2008R2, we have analysis services, reporting services, and data moving and manipulation services with SQL Server Management Studio. So why do we need SSIS, SSRS, and SSAS?
2
votes
0answers
188 views

SQL Reporting Services (SSRS) - Blocked process on ReportServer, SP CheckSessionLock [duplicate]

We frequently see blocking on our SSRS box which houses both front-end Report Manager ReportingService and the SQL database engine with ReportServer & ReportServerTempDB Catalog databases ...
4
votes
2answers
994 views

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 ...
0
votes
0answers
14 views

ReportServerTempDB - SessionLock table Locked [duplicate]

When a number of SSRS reports are run in a short period of time, I see a number of locks occur on the ReportServerTempDB. The table locked is dbo.SessionLock. The locks sit there until I restart the ...
3
votes
1answer
835 views

SSRS - Set Page Break within table

I had to modify a report that was assembled entirely within table (with 1 column and 10 rows). After my modifications, the report now spans multiple pages and I need it to break naturally at one point ...
1
vote
0answers
19 views

Reporting services setup procedure on present SQL 2008 [closed]

How do you install, configure and setup SSRS SQL 2008 on present SQL "Production server" with 50 databases. I am doing this to save in Licenses but I don't know if there is a better way to implement ...
59
votes
5answers
14k views

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 ...
2
votes
0answers
15 views

SSRS dynamic data retrieved from another dataset

I want to get data(dynamic)according to the data in another dataset and put the result in textbox of the different dataset. Right now, the data I get is static and I tried to use many expressions but ...
1
vote
0answers
21 views

Why won't my subscription parameter value stick?

I've set up an "Aggregate level" parameter on a SSRS report, so that I could easily schedule subscriptions for daily, weekly and monthly aggregates. The parameter has a Text datatype, and doesn't ...
1
vote
1answer
30 views

Nulling other Date parameters in SSRS on selection of one

I have set up multiple dates as input parameters and in SQL query, I've set up the WHERE clause like: WHERE datecol1 >= @date1 OR (@date1 IS NULL) So that handles dates as optional parameters. I ...
4
votes
1answer
10k views

How to keep the structure of the Tablix when there is no data to show

We have a SSRS report which shows the result of a dataset in a tablix. If the query in the dataset returns no data, the header of the Tablix gets displayed but not the tablix cells below the header. I ...
11
votes
2answers
1k views

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 ...
0
votes
0answers
22 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
0answers
19 views

Is it possible to have SSRS generate report while a parameter is being typed?

I have only been using SSRS for a few weeks now and from what I have seen, I know that we create a dataset, define parameters (I do it by using a paramaterized stored procedure and linking that to a ...
0
votes
1answer
33 views

How to pass SSRS params into a URL

I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the ...
0
votes
0answers
17 views

SSRS REPORT average

how to calculate average values of two cells vertically in SSRS. I need average of 8.587 and 9.307 in 'Avg TO date' in 'Plant Avg'. I'm very new to SSRS. please help me. I also want to merge two ...
0
votes
0answers
24 views

SSRS Scrolling Issue

My report column headers are not visible when I scoll down my report in SSRS. The screenshot below shows what is happening. The Tablix properties are set to keep the row and column headers visible ...
0
votes
1answer
25 views

Specify windows account for SSRS data source in SSDT project

In the properties of a data source in SSRS, I can specify a Windows domain account to use, like this: This data source was originally deployed from a SSDT project and I need these settings to be ...
1
vote
0answers
135 views

Can't uninstall SQL Server 2008 R2 SP3

I have encountered the error on SQL Server 2008 R2 where Report Builder 3 fails to load with error Microsoft.ReportingServices.ComponentLibrary.Controls.dll, has a different computed hash than ...
0
votes
0answers
48 views

File size increased X3 with new Microsoft reporting services pdf rendering extension

I have upgraded from SQL server SSRS 2008 to 2014 When I create a PDF using the same code my PDF file sizes have now increased 3 times. The only difference is Microsoft reporting services pdf ...
3
votes
1answer
90 views

SSRS report slow on initial query of the day

I am trying to fix an issue where an SSRS report is slow for the initial query of the day. I have tried using the solution described here: Solving issue with first long starting report on SSRS 2008 ...
0
votes
0answers
104 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 ...
2
votes
1answer
70 views

How to Resolve a Case of "The tablix 'xyz' contains an invalid DataSetName in SSRS?

I am getting the following stubborn error in an SSRS 2012 report: Deploying report 'abc'. Warning : The tablix 'xyz' contains an invalid DataSetName (Expected: ‘DataSet1’; Actual: ‘DataSet2’). The ...
0
votes
0answers
34 views

SSRS with database on different server

On server lab01 was installed SQL Server and SSRS. On second server lab02 is installed only SSRS. When I configured Reporting Services Configuration Manager I create new database and given name ...
2
votes
1answer
103 views

Migrating reports from SSRS 2005 to SSRS 2014 and SSAS 2005 cube to SSAS 2014?

As SQL Server 2005 end of life is getting closer I'm facing inevitable job of migrating databases, SSIS packages, SSRS reports and SSAS cubes. Since newest version of SQL Server is SQL Server 2014 we ...
0
votes
1answer
24 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
18 views

Trying to correct query for SSRS report

I have the following query below which produces this report for me: I am trying to bring in cc.valid_to so that I can change the expressions for a conditional formatting to reference against that but ...
4
votes
1answer
134 views

Conditional formatting based on number of days in SSRS against a cell value in reference to another field

I have a SSRS report where I have cell displaying a field called activity_date. I would like this to be colour coded based on a number of days against another dataset field called valid_to where if it ...
1
vote
2answers
2k views

2 SSRS Instances, one in native mode and one in sharepoint integrated mode with PowerPivot and PowerView on same server

Wanted to know if I can have two SSRS instances on the same server, one in native mode and one in SharePoint integrated mode. I have one SSRS instance in native mode on a SQL server default instance ...
1
vote
0answers
34 views

Bulk changing SSRS schedules

I have around 100 SQL Server Reporting Services subscriptions that I need to change the schedule on. The schedules are all standalone, not shared. Is there a way that I can easily bulk change the ...
1
vote
0answers
28 views

Date picker is dynamic in SSDT but not in SSRS

Running SQL Server 2012 SP1 and SSDT from same distribution. (VS2010) When I display a report in SSDT the date selector on a date parameter is dynamic or responsive. When you click on the date ...
2
votes
1answer
101 views

Deploying SSRS reports on an “Air Gapped” report server without SSDT?

Whats the simplest way to deploy multiple reports (.rdl) along with the respective data sources to a machine which cannot be connected to from Visual Studio? I can only place files at a given ...
1
vote
1answer
75 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 ...
0
votes
1answer
40 views

encryption key for SQL Server 2012 Reporting services [closed]

Is it required to have an encryption key for SQL Server 2012 Reporting services?