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.

6153 questions
7
votes
6 answers

SSRS: Showing the correct execution time on a two page report?

I'm just wondering how I can show the correct execution time on a report? Until recently I had been using the following in the footer of my reports as a label expression: ="Execution Time: "…
Michael A
  • 9,480
  • 22
  • 70
  • 114
7
votes
4 answers

SSRS 2008: How to repeat on new page one row of table header

I have table with 3 rows of header, and I needed repeat on new page only second row, first and third is not needed in the pages, excepts first page. If I set the properies "RepeatOnNewPage" in the second row only, SSRS show the error: "The…
ABarto
  • 235
  • 2
  • 3
  • 12
7
votes
1 answer

SQL Server 2008 Reporting Services slow reports

I have a problem in SQL Server 2008 Reporting Services. The problem is that the report is sometimes too slow to render (it takes more than 30 min), although I took the query and executed it in SQL Server Management Studio and it didn't take more…
Sami
  • 5,819
  • 1
  • 23
  • 30
7
votes
1 answer

Advanced Gantt Chart for SSRS2008

I have been working in SSRS 2008 r2 to produce some complex reports. it seems to meet 80% of our reporting requirements. However, when it comes down to more complex reports, it turns into some pain in the back side really. I need to generate a sort…
AnarchistGeek
  • 3,049
  • 6
  • 32
  • 47
7
votes
3 answers

VisualStudio Report Viewer not rendering report body in Chrome

I'm aware that Chrome is not supported - http://msdn.microsoft.com/en-us/library/ms156511.aspx for the Report Viewer. The solution here has not worked for me ReportViewer problem in google chrome unfortunately In our case the report body is blank. I…
Liam
  • 1,267
  • 2
  • 17
  • 30
7
votes
4 answers

Sql Server 2008 Reporting Services: Using two dataset error

Im building a report that's using two datasets. when I preview I find these types of errors... Error 19 [rsFieldReferenceAmbiguous] The Value expression for the text box ‘Textbox3’ refers directly to the field ‘PerZipCode’ without specifying a…
2boolORNOT2bool
  • 557
  • 3
  • 9
  • 23
7
votes
2 answers

Reporting services right item alignment

Is there a way to make items right aligned, say with the page or with some other item in a report, using reporting services 2008 ? Right now, I'm sort of emulating this behaviour by shifting items to the right manually so that they look right…
Saulius Valatka
  • 7,017
  • 5
  • 26
  • 27
7
votes
2 answers

SSRS 2008 date formatting and exporting to excel confusion

Suppose I have a field with a date value in a Reporting Services template, e.g. =CDate("2010.12.03"), I apply the "d" format to this cell, which, according to the description, "will reflect the regional settings of the report". I generate the report…
Saulius Valatka
  • 7,017
  • 5
  • 26
  • 27
7
votes
4 answers

SSRS Report Colours change when exporting to excel

When we export an SSRS 2008 report to excel and then copy a range from that file to another excel file, the colours used in the report are changed to something that is totally different, very annoying when we use 'Conditonal Formatting' to colour…
Matt
  • 825
  • 2
  • 13
  • 25
7
votes
1 answer

SSRS Formatting for negative numbers

Ok, so I am familiar with formatting the colors of a cell like this =IIF(SUM(Fields!Dollars.Value) < 0, "Red", "Black") but, I have inherited a report that has 80 columns and 4 rows of calculated fields which all print out black. I have been tasked…
Jmyster
  • 965
  • 2
  • 9
  • 27
7
votes
2 answers

Blank lines at end of SSRS CSV Export

When exporting information from SQL Server Reporting Services in CSV format, it always appends two blank lines after the last row of data in the exported file. Whilst I can edit the file after the export and remove the blank lines, is it possible to…
Pervez Choudhury
  • 2,892
  • 3
  • 27
  • 28
7
votes
1 answer

How to repeat text box in every page in ssrs

Is it possible to repeat textbox in every page without giving it on the page header in SSRS. Because before this textbox I have few data to be displayed in the 1st page. So if I put both in page header and making visibility hide for the data that…
Alex Mathew
  • 340
  • 1
  • 3
  • 12
7
votes
1 answer

SSRS Subscription failure rsProcessingAborted

I have subscriptions that are failing to run giving the error: Failure sending mail: An error has occurred during report processing.Mail will not be resent. The report runs fine when requested manually through the server so I know the datasource…
S Hanson
  • 168
  • 1
  • 2
  • 10
7
votes
5 answers

I want Datetime Parameter in DDMMYYYY Format in ssrs report

I want to change the Datetime parameter to DDMMYYYY format.its default value is MMddYYYY.when user will select date from date picker the date should be display in ddmmyyyy format. I tried all expression like =Format(Parameters!DateFrom.Value,…
Rock
  • 161
  • 2
  • 6
  • 17
7
votes
4 answers

Using Shared Dataset in Subreport

Greetings! I am using SSRS with MS SQL Server 2008 R2, which has the new feature of supporting shared datasets. First, I created my shared dataset, and made sure that it worked correctly and had a good connection. That worked great. Second, I…
Logitron
  • 73
  • 1
  • 1
  • 5
1 2 3
…
99 100