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
0answers
479 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
141 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 ...
3
votes
0answers
314 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
3k 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
185 views

Does reporting webservice url contain the function that helps to export the report to the client version?

The reporting webservice url contains the webservice url that contains all the information of the Reports which are created in SSRS. As the report has been created on reporting service, i want to ...
1
vote
1answer
2k 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 ...
3
votes
1answer
574 views

Exporting SSRS report to Excel

We have a number of SSRS reports and want to show the report in Excel format to the users. SSRS has provided an option to save the report in Excel format (.xls), however when the report is saved as ...
1
vote
2answers
828 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" ...
1
vote
0answers
155 views

Using #temp to work around Reporting Services blocking issue

Having utterly failed to resolve why a perfectly acceptable but admitidly large stored procedure was suffering the blocking process lck_m_s when called via a report in SQL Reporting Services I have ...
1
vote
1answer
549 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
56 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 ...
1
vote
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 ...
0
votes
1answer
173 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
1k 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: ...
0
votes
1answer
1k views

Reporting Services TempDB lock blocking report generation

Two days ago one of our reports in Reporting Services started to take much longer to generate. Its generation time had increased from 4 seconds to 2 minutes. Investigation found: The Stored ...
1
vote
0answers
19 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 ...
0
votes
1answer
218 views

sysadmin security error creating Reporting Services cache refresh plan in Report Manager

On SQL Server 2012 (SP1) Reporting Services (native), when creating a cache refresh plan in Report Manager, I receive the error: Only members of sysadmin role are allowed to update or delete jobs ...
1
vote
1answer
680 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
546 views

Do I need to have enterprise server in order to have multiple data sources in SSRS

I am currently running a single server setup of SSRS on MSSQL Server 2008 R2 Standard Edition and would like to know if I can have multiple data sources in this type of setup. The reason I ask this ...
2
votes
2answers
8k 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
5k 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
866 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
0answers
853 views

SSRS 2008 report fast in test, slow in production: parameter sniffing problem?

We recently had an issue with reports running in an integrated SharePoint environment where the report runs fine in development, test and staging, but very slow (times out) in production. Running ...
1
vote
2answers
3k 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 ...
1
vote
0answers
451 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
1answer
446 views

SQL Server Reporting Services: How to check who accessed certain report?

I am in process of eliminating who should have access to SQL Server Reporting Services reports that I have created. Is there a way to find out who has accessed certain reports during past month? My ...
0
votes
0answers
112 views

SQL Server Reporting Services Upgrade/Migration

I couldn't find any documentation on this. I'm currently doing a dry run of SSRS 2005 to SSRS 2008 R2 upgrade/migration. I've backed everything up (encryption key and configuration files) and did a ...
1
vote
1answer
541 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
1k 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 ...
1
vote
1answer
2k views

SQL Server 2012 Express Report Services report builder button not visible

I am trying to run SQL Server 2012 Express Report Services on Windows 7. I finally have it configured, but I'm not sure the missing steps that is preventing the Report Builder button from being ...
1
vote
3answers
8k views

SSRS Reports Manager Security Configuration

I happen to be setting up a reporting server at work from scrach. Having very little almost no experience of sql server administration I am finding it really difficult to configure the security ...
6
votes
2answers
26k 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
13k 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
51 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 ...
1
vote
2answers
8k views

Best Possible Solution for Reporting Mirroring or Replication?

Hi I have SQL SERVER 2008R2 Data Centre Edition and I use SSRS and a Vendor application for reporting. I have a Reporting Server where we backup and restore everyday from Live Server to have Data ...
2
votes
0answers
248 views

Is it possible to configure Reporting Services to emit browser compatibility headers?

We have a dashboard that hosts some Reporting Services (2008) reports within frames. The dashboard runs in the browser's standards compliance mode, but this is causing some of the reporting services ...
3
votes
2answers
2k views

Where to put ReportServer and ReportServerTempDB databases?

I have a SQL Server 2008 R2 database server that hosts a data warehouse database. On this server is also installed SQL Server Reporting Services, and its two databases ReportServer and ...
0
votes
0answers
2k 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
657 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 ...
4
votes
1answer
2k views

Can non-domain-connected users use Report Builder

I'm dealing with a scenario where SSRS is being provided to remote clients on a different domain. We've discovered that they can launch Report Builder (a ClickOnce application) from their Report ...
1
vote
0answers
503 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
9k views

SQL Server 2012 Reporting Services: “Unable to connect to the remote server”

I am trying to install SQL Server 2012 Reporting Services on Windows Server 2008, but all the web interface says after adding the feature and confirming all the default settings in Reporting Services ...
5
votes
1answer
11k 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 ...
4
votes
2answers
9k 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 ...
11
votes
3answers
10k 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 ...
2
votes
1answer
4k views

Reporting Services TempDB keeps going into restoring mode

I am looking into an issue with SQL Server 2008 Reporting Services. It has been working fine until yesterday morning. Now I notice that ReportServerTempDB keeps on going into Restoring... mode. I ...
1
vote
2answers
8k 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
959 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
253 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
501 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 ...