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
0
votes
2 answers

Add "ALL" to drop down which is fetching values from query - SSRS 2008 r2

I have report, which has drop down to select warehouse code and it show stock position at that selected warehouse, these warehouse codes are populated through query at available values part, i would like to add in the same list as ALL, how to…
Saifuddin
  • 99
  • 2
  • 3
  • 10
0
votes
0 answers

SSRS 2008 R2 Have Row BackgroundColor inherit from Cell Background Color

I'm tweaking a reconciliation report and would like to be able to set the background color at both the row and the cell level. At the cell level to highlight specific fields which are incorrect and at the row level to highlight when an entire…
Kevin Pope
  • 2,964
  • 5
  • 32
  • 47
0
votes
2 answers

Using multi-valued parameters together in main query

I have a report that uses two multi-value parameters in the query. @garageId and @createdYear are both set as multi-value parameters with a default value of zero(0). If I run it in SQL Server Management Studio, like below, I get the expected…
SkyeBoniwell
  • 6,345
  • 12
  • 81
  • 185
0
votes
1 answer

Display Month Gaps for Each location

I have the following query which takes in the opps and calculates the duration, and revenue for each month. However, for some locations, where there is no data, it is missing some months. Essentially, I would like all months to appear for each of…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
1 answer

SSRS - Get current tablix iteration index

I have a report which contains a tablix. Within this tablix I have a subreport that is called at each tablix iteration. I would like to obtain the current index of the tablix iteration inside the subreport. I have passed a subreport parameter using…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
1 answer

SSRS Matrix header repeat on each page (but outside of group to show every header from ds?)

I have a Matrix which I am trying to get a specific header to repeat on each page. To keep it simple it looks something like this: | | Months | |Division| | | Name | Sales | --- new page for each division --- If I include…
Jay
  • 455
  • 3
  • 17
  • 34
0
votes
1 answer

Javascript Code is not working in Chrome and firefox but works in IE

I am using this code to append some code to a div. $(document).ready(function () { $("div[style='padding-left: 6px;']").append("
Shivan Bhatia
  • 38
  • 2
  • 10
0
votes
1 answer

IIS 8.5 connecting to remote report services

Here is the scenario: A web server is running on IIS 8.5 using AppPoolIdendtity to pass through the credential to connect to Reporting Service which is remotely installed in a MSSQL Server. The reporting service has added the machine account…
Roger Seto
  • 41
  • 1
  • 7
0
votes
1 answer

SSRS tablix show sales vs budget

I am struggling to understand a way to get the following in a proper tablix in SSRS. I would like to have a tablix report with the following. NOV 2016 DEC 2016 Sales Target Sales Target CustomerA 100 200 …
Koen
  • 858
  • 2
  • 7
  • 22
0
votes
1 answer

SSRS Creating a Matrix for each category and page break between them

I'm trying to do 2 things: Create a matrix that will dynamically regenerate itself for each category in my dataset (could be 2 categories, could be 10) Create a page break between each one. So as a visual, something along the lines of…
Jay
  • 455
  • 3
  • 17
  • 34
0
votes
1 answer

Collapse some fields in drill down

I have a below requirement in Drill down report. we have below two values under Lost Customers. Lost Customers, Number of lost customers, Rate% Here I need to implement , where I always need to show Number of lost customers and implement drill down…
ramu
  • 121
  • 1
  • 13
0
votes
1 answer

Report layout not as expected

When my report contains only 3 records the report layout printed is fine but this is what happens when there are 5 records: However my expected result should be like this: As you can the Totals should appear at the bottom not in the middle. Mind…
Expert Novice
  • 1,943
  • 4
  • 22
  • 47
0
votes
1 answer

Add color and format data in table header and body only in excel export SSRS

In my SSRS report body I have added a table with header. I need help in 2 tasks here please. I need to add background color to the header of table only while exporting it to excel.(Not while viewing it on web/exporting to PDF) If the table data…
prameela rani
  • 223
  • 3
  • 15
0
votes
1 answer

Why do we get "An unexpected error occurred in Report Processing" in SSRS 2008?

We often see this kind of errors in SSRS log file. This seems like internal error happening inside SSRS engine. How can we debug this ? We are not getting any other relevant information when report…
Zeus
  • 3,091
  • 6
  • 47
  • 60
0
votes
1 answer

How To Specify Two Default Dates In Parameter

I'm using the following expression to pull a default date from yesterday: =DateAdd("d",-1,Today()) The business requirements changed and now they want to see yesterday AND today. Is it possible to add onto this expression to include yesterday and…
Byronyk
  • 29
  • 2
  • 8
1 2 3
…
99 100