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
2answers
19 views

SSRS Query Timeout vs DatabaseQuery Timeout

In SSRS there are appear to be two separate query timeout options. The Query Timeout option can be found in the Dataset Properties dialog window on the Query tab. The DatabaseQuery Timeout option is ...
0
votes
1answer
10 views

Insert row wise different images in SSRS [on hold]

I am working on SSRS in witch i have data set with [First, Last, Email and Image] image contains name of image and when ever i use this image i have to put www.something.com/images/ at start of this ...
1
vote
0answers
12 views

SSRS 2016 Mobile Report Color Settings

In SSRS 2016 Mobile reports are a new option for Native mode report server. I have created several now and there appear to be consistencies between colors on different charts and graphs if the same ...
1
vote
1answer
21 views

Pass a parameter from SSRS to MySQL [on hold]

Here is the query for the dataset: SELECT DISTINCT CompanyId, Company FROM User_Hierarchy_Mapping WHERE UserId = @FieldManager FieldManager is the parameter name. It's not ...
0
votes
0answers
6 views

Conclusions from report runtimes

I have a report in SSRS whose runtime users are complaining about. When I run some statistics on the data in ExecutionLogStorage for this report, I see the following: FirstDate LastDate NumRuns ...
0
votes
0answers
17 views

repeat headers not working in Microsoft Visual Studio 10.0 report builder

I added a tablix to my report grouped by location, set the page break between each group, set repeat column header to true, and selected the static button of the header and set repeat on new page to ...
0
votes
0answers
15 views

Regenerate a data model in report builder

Is there any way to automatically regenerate a data model in report builder? I am using SQL server 2012 and Visual studio 2013. Please help.
0
votes
2answers
32 views

Display list of SSRS reports in a dropdown list, and allow users to select which report to display

Our company has about 10 different SSRS reports. We would like to allow users to navigate from one report to another simply by selecting the report from a dropdown list. Is this possible?
1
vote
1answer
47 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 ...
1
vote
0answers
15 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 ...
1
vote
1answer
32 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. ...
2
votes
0answers
34 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 ...
3
votes
0answers
27 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. ...
0
votes
1answer
25 views

How to display name on a column chart itself in SSRS, not on a legends

How can I display legends name on a column chart itself in SSRS?
1
vote
0answers
13 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
11
votes
1answer
165 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 ...
1
vote
0answers
12 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)? ...
0
votes
0answers
32 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 ...
1
vote
0answers
11 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 ...
0
votes
0answers
28 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
31 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 ...
1
vote
2answers
55 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
72 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 ...
1
vote
0answers
34 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
179 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
48 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
108 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
30 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
22 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
29 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 ...
2
votes
1answer
55 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....
0
votes
0answers
42 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 ...
1
vote
1answer
86 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) ...
0
votes
0answers
95 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 ...
2
votes
3answers
94 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 ...
0
votes
0answers
12 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
75 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 ...
0
votes
1answer
40 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
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, ...
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, ...
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 ...
4
votes
1answer
271 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>...
0
votes
0answers
94 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
124 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 ...
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
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 ...