Stack Overflow
Stack Overflow

Questions tagged [reporting-services]

SQL Server Reporting Services (SSRS) is a server-based report generator from Microsoft. It provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization.

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service.

Reports can be scheduled by date and time for automatic delivery via either email(Subscription) or saved to a file location. SSRS supports the following exported file types: XML, CSV, PDF, MHTML, Excel, Powerpoint, Tiff and Word.

Its web services interface also supports the development of custom reporting applications. SSRS can also be integrated with SharePoint. SSRS competes with other reporting tools, most prominently .

Useful Links

Versions

Each release accompanied the corresponding Microsoft SQL Server release.

Types of questions that belong to this tag:

  • Creating or editing Reporting Services reports
  • Report Layout
  • Report Manager administration
  • Report Server administration
24186 questions
200
votes
8 answers

SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report through a multi-select…
ErickTreetops
  • 2,591
  • 4
  • 21
  • 30
198
votes
14 answers

How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the layout size in report properties as width=18in and…
brijit
177
votes
7 answers

DataSet panel (Report Data) in SSRS designer is gone

In the layout screen of an SSRS designer e.g. Visual Studio, I have lost the report data panel. It has disappeared and I can't remember what it is called in order to get it back. This usually lists the following items: Built-in…
bigoteetoe
168
votes
6 answers

Tablix: Repeat header rows on each page not working - Report Builder 3.0

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in Report Builder 3.0. Is this true? If not, is there…
Ayrton Senna
  • 3,385
  • 5
  • 30
  • 45
142
votes
18 answers

Add alternating row color to SQL Server Reporting services report

How do you shade alternating rows in a SQL Server Reporting Services report? Edit: There are a bunch of good answers listed below--from quick and simple to complex and comprehensive. Alas, I can choose only one...
Michael Haren
  • 97,268
  • 39
  • 159
  • 200
139
votes
13 answers

How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I want output display like 4/12/2013 12:05 PM
Neo
  • 13,482
  • 47
  • 173
  • 339
127
votes
6 answers

SSRS chart does not show all labels on Horizontal axis

My SSRS report does not show all the labels on the horizontal axis. Please see below. Note how the red arrows point to the few that do show. So my question is, where are the rest of the labels? Each bar should have one. For the chart I'm adding…
Zolt
  • 2,661
  • 7
  • 38
  • 56
120
votes
10 answers

When to use RDLC over RDL reports?

I have been studying SSRS 2005 / 2008 in the past weeks and have created some server side reports. For some application, a colleague suggested that I look into RDLC for that particular situation. I am now trying to get my head around the main…
Daan
  • 6,816
  • 4
  • 26
  • 37
104
votes
21 answers

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted to user are…
jbcedge
  • 16,749
  • 26
  • 64
  • 88
93
votes
5 answers

I lost datasets pane in Visual Studio

I'm developing a report in the Business Intelligence studio and I lost my dataset. The pane was near toolbox, and it is gone. What is the name of the pane I should to reopen?
user194076
  • 8,257
  • 21
  • 79
  • 147
85
votes
10 answers

SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports are blank in Safari and Chrome

I migrated our reporting services from version 2008 to another server version 2008 R2. In version 2008 the reports work fine on Safari. The new version 2008 R2 the reports do not show up at all. All I see is the parameter section and then the report…
Anita C
  • 859
  • 1
  • 7
  • 4
84
votes
18 answers

Compare SQL Server Reporting Services to Crystal Reports

Which of Crystal Reports and SSRS (SQL Server Reporting Services) is better to use?
RBS
  • 3,481
  • 11
  • 31
  • 32
83
votes
17 answers

SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8... why?

I have some simple reports in SSRS 2008 R2, but they won't display at all in Safari or Chrome. According to Microsoft's Books Online, these browsers are supported in limited fashion. However, I can't see anything after the data "Loading" clock…
Greg H
  • 831
  • 1
  • 7
  • 4
81
votes
4 answers

Display Parameter(Multi-value) in Report

Can anyone tell me how to display all the selected value of my multi value parameter in SSRS report. When giving parameter.value option it gives error.
suni
78
votes
17 answers

Fast query runs slow in SSRS

I have an SSRS report that calls out to a stored procedure. If I run the stored procedure directly from a query window, it will return in under 2 seconds. However, the same query run from an 2005 SSRS report takes up to 5 minutes to complete. …
user275554
  • 2,061
  • 2
  • 13
  • 6
1
2 3
…
99 100