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

learn more… | top users | synonyms

0
votes
1answer
15 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
33 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
23 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
34 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
30 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
15 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
21 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
131 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
121 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
106 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
138 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
13 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
47 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
39 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
59 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
125 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 ...
2
votes
2answers
873 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
1answer
81 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
44 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
120 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
151 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
88 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
1k 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 ...
1
vote
2answers
1k 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 ...
7
votes
2answers
2k 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 ...
0
votes
0answers
228 views

SSRS - display in DataSet1 the sum of a column from DataSet2 grouped by a specific group

I've got an excel chart that I'm trying to convert to an SSRS report. I've got 2 charts. One with today's data and the other yesterday's data. C,D columns have changing values. E,F columns have ...
1
vote
2answers
982 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
99 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
88 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
188 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 ...
3
votes
0answers
73 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 ...
0
votes
2answers
309 views

How to add rows/columns to the table in runtime in SSRS 2008

Usually we design the table to have x number of rows and y number of columns in a report. But how can we create a report which adds the rows and columns dynamically at run time based on the result of ...
4
votes
1answer
227 views

Where and how to store my weird datamart

I could really use some help here. Here's my situation. I'm building a datamart in SQL Server 2005, which will furnish a single report (for now). We have 26 clients (medical organizations) that ...
0
votes
1answer
135 views

SSRS 2008 R2 setup issue

I have installed SSRS 2008 R2 on my desktop and server. When I hit the reports link on my desktop http://mypc/Reports_mypc/Pages/Folder.aspx all I get to see is this I cant create a new folder ...
0
votes
0answers
174 views

Calling a MySQL stored procedure with parameters in SSRS reporting through ODBC

In SSRS, when I pass hard-coded values to my stored procedure, it works fine. But it doesn't work when I try to pass the parameters. Can you please tell me the right syntax for calling MySQL stored ...
1
vote
1answer
42 views

SSRS Deployment

I have developed and deploy my reports on report server in LAN. but I want to deploy my reports on report server which is not in LAN. means I need a setup or package which can run at client end ...
0
votes
1answer
72 views

Image fades on the SSRS report

We have a SSRS report built using Report Builder 3. There is a coloured logo on top of this report which is displayed correctly when see the report on screen, print it or export it to Word. However ...
4
votes
2answers
373 views

Slow SSRS Report in production

I have an SSRS report which gets its data by firing a series of stored procedures. Now the report is timing out big time when run in production, yet when I pull down the prod database and restore to ...
1
vote
1answer
63 views

How to create column

I am new to ssrs report designing can any one help me in this I have two question 1) How to create a column to input user data and after that I need to perform some operations on data enter by ...
1
vote
0answers
384 views

SSRS Timeline Chart for each day / minute

I'm asked to make a Timeline Bar Chart with SSRS 2012. There should be 1 chart per day/employee, and this chart should have a x-axis of 1440 minutes (or 24 hours). The bar should have 2 different ...
3
votes
2answers
369 views

Can I programmatically generate reports that are emailed as Excel docs from SSRS?

I've searched already and don't see (or can't decipher) a solution for my issue. I have SSRS emailing a report for 1 district (with 12 retail stores). However, each Region has over 8 Districts, and I ...
2
votes
2answers
316 views

Issue With SSRS Emailing Reports As PDFs

I have a strange issue that I'm unable to find the answer to online or by looking at it myself. Basically when I set up an email subscription for a report I've created in SSRS Report Builder (2008); ...
6
votes
2answers
482 views

SSRS appears to be ignoring Permissions set using Report Manager

I have setup SSRS on SQL Server 2008 in native mode. As an administrator I can login to report manager, upload reports and run them, and also use the Web Service URL to generate reports. I have also ...
0
votes
0answers
991 views

SSRS report viewer - log on failed (rsLogonFailed)

I was redirected here from StackOverflow... I have set up a web based report viewer using the SSRS reportviewer control (sql server 2008 r2) including the ability to specify credentials. When I ...
2
votes
0answers
397 views

SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime

I wrote a report that is executed by a few hundred users each day and the underlying stored procedure for the data set only takes milliseconds to execute. According to the ...
2
votes
1answer
398 views

An unknown error occurred while processing the request on the server [closed]

I have an asp.net 4.0 application with a button that opens a SSRS report. This works fine on my development machine and I can open the report directly with report manager but when I try to access the ...
2
votes
1answer
426 views

SSRS max upload size limitations

We are working on a WiX project for deploying our large application (the server side of the application, that is.) The customer has the choice to have the application server, the SQL Server and the ...
3
votes
1answer
1k views

Real Time SQL Server Analysis Services Cube Processing Report

I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting Services? I would like to be able to run ...
5
votes
2answers
622 views

Options for setting NOLOCK hint in dataset queries

Some context: At first we wrote reports just "straight up", without any locking hints in the queries. With the larger reports this would sometimes cause locking problems. At first we remedied this by ...
1
vote
1answer
639 views

Installing 32bit SSRS on 64bit Windows/IIS

I've inherited a situation where I have SQL Server 2005 Standard 32bit running on Windows Server 2008 R2 64bit. When I come to install SSRS components I'm warned that "Failed to find the ASP.Net ...