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
1 answer

SSRS: Upload multiple reports to reporting server 2008 R2

Is it possible to upload multiple RDL files in Report Manager? For example: I have 40 rdl files in a folder and I want to upload all these 40 RDLs in a single upload (i.e as a zip or just the whole folder). Normally I have to upload these RDLs one…
Arne Van De Vyver
  • 83
  • 1
  • 7
0
votes
1 answer

SSRS - Sum a column that gets its value from an IIF expression

In SSRS, how would I sum a column that gets it's value from an expression? For example... Field1 | Field2 | Computed Field ------ | ------ | -------------- 10 | 20 | 100 *IIF(Fields!Field1.Value > Fields!Field2.Value, 0,…
bigtri
  • 5
  • 2
0
votes
1 answer

SSRS - exclude hidden values from sum

I did not hide the entire rows. I hid just the duplicated values in one column and I need to sum that same column, excluding the hidden values. Thank you very much. The field having duplicated values that I wanted to hide is SpaceArea This is how I…
Tubi
  • 23
  • 8
0
votes
1 answer

Render parts in SSRS report asynchronously

I'm trying to create an SSRS report and I'm using a lot of SQL queries there. I have several tabs that shows different data to the user. Can I render the stored procedure in all the tabs asynchronously but to show the user only the data he's suppose…
itzick binder
  • 524
  • 10
  • 31
0
votes
0 answers

SSRS Date Part Month Grouping

I currently have a stored procedure for showing sales per day for a year, the field is just a date time field, is there a way I can group by just the month with in a SSRS Matrix without having to amend the stored procedure to show the month? Thanks
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
2 answers

SSRS multi-value parameter issue

I have a parameter that passes these values to a stored procedure: "CA, FL, NY, NJ, MA, CT, RI". The issue I'm having is that if I select the "ALL" option it does not bring back any "CT" values. It does bring back "CT" if I select it individually. …
jackstraw22
  • 517
  • 10
  • 30
0
votes
1 answer

SSRS Color coding value via expression

I have an SSRS Expression that I need to color code if the Score is < .85 font color is Red otherwise black. The output displays a 1 decimal place value (eg. 85.0%, 83.1%'), but when the value is .849 it is changing the color to red because it is…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

Setting specific values in a multichoice parameter

So I want to create a expression that allows me to select specific values from a multi-choice parameter. So in "Available Values" i wanna present specific states like MA, NY, and VA in a label called East Coast and not the other states available.…
Joel Cruz
  • 27
  • 1
  • 10
0
votes
1 answer

Show Only The Value in First Text Box in SSRS Grouping

Hopefully the title explains what I am looking to do adequately. I have a report is row grouped by Survey, then Customer ID, and then Response ID (which shows what instance of the survey the customer took). And in the Detail grouping, the Questions…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
2 answers

Build report with changeable default parameters

I am creating a SSRS report with default parameters. If all parameters have a valid default value, the report runs automatically when it is first viewed. However, after autorunning in this way, it is not possible to run the report with other values…
Iain
  • 387
  • 2
  • 12
0
votes
1 answer

Issue with concat expression

Can someone explain what is happening here please, looking at the expression below, when I run the report the 'to' comes out as 'Ao' ="Date Range Selected: " & Format(Parameters!DateFrom.value, "yyyy/MM/dd" &" to " & Format(Parameters!DateTo.value,…
whitz11
  • 229
  • 2
  • 23
0
votes
1 answer

SSRS on screen preview vs on print preview

I have SSRS report with many rows When I print it, it looks nice, rows are split into multiple pages, each page has its number, that's what I want. but when I click "View Report" button the report show up on screen with all rows in the same page and…
asmgx
  • 7,328
  • 15
  • 82
  • 143
0
votes
1 answer

SSRS Duplicating Date Values Within Rows

I have an SSRS package, and within it, the dates are being duplicated across the columns. For example, select [demographic columns], hireDate, transferDate, promotionDate from userTable where [conditions are met] In my SSMS query window, sample…
Nyra
  • 859
  • 1
  • 7
  • 27
0
votes
0 answers

Report Builder - Grouping a date field by Working week and Days of week

I'm a little stuck here. I have a date field that shows the appointment start dateTime for an officer. eg. 13/04/2017 1:44:00 PM. I am writing a report and would like to first group it by officer, then into the week, and then into days of the week.…
Freddie
  • 51
  • 1
  • 2
  • 12
0
votes
0 answers

SSRS - Unusual error when excecuting

I work with SSRS 2008 R2 and I created somewhat of a larger SSRS report (20-30 datasets, 4 parameters and 6 sources), so to minimize loading time for the end-user, in several datasets, I filtered out year parameters that I am sure won't be used (say…
Bob
  • 467
  • 1
  • 4
  • 13
1 2 3
…
99 100