Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008]

Microsoft SQL Server 2008 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed. Use with the [reporting-services] and/or [ssrs] tags

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2008. More info in the tag.

This tag is for questions specific to SSRS 2008.

6061 questions
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
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
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
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
71
votes
6 answers

Is there an easy way to rearrange tablix columns in SSRS design mode?

I have an SSRS report which contains more than 20 columns in a tablix. Our users have decided that the data is OK, but they want the columns moved around (sigh!). It seems like it should be easy to re-arrange the columns (move column 3 to column 1,…
PaulStock
  • 10,373
  • 8
  • 45
  • 52
69
votes
9 answers

In SSRS, why do I get the error "item with same key has already been added" , when I'm making a new report?

I'm getting the following error in SSRS: An error occurred while the query design method was being saved. An item with the same key has already been added What does an "item" denote, though? I even tried editing the RDL and deleting all references…
Caffeinated
  • 10,270
  • 37
  • 107
  • 197
54
votes
10 answers

Line break in SSRS expression

I'm having trouble adding a line break in SSRS 2008. I've tried all of these different ways but nothing is doing it. "+ chr(10) +" , "& chr(10) &" , "& chr(13) & chr(10) &" , "& vbcrlf &" , "+ vbcrlf +" , "Environment.NewLine" Here's my textbox…
Jt2ouan
  • 1,834
  • 8
  • 27
  • 55
49
votes
8 answers

Reporting Services permissions on SQL Server R2 SSRS

I'm getting the error below when I try and access SSRS on SQL Server 2008 R2 I'm not sure how many others have started using SQL 2008 R2 SSRS, but I am having an issue with getting the error below when I try and access the reports server url User…
AJM
  • 30,452
  • 47
  • 147
  • 238
48
votes
4 answers

SSRS 2008 - Dealing with division by zero scenarios

We're running into a problem with one of our reports. In one of our tablixes a textbox has the following expression: =Iif(Fields!SomeField.Value = 0, 0, Fields!SomeOtherField.Value / Fields!SomeField.Value) Which should be pretty self-explanatory.…
tobias86
  • 4,759
  • 1
  • 19
  • 30
45
votes
7 answers

Forward dependencies are not valid in SSRS

I got a problem while creating a report in SSRS. The ERROR shows: Error 1 [rsInvalidReportParameterDependency] The report parameter ‘COUNTRY’ has a DefaultValue or a ValidValue that depends on the report parameter “COUNTRY”. Forward…
satwik
  • 481
  • 1
  • 5
  • 6
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
41
votes
7 answers

Inserting a Page break into an SSRS report

I have a report in SSRS that contains 12 subreports. After each subreport, I need to insert a page break so that each subreport starts on a new page and doesn't share pages with the other subreports. Does anyone know how to do this? Thanks
MikeTWebb
  • 8,461
  • 25
  • 86
  • 129
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
35
votes
17 answers

Using the IN operator to filter in reporting services

Can anyone advise what the syntax should be when using the IN operator within a table filter. I have tried the below but the snytax is wrong:
JsonStatham
  • 8,163
  • 26
  • 88
  • 160
1
2 3
…
99 100