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

SSR Sorting Expression using Report!Items

I have a report using Matrix table group by Business with Sub-total and grand total. I have a calculated field called "% of Received" column that uses Report!Items in the detail row, and I want to sort it from highest to lowest value…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

SSRS Receiving #ERROR when creating running total using lookup function that has occasional null or zero values

This is what the error looks like I'm trying to accomplish is to subtract sales from inventory then add transfers. When transfers evaluates to zero I am getting the error. I'm new to SSRS so I have kind of hacked this together so far. I am…
escapeclaws
  • 65
  • 10
0
votes
1 answer

SSRS - Expression returning error if null

I'm expecting only the names to appear on the calendar if they exist and nothing if they don't. I created an expression where it returns only the last name of a person by using the comma as a delimiter. My current…
Jonathan Porter
  • 1,365
  • 7
  • 34
  • 62
0
votes
1 answer

Subreport leaving blank space when using keep together

Firstly apologies for the lack of image, since i don't have enough rep to attach of images and had to make do with text drawings I have an issue with SSRS 2008 where I can’t seem to get the keep together property of my report working correctly. This…
Stefan de Bruin
  • 1
  • 1
0
votes
1 answer

Show percentage on Pie chart with multiple datasets

I have developed piechart in ssrs with multiple datasets. My scenerio is to set Percentage format for values in Piechart. For same dataset the percentage value is showed correctly, but for values fetch from another dataset can't fetch percentage in…
KaviSuja
  • 450
  • 1
  • 9
  • 37
0
votes
0 answers

SSRS: Sorting on Lookup field Column within a group

I'm having one field in my table as: =LookUp(Fields!student_id.Value,Fields!student_id.Value,Fields!total_marks.Value, "Marks") When I'm trying to sort the column based on below expression, not having any sorted…
user1751845
  • 11
  • 1
0
votes
1 answer

SSRS adding '' value as a parameter

I am trying to add '' as an optional parameter for the user to select within the dataset that I am using for the parameter in SSRS. Within the dataset I have SELECT '' as user UNION SELECT user FROM users This works fine. However, when I…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
1 answer

How to set up a dataset filter to check for multiple criteria

I have data that I want to filter based on if it matches 1 of 3 criteria. Sponsor Rating = 0 IT Rating = 0 Evaluation code = NC or - (but there are multiple codes and we do not want to leave them out since they may fit one of the other…
jfrederick87
  • 1
  • 1
0
votes
1 answer

How to sum duplicated values in a Group (SSRS)

How to sum duplicated values in a Group. SSRS 2008 My query returns values like the following: But, I want this:
Woraya Huadphithak
  • 3
  • 2
0
votes
1 answer

SSRS IIF DefaultValue Expression ERROR

Trying to string together a SSRS condition that set a parameter dynamically. The user chooses 2 dates @StartDate and @EndDate. The expression i am trying to write will check to see if the 2 dates match and if they are the same datename as well. and…
GPH
  • 1,817
  • 3
  • 29
  • 50
0
votes
0 answers

How to make reporting server to save a generated report in a share path automatically?

I've an existing report which is generated when user passes parameters from the UI. Now, I want the reporting server to save the generated report into the share folder automatically rather than making user to store it. So, whenever user generates a…
R.Sharma
  • 203
  • 2
  • 9
0
votes
0 answers

SSRS limitation : Not able to show RTF data in SSRS Report

I am trying to find a way to display data in SSRS Report which is coming from database and its stores in the form of .rft code in the database. I know Crystal Report can read rtf code and we can set Text Interpretation to none/Html/RTF. But in SSRS…
Deepak
  • 66
  • 6
0
votes
2 answers

Can I colour a column using Interactive Sorting?

I'm using interactive sorting on multiple columns and would like to change the background colour based on the column being sorted rather than just the little arrow indicator. Does anyone have any ideas? Thanks
Adam Fanner
  • 3
  • 2
0
votes
0 answers

Column value to be displayed on the header

I am doing a report using SSRS-2008R2.I have done all the work and table.I have column("Dept").It is done group by and so that the output has each Dept values in a separate page.I also need to keep the Dept value in the header.How to keep it to the…
Krish Dev
  • 13
  • 5
0
votes
1 answer

SSRS Check Boxes

I have a customer demand to create a check box as a parameter . when the checkbox is selected the data should show the value for that checkbox otherwise all data should be shown For example if the table has a column where if a student is active then…
aman6496
  • 143
  • 2
  • 13
1 2 3
…
99 100