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

How to create depended parameters in SSRS report

I can create depended parameters with cascade parameters. when I create cascade parameter ı can just one direction choosing. but ı want to choose parameter Bidirectional choosing. for example I have @region_name, @countr_name and @state…
Aylin
  • 177
  • 5
  • 17
0
votes
1 answer

Needing to Display Multiple Rows Per Page in SSRS

I've got a report that I would like to display the first three rows on all pages of the report. I have got the first row repeating on each page, but I am having trouble with the second and third rows - they will not repeat for some reason. Here is…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
0 answers

An error occurred during local report processing(excelrender).The row item structure object corresponding to a line cannot be Null

I used SSRS report.I tried to export report to excel I got this error.Please can you help me.
Manoj K
  • 21
  • 2
  • 7
0
votes
1 answer

Put bars inside of each other in SSRS, but not stacked

In SSRS in a bar chart, in order to save space I would like to put two bars inside of each other (or behind if you want to say so, but not stacked). How is that possible? See example image. Sample image
Steffen Maier
  • 101
  • 3
0
votes
0 answers

column value shifts with Expand / collapse in ssrs

I have created a report in ssrs. The values in column named 3 will be getting expanded whenever I press the (+) sign on the customer column. But before expanding, the column 3 will not have any values so all the values from the nearby columns get…
Arockia Nirmal
  • 737
  • 1
  • 6
  • 20
0
votes
2 answers

Gap between two categories in SSRS column chart

I have created a column chart something like this - But I cannot reduce the gap between two years (should have no gap between year category). also I need more gap between Months. My intention is to compare the months between this year and previous…
Paul
  • 127
  • 1
  • 2
  • 8
0
votes
2 answers

Set expression for hidden ssrs

I want to display only first 10 rows and hide remaining rows in a column. what will be the expression for this (Set expression for: Hidden) in Tablix properties -> visibility -> show or hide based on expression. My dataset name is…
user2331670
  • 335
  • 2
  • 6
  • 15
0
votes
2 answers

SSRS - Show only top 50 rows

I am using SSRS 2014 version. I have below SSRS report and I wanted to display only first 50 rows (Supplier), How can I do this please? MY SQL code is, SELECT s.[CusNo] Supplier, RTRIM(CAST(s.[Customer] AS VARCHAR(50)) ) AS Name, s.[ConcessionNo]…
user2331670
  • 335
  • 2
  • 6
  • 15
0
votes
1 answer

How to retrieve max date for To_Date parameter

I have one To_date parameter in my report, and I have to pass max date vale into the To_Date parameter from two data sets, which contains date. How can I write expression to retrieve max date?
Swapnil Date
  • 9
  • 1
  • 7
0
votes
1 answer

Gain access to SQL Server instance to be able to set up a user that can subscribe to reports in SSRS

I have a SQL Server instance that has been in place with our company for several years. There is an SSRS site (and reporting database) associated with it where you can run reports from. We now want to be able to Subscribe to reports from that SSRS…
Gallus
  • 335
  • 3
  • 21
0
votes
2 answers

ssrs matrix not sorting and not getting other months

I have a dataset like I am creating a matrix to represent the data like this- The problem is since I don't have other months (Mar-Dec) in the Dataset, I'm getting for first two months only (Also not in order). I'm new to SSRS and your help is much…
Paul
  • 127
  • 1
  • 2
  • 8
0
votes
2 answers

How to Pass nth row value from Main Report to SubReport in SSRS

I am using SSRS report where Main report using one subreport. I want to retrieve one cell data from main report which located on 88th row and column name is FullYear. I tried below…
Keval Patel
  • 925
  • 4
  • 24
  • 46
0
votes
1 answer

How to create two column groups one after other in SSRS?

Database Output Required output
Bhaktha
  • 1
  • 3
0
votes
1 answer

SSRS 2008 R2 Tablix Goto URL Action Outlook

Reporting Services 2008 R2 Tablix Go to URL Action . . . I have the following expression . . . ="mailto:" & "email" & "?subject=" & "My Email Subject" & Fields!ReferenceNo.Value & "-" & Fields!ShortName.Value & "&body=" & "Hi," + vbcrlf + vbcrlf +…
wodz
  • 67
  • 8
0
votes
1 answer

SSRS SubReport - Set to Not Grow, but it continues to grow

I am building out a report that contains a Sub Report, I need that Sub Report to be a static size. I've researched and read that you can place it in a tabix and set the row CanGrow to False. However, as soon as I put the sub report in the row, the…
ItalianStallion4215
  • 139
  • 2
  • 11
1 2 3
…
99 100