Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
4
votes
1 answer

SQL 2008 R2 SSRS export to Excel

I have a SSRS report that works fine but has an issue exporting to Excel or CSV formats. I tried exporting to excel but errors out saying it has more than 256 columns. So I was hoping I could just export it to CSV format. But with CSV I noticed that…
GSR
  • 115
  • 2
  • 12
4
votes
0 answers

Not able to add "Microsoft.ReportViewer.WinForm" v11 reference to VS2012 project

I was asked to migrate a WinForm application developed over Visual Studio 2008 to Visual Studio 2012. One of the win-forms contains a Report Viewer component that is taking more time than I would have expected due to a…
G21
  • 1,297
  • 2
  • 18
  • 39
4
votes
2 answers

SSRS Error in custom code: expression expected

I am using a couple of custom functions to perform some stats in SSRS. The code was built and tested in Visual Studio 2010, and works just fine when I try and preview the report. However, when I try and deploy the report to SSRS 2008R2 I get an…
Haris Khan
  • 442
  • 1
  • 5
  • 10
4
votes
1 answer

Multiple tables referencing the same dataset

I have a single shared dataset which calls a stored procedure. I have multiple tables which use the same dataset and has filters on the table itself to only include certain records. Does the dataset get called for each table or does it only get…
user172839
  • 1,035
  • 1
  • 10
  • 19
4
votes
2 answers

Replacing empty values with zeros

I know this question has been asked many times before, but having followed previous solutions I still can't resolve the issue: I have a SSRS (2008R2) report, that displays data in a matrix. There is a horizontal column group containing values that…
KenD
  • 5,280
  • 7
  • 48
  • 85
4
votes
1 answer

how to display multivalued parameter value in SSRS text box

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should display just…
SqlLearner
  • 763
  • 8
  • 23
  • 37
4
votes
2 answers

SSRS How do I rotate between reports in a slideshow manner?

I have been tasked with creating a dashboard to be displayed on TV monitors. This dashboard has 5 different charts that need to be displayed in a slideshow manner - in other words, one chart at a time, rotating to the next over a timed interval. I…
Chris Perry
  • 43
  • 5
4
votes
2 answers

SSRS not rendering all page breaks in PDF export

I have a report is ssrs, it consist of a main report which has a header containing the page number and 2 sub reports (report page 1 and report page 2) within a tablix. Report page one comes first, then report page 2 displays on the next page after…
Kevin
  • 205
  • 5
  • 21
4
votes
1 answer

SSRS Reportviewer in MVC, removing iframe scrollbars by auto-sizing iframe to fit report

I have pieced together information on eliminating iframe scrollbars in favour of the browser scroll bars when rendering a reportviewer in an iframe. MVC does not support rendering a report viewer in a view, hence the need for an iframe. Edit: i…
sawe
  • 1,141
  • 14
  • 24
4
votes
2 answers

Eliminate #Error within Report Builder 3.0 when dividing by 0

When the following formula divides by 0, all three of the below are returning…
user3847080
  • 43
  • 1
  • 3
4
votes
0 answers

SSRS Subreport parameters

I have a simple dashboard that keeps track of time sheets and allows me to see who has missing, or late time sheets. I also have simple parameters like Division, LineOfBusiness, Department, etc... The dashboard gives some overall counts of records.…
spaceherpe61
  • 43
  • 1
  • 5
4
votes
3 answers

Reporting Services report hangs in Internet Explorer only

I have a SSRS2008R2 report that runs just fine through Chrome and Firefox but will not run at all in Internet Explorer. I have tried IE9, IE10, and IE11 but I get the same results. I just get the green 'Loading' circle but the report never opens. …
Derrick Van Hoeter
  • 157
  • 2
  • 3
  • 10
4
votes
0 answers

SSRS 2008 R2 custom code clear dictionary in render lifecycle event

My report gets data from SQL based on a date range, uses custom code to calculate totals by Employee and CategoryType and stores the values in a dictionary. To get the grand total by Employee, in a matrix cell, I call a function and pass it the…
devbb
  • 41
  • 1
4
votes
5 answers

What do multiple reports listed in a single SSRS report mean?

I have one SSRS report like following (image) I'm new to SSRS; what does this report mean? If I need to change any parameter value for this kind of report, do I need to go to every report and change the parameter for them individually?
Neo
  • 15,491
  • 59
  • 215
  • 405
4
votes
1 answer

Passing Parameters In SSRS

I have 5 reports, which I need to render on seperate pages of an Excel Workbook, so I have created a Master report and intend to call them as subreports. This works perfectly, but the problem is that I need to control the name of each worksheet, and…
Pete Carter
  • 2,691
  • 3
  • 23
  • 34
1 2 3
…
99 100