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

learn more… | top users | synonyms

1
vote
0answers
56 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
1answer
20 views

Windows Managed account to report subscription file share

Is it possible to used a Windows Managed account to access a file share in a Report subscription? When creating a Windows file share report subscription, on Step 4 - Create a data-driven ...
0
votes
3answers
68 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
0answers
18 views

SSRS issue with subreports

I have inherited a project using SSRS. One report uses an rdlc file that has subreports in. I need to change one of the subreports as there is a date issue with an expression. when I change the sub ...
0
votes
1answer
23 views

Reporting Services DBs not appearing in Management Studio, but can be queried?

I've set up a server with native reporting services, connected to a database server which hosts its two databases. I'm trying to run a backup of the two databases so I can add them to my availability ...
0
votes
1answer
90 views

Formatting the output of SQL Server query

I am new to SQL Server and SSRS...and am trying to get a matrix report formatted correctly. My query is: select e.name, ea.element, case when ea.element = 'projected_status' then 'Projected ...
0
votes
2answers
17 views

SSRS Migration To a separate Network

We are building a new SSRS 2008R2 environment on a separate network. How can I migrate the reports from our current network to the new network? Can I backup the reports from the existing SSRS server ...
0
votes
1answer
53 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
0answers
41 views

How does rsconfig know which config file to update?

We are in the process of migrating some work from Microsoft SQL Server 2000 to SQL Server 2012. As part of that process, we've been using rsconfig.exe to reconfigure some reporting services instances ...
0
votes
0answers
33 views

SSRS 2008R2 Range Chart Three Range Values (Bars) How to draw a border around them?

I am creating a Range Chart with three date range values 1. Start/End Date 2. Start/End Date 3. Start/End Date grouped by category. My boss wants a border like a rectangle around all three bars ...
0
votes
1answer
39 views

Restrict users from modifying datasources in SSRS

We had a situation lately when a particular user of the SSRS reports modified the datasources defined on the reporting server. These users have access rights to create ad-hoc reports using ...
1
vote
1answer
134 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
58 views

Retrieve SPID For SSRS Request

Is it possible to determine what SPID was created to execute a SSRS report? I am trying to prevent users from running the same report multiple times. So what I was thinking of doing was retrieve the ...
0
votes
1answer
28 views

Deploy SSRS 2012 report to a distant Sharepoint 2010 server

My installation : - SQL server 2008 r2 + Sharepoint server (main farm) = VM1 - SQL server 2012 + SSRS 2012 (not native mode) = VM2 I would like, if possible , make my SSRS configuration manager ...
0
votes
0answers
25 views

Reporting Services Scripter ScheduleID Error

I'm currently in a SQL Server 2005 environment that's being upgraded to 2012. I need a tool to script out all of my SSRS subscriptions, and I chose to use RSScripter. I'm having an issue whenever I ...
1
vote
0answers
117 views

SQL Server Reporting Services (MSSQLSERVER) Process using high memory

We have the Reporting Services installed on our database but we are not actually using it. Generally, the running process takes up a few MB but all of a sudden it has jumped to 4GB. We have restarted ...
0
votes
2answers
72 views

SSRS Report Server Database Locations

I've recently inherited management of a large number of SSRS environments. I'm attempting to generate a list of all the database server/instance/names for each of the SSRS databases (not the data ...
2
votes
0answers
72 views

User can create in SSRS, but can't manage objects

We have a user who can create, but is unable to manage objects in SSRS, even though he has content manager permissions and another user who has same permissions who is able to. It is SSRS 2008 R2, ...
0
votes
1answer
54 views

Using Switch in SSRS

In the below expression I am wanting to evaluate several things. I want to turn the value red if the material % is greater than 89.9 %. If it is not then look at the following. is the invoice amount ...
1
vote
1answer
539 views

Impact on SSRS of migration of SQL Server from 2008 to 2012

As part of my project, we are upgrading SQL Server 2008 R2 to SQL Server 2012. We have a separate SSRS 2008 instance running on a separate machine which interact with these existing 2008 database ...
1
vote
1answer
94 views

How can I change the data source of a linked report?

I'm in a situation where multiple "customers" will be running the same report, but against a different database (with the exact same structure). What I've done so far is created a generic "Deploy" ...
0
votes
1answer
90 views

Why can't I access IIS Manager on my server with Reporting Services installed?

I have a Windows Server 2008 Server running SQL Server 2012 (including SSRS). I've noticed that the site is intermittently slow on first run, and found this blog post about the cause and how to fix ...
0
votes
1answer
50 views

Which is faster in process time?

I have a script that uses aggregate functions many times, and that might cause the slowdown of my script. And I thought to simplify my script and do all the summation/addition/concatenation on the ...
0
votes
1answer
377 views

How to set the Tablix Outer border width weight?

In SSRS 2008 R2, a Tablix has got a property as 'Border Width Weight'. I assumed by assigning a vale to this property (e.g.3 pt) , we can define the outer border's width weight. But it does nothing. ...
0
votes
1answer
73 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
1answer
420 views

Find the median of a calculated field in SSRS 2012

I have a start date and an end date, and am calculating the weekdays in between with the following: I created a calcuated field called CountWeekDays, and it equals: ...
1
vote
0answers
16 views

How to keep the structure of the Tablix and Field names when there is no data to show [duplicate]

When the data set returns no data, the tablix column headers display, but I also need the detail rows to display with a blank or zero for all fields. Adding an additional row to the tablix is not an ...
1
vote
1answer
190 views

How to include categories for which there are no values in an ssrs chart

I've got a query that gets some data points for the last 6 months (prior to current), akin to this: SELECT [DataPoint], [When] FROM Table WHERE [When] >= DATEADD(MONTH, -7, ...
0
votes
2answers
2k views

SSRS Subscription Error: “Failure sending mail: Report processing has been canceled by the user. Mail will not be resent.”

On the report Subscriptions page, under "Status" for Last Run, it has the following error: Failure sending mail: Report processing has been canceled by the user. Mail will not be resent. It's a ...
1
vote
1answer
1k views

Cannot Start SQL Server Reporting Service [closed]

That's the first time I use SSRS so my apologies if I'm asking something stupid. I have a SQL Server 2008 R2 already installed with SSRS. When I try to start the SQL Server Reporting Service I ...
2
votes
0answers
330 views

SSRS slow opening a Datasource

While optimizing a report, I discovered that the time reported by TimeDataRetrieval in ExecutionLog2 was a couple of seconds longer than the query times shown in SQL Server Profiler for that report ...
1
vote
2answers
725 views

Expose temp tables to SSRS in stored procedure

Problem: Compare data of a given date range to the same data of up to 3 previous years, and display the tabular data and a graph in an SSRS report. However currently, my stored procedure that I have ...
0
votes
0answers
46 views

SSRS Merge 2 Report Server Instances

I have 2 separate SSRS Report Server Instances on 2 different servers. Each SSRS server's database points to the same remote SQL Server instance. Is it possible to merge both Report Server instances ...
1
vote
0answers
179 views

SSRS Remote Database Connection Issue

I have installed SSRS 2008 R2 on Windows 2012 server. It is up and running. In the Configuration Manager, I have set it to point to remote Database on same network. Then on my own PC (also on ...
0
votes
0answers
70 views

SSRS different print and screen layout

Is it possible to display all rows of the report on one page when displayed on the screen, and one row per page when printed out?
0
votes
1answer
123 views

Active directory automatic login to SSRS

I have a server running SSRS 2012 at address server1.olddomain.com. This is working fine. My users will be accessing this server from another address (the server is not physically moving). The new ...
0
votes
0answers
523 views

How to determine if SQL Server Reporting Services database is being used?

I have a SQL 2005 server that needs to be decommissioned. For regular databases, I have a couple scripts that look at sys.dm_db_index_usage_stats to determine last access. My normal process is to make ...
3
votes
2answers
5k 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 ...
0
votes
2answers
2k 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
48 views

Order results from query to have a certain result at the top

I'm not sure there is even a way to do this, but thought I would ask anyway. I have the following example output from a query: Name Country Number -------------------------- Harry Germany ...
0
votes
0answers
358 views

SSRS 2008. subreport page breaking issue migrating SSRS 2005 reports over to 2008

I'm moving over several hundred reports that were created in SSRS 2005 over to an SSRS 2008 server, and most run fine when copying the .rpt files over, but the reports that have sub-reports don't page ...
0
votes
0answers
280 views

SSRS partial printing issue

We have SSRS 2005 that publishes reports. The reports are often as big as 1000-3000 pages. So the problem is that when the users try to print the report, it prints some of the pages and stops. And ...
1
vote
0answers
156 views

SSRS switch statement

I have a report with a variable number of columns. I can hide columns with the ismissing function based on an expression like Iif(Fields!Site.ismissing, true, false). However, the hidden columns still ...
2
votes
1answer
3k 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 ...
2
votes
2answers
3k views

Possible to run multiple Reporting Services (SSRS) instances on different machines with databases on same machine?

With SQL Server 2012, can SSRS instances be setup on two different machines, with both instances using the same machine for their SQL Server databases? Machine 1 SQL Server 2012 Database Server ...
8
votes
3answers
4k views

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 ...
1
vote
2answers
2k views

Page Break is splitting in the middle of a single row in SSRS

I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on ...
1
vote
0answers
188 views

How to change x-axis labels in a report

I am creating a trend report, in which the x-axis labels are first laywr as year (2014), second quarter (1,2), third period (month) (3,1), fourth week (3,4,5,1,2). I need to change these labels as ...
3
votes
1answer
109 views

SSRS Reports on WUXGA Displays

We use WUXGA displays (1920 x 1200), and have lots of SSRS reports. Since these reports need to be printed once in a while the layout is adjusted to A4. However when the users look at the reports on ...
1
vote
1answer
280 views

how to rebuild / reinstall ssrs (reportserver, reportservertempdb) databases?

Our server crashed. We got it back up and running however, the mentioned databases have been corrupted. Is there a programmatic / automatic way of rebuilding or reinstalling the SSRS databases? If ...