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

Actions Within SSRS Maps

I am working on a SSRS report service that has a map which I manage to link it with a tablix through a parameter [Country]. My objective is whenever the user click on a specified coloured country to drill though, the map will direct the user to the…
Dodi
  • 111
  • 4
  • 14
0
votes
0 answers

Legend changing when report is deployed or exported

I have a 100% Stacked Bar chart. Students are banded based on their attendance,and the report simply tracks changes in the band populations as a percentage of the total student population. In Report Builder, this works totally fine (except in that…
Dan Scally
  • 1,922
  • 1
  • 19
  • 31
0
votes
2 answers

SSRS Grouping Data Together

I have a report that lists securities that are held and there security types. I want to some business logic that says security types 1, 2 and 3 are Equities, while security types 4, 5 and 6 are Bonds and then I want to group the report by these.…
KDouglas
  • 15
  • 1
  • 4
0
votes
1 answer

concatenate Group by values in ssrs

I have the date field and description in ssrs.In description I have 1,2,1 values. I need to concatenate description values and remove duplicate values. I need to show the result in another column. how can I write the expression for this.? Thanks in…
User
  • 45
  • 1
  • 10
0
votes
1 answer

multiple column value to single value with IIF condition in SSRS

Hi Team, I have a SSRS report like this, the users would like to see the data like the picture below. For Column 2 if the value is N/A the values of column 3 would be in list and separated by comma. and the multiple lines will be converted to only…
aman6496
  • 143
  • 2
  • 13
0
votes
1 answer

SSRS How to hide the entire subreport based on a multi value parameter

I have 2 reports Report 1 (Main) and Report 2 (Sub-Report attached to Report 1). I have a multi value Parameter called Business - "COM" and "GOV". The logic of the report are: a.) If Business="COM" show "COM" report and hide "GOV" sub-report. b.)…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

How to have a custom date in SSRS chart?

I am having a column chart and on its horizontal axis I have date. I want to have custom way of displaying date. The month should appear only once with the date and it should reappear only when the month changes. Below is the snapshot of what I wish…
Jatin
  • 47
  • 1
  • 10
0
votes
1 answer

SSRS 2008 IE11 content Overlapp

There are many IE 11 SSRS compatibility issues reported. However I can't find any similar to mine: rectangle not auto-stretched. content following are not auto-positioned. Better show than say.
Jeb50
  • 6,272
  • 6
  • 49
  • 87
0
votes
1 answer

SQL Server reporting services scheduler loops, running amok

We have a Windows Server 2008 R2, Service Pack 1 with an SQL Server 2008 R2 (Microsoft SQL Server Standard Edition (64-bit), version 10.50.4042.0) for creating scheduled reports in SSRS. The Report Server services didn't start up after a server…
user2379527
  • 1
  • 1
  • 1
0
votes
1 answer

SSRS STUFF() USING XML PATH ISSUE

I have a SQL query the uses STUFF() with XML PATH syntax to combine multiple rows of clients in one row based on the parent client. It should only combine Clients under the Parent Client, but what is happening when I run the script is that it is…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
0 answers

SSRS Graph not showing in IOS 10

I have an SSRS subscription report that sends an email with a graph at the bottom of the email. The delivery method is MHTML. I've had this job running for a few years now. I just noticed that the graph/chart does not show on the email if the iphone…
user7542630
  • 1
0
votes
1 answer

SSRS Report Grouping (Parent and Child)

I am trying to establish a grouping for CSG1 and Section to look like below where the CSG is the parent then the Section is the Child and the expression will be the detail. Somehow, after I defined the parent and child group the section is aligned…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
2 answers

Aggregation with nestged groups in SQL Server Reporting Services

Let's say we have the following data structure in SSRS report: Disctricts are grouped by city and cities are grouped by country. And then at the country level I'd like to get SUM of population over cities (population is an attribute of a city and…
Andrey Grachev
  • 1,259
  • 1
  • 14
  • 22
0
votes
1 answer

write a condition in SSRS as specified

I am trying to find out how can I write the below logic in SSRS: The structure of my report is: All the rows and columns are grouped together. The New Week Status has 2 fields: Current Week and Previous Week. Current Week ranges from 30th Jan -…
Shivang
  • 231
  • 1
  • 5
  • 17
0
votes
1 answer

disable auto update of datasets parameters in SSRS

Every time i pick a value from one of the parameters combos - the datasets that connected by filltering to the chosen dataset are automatic update by sending queries to the SQL DB . The avaiable values lists that contains the datasets are not…
Asaf Suisa
  • 1
1 2 3
…
99 100