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
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
190 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
203 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 ...
0
votes
1answer
32 views

Permissions granted are insufficient for this operation

I am using Report Builder 3.0 and have been trying to run reports using AdventureWorks 2014 in SQL Server Express 2014. My report Server is http://John-PC/ReportServer_SQLExpress. When I click Run in ...
1
vote
1answer
73 views

How to determine if an SSRS data driven subscription job has completed

I have a report that generates PDF's using a data driven subscription process. When the job is started, it shows a success status shortly afterwards, however I believe that this is really ...
1
vote
0answers
41 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 ...
1
vote
0answers
48 views

Reporting services database was NATIVE, now it's UNKNOWN

After migrating a database from Sql Server 2012 to Sql Server 2014, we found a little problem. It was told me that the reporting server was not used, so I just installed the SQL Server 2014 and ...
0
votes
1answer
39 views

To list the databases and logins

Can anyone tell me the query to list the databases and SSRS reports and different logins in a particular server ?
0
votes
0answers
60 views

Azure SQL Server SSRS Reporting With VM Error

I'm using an Azure VM with SQL Server Standard 2014 installed so I can use it as a Report Server for my separately hosted SQL Server databases. I can make the connection to my database using ....
1
vote
0answers
37 views

What's the deal with transactions in a stored procedure called by an SSRS report?

Consider the following: sp_a contains an sp_executesql call to exec sp_b sp_b begins and commits a transaction, then immediately logs @@TRANCOUNT. When I call sp_a manually from within SSMS, the ...
0
votes
0answers
20 views

Azure SQL hybrid SSRS configuration

I would like to migrate my existing Visual Studio SSRS Reports to the cloud while keeping my database on-premise. Any advice on resources for getting started would be greatly appreciated - tutorials, ...
0
votes
0answers
14 views

Azure SQL SSRS Hybrid Configuration [duplicate]

I would like to migrate my existing Visual Studio SSRS Reports to the cloud while keeping my database on-premise. Any advice on resources for getting started would be greatly appreciated - tutorials, ...
1
vote
1answer
40 views

Adding a new data set in SSRS with nested stored procedures

I have spOne which builds a couple of global temp tables with over 500 lines of code. Normally it would return a single result set but I wanted to leverage the code for building the temp tables ...
6
votes
2answers
30k views

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

SSRS 2008 - How to Total values from an expression

I'm trying to figure out how to total values from a calculated field. In the example below, I have the following expression: =IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100, ...
2
votes
1answer
4k views

How to set the Tablix outer border width

In SSRS 2008 R2, a Tablix has got a "Border Width" property. I assumed that by assigning a value to this property, I can define the outer border's width. But it does nothing. I'd like to have the ...
5
votes
2answers
978 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 ...
0
votes
0answers
91 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
119 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
18 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 ...
3
votes
1answer
23k 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
56 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 28/06/...
1
vote
1answer
50 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 @...
-4
votes
1answer
50 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
189 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
2k 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 ...
1
vote
0answers
22 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 ...
65
votes
5answers
17k 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
49 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
59 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
73 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 ...
5
votes
1answer
12k 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
23 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
97 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
20 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
51 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
42 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
267 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
147 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
219 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 ....
2
votes
1answer
200 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
42 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
262 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
0answers
22 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
274 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 ...
0
votes
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
61 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 ...