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
45
votes
13 answers

Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=11.0.0.0

I recently upgraded my n-tier solution from .NET 3.5 vs 2008 to 4.5 visual studio 2012. Every thing went fine apart from crystal reports and I had to install new runtime crystal reports for visual studio 2012 from the following link…
3355307
  • 1,024
  • 2
  • 9
  • 30
44
votes
7 answers

Reporting Services: Tablix RepeatColumnHeaders doesn't work on some reports

So I've got various reports that consist of a DataSet rendered in a Tablix... pretty garden variety stuff. There is a property for the Tablix control named RepeatColumnHeaders, which I have set to True for each report in question. The explanation…
Rex Miller
  • 2,646
  • 1
  • 18
  • 26
44
votes
7 answers

Get rid of page breaks in report

How do I get rid of the page breaks in an SSRS report, making the report display in a single page?
san
44
votes
6 answers

Business Intelligence for Visual Studio 2015

Is there any way to get Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 for Visual studio 2015 ? Or will it come later, what is the situation ? ETA: New preview release of SSDT October 2015 Preview in Visual Studio now…
Igoris Azanovas
  • 1,570
  • 1
  • 20
  • 36
44
votes
10 answers

how to remove time from datetime

The field DATE in the database has the following format: 2012-11-12 00:00:00 I would like to remove the time from the date and return the date like this: 11/12/2012
user1860212
  • 495
  • 3
  • 7
  • 8
43
votes
9 answers

Passing parameter via url to sql server reporting service

I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base…
AwkwardCoder
  • 22,434
  • 24
  • 80
  • 143
42
votes
10 answers

SSRS the definition of the report is invalid

How can I resolve the below error message that I receive when I try to deploy my report to our our Reporting Server using BIDS? Message: Error : The definition of the report '/OrderAnalysis' is invalid. Report Element:
jhowe
  • 8,598
  • 15
  • 44
  • 59
42
votes
3 answers

Display .RDLC report embedded in a DLL file

I have a report that is used by a windows service and a form application. So, I want to put embed the report in a DLL file that can be used by both. The problem is that if I try to set the ReportEmbeddedResource property of a ReportViewer control…
Jim
  • 10,765
  • 17
  • 74
  • 114
42
votes
2 answers

SSRS expression replace NULL with another field value

I need to write an SSRS expression to check and replace NULL field value with another field value. Can this be done?
Nite Cat
  • 463
  • 2
  • 7
  • 11
41
votes
1 answer

how do I reference a text box value in an expression? SSRS

I have a list and inside this list I have a text box. Since it's a list, the text box value changes for each row in the dataset. OUTSIDE this list, I have another text box which is part of the HEADER. I want the HEADER to change based on the value…
RJ.
  • 8,356
  • 29
  • 99
  • 176
41
votes
6 answers

SSRS expression to format two decimal places does not show zeros

I am using the following expression to format my value to show only two decimal points. Which Works fine if the value is not 0. However when the value is 0 it does not show 0. eg. Expression used =Format(Fields!CUL1.Value, "##.##") If CUL1.Value…
Abe
  • 1,811
  • 2
  • 20
  • 29
41
votes
6 answers

Telerik Reporting over SSRS?

Broad question is: Is there anything Telerik Reporting can do that SSRS (2005) cannot? Specifics: We're looking to migrate our current Reporting infrastructure from in-house ASP.NET + Crystal (VS Edition) to something else. Ignoring the cost factor…
JPot
  • 4,075
  • 4
  • 21
  • 22
40
votes
5 answers

What are the valid Style Format Strings for a Reporting Services [SSRS] Expression?

I am trying to figure out the style string for the Format(Expression as Object, Style as String) function in a Reporting Services expression. I can't find where these style format strings are documented! Specifically I am trying to format a Price…
Jon Erickson
  • 102,662
  • 42
  • 131
  • 170
40
votes
8 answers

How do I set the visibility of a text box in SSRS using an expression?

I have a subtotal field for a calculated column that I want to hide when my report has not ran yet because on days with no data it shows up as NaN on the report. I have tried two methods but neither are working and I am sure it is almost correct. I…
TWood
  • 2,433
  • 7
  • 34
  • 57
40
votes
2 answers

SSRS How to repeat the table header on each page in print preview

I have an SSRS report, for some reason the header is not repeating on all of the pages in the print preview mode. Below is the image of the table: I have as well checked the Repeat Header rows on each page option as below: I would like the headers…
voonna
  • 651
  • 1
  • 10
  • 24
1 2
3
…
99 100