Stack Overflow
Stack Overflow

Questions tagged [ssrs-grouping]

Microsofts SQL Server Reporting Services (SSRS) allows creation of reports that contain Tablix controls where data is grouped by fields or expressions in row and/or column groups. Use the ssrs-grouping tag for questions about how to use group properties to change report behaviour.

SSRS reports can contain tablix controls (lists, tables, and matrices) which can group data in row and/or column groups. Use this tag for questions specific to this grouping behavior.

412 questions
2
votes
1 answer

Merging multiple Rows in ssrs report to a single one

I need help regarding SSRS Reporting my data is Coming from a Query and I also have added the Column Group Named as Subject Name Showing on the top of the Table() Also Added ApplicantID as Row Group and FName as a Row Group in the Report to fulfill…
Usama Qureshi
  • 83
  • 2
  • 13
2
votes
1 answer

Need new line in SSRS matrix

I have the data int this format in our database - Item1 Item2 Processor Intel i7-4558U 3.30GHz Intel i7-4500U 1.80GHz Intel i5-4200U 1.60GHz Processor Intel Atom™ N2600 1.60GHz Processor Intel i7-2670QM Intel…
Wumar
  • 103
  • 1
  • 1
  • 11
2
votes
1 answer

SSRS Border on Nested Row Group

I am creating an SSRS2012 report. I have a matrix with static columns and nested row groups. I would like to add a top and bottom border on my rows based on the parent group. The matrix looks as follows: [ProcessCell] | [Name] | [Field]| My groups…
lilGrim
  • 23
  • 2
  • 5
2
votes
1 answer

ssrs report : Facing issues with Master detail kind of report

I need to generate a report of below format. The header repeats only per page. ItemNr | ItemGenDesc | FulfilmentBin | onHand ----------------------------------------------- CAP100 Capacitor FulFil1 5 binPriority | binBackup…
Anirudh
  • 581
  • 5
  • 14
  • 32
2
votes
1 answer

Prevent section headers from repeating in SSRS groups

I am using Visual Studio 2010 with SQL Server 2012 I have made an SSRS report called internationaldomestic.rdl. I have not begun decorating the report yet. I am first trying to get the layout correct. All is well so far except the group values…
Jay C
  • 842
  • 6
  • 17
  • 37
2
votes
1 answer

Error in finding sum of a group and Conditional Summing in SSRS Reports

I have an SSRS Report, in the database there is a column by name Total_running_hours. There are more than one record for a single Cycle_number like more than 1 row with same Cycle_number but different Block_numbers and the value in…
Dadapeer Pvg
  • 147
  • 12
2
votes
2 answers

Hiding Sub report in SSRS (and not executing the Stored Procedure)

I can set the hidden property using an expression which will hide/show the sub-report, but what I found using SQL Profiler, is that the sub-report stored procedure is still executed, even if the sub-report is hidden. Is anybody aware of a way to…
user2553512
2
votes
2 answers

SSRS Parse Error local report processing

Please I need your help 4 days i'm searching about solution for this error i have this code : SELECT NON EMPTY { [Measures].[T POND], [Measures].[FACT TABLE Count], [Measures].[disponibilite], [Measures].[POND], [Measures].[T] } ON COLUMNS, NON…
user2638280
  • 21
  • 3
2
votes
1 answer

SSRS Chart: Filtering and controlling axis maximum

I am creating a chart off in SSRS based on software version usage per month. I would like to compare how often each version is used per month in comparison to other versions. The image I'm working with is below: Obviously with one version being…
Jimmy
  • 21
  • 1
  • 2
2
votes
2 answers

Math operators parameters

I wanted to know if we can use math operators in the parameter of the report. I have a parameter called "EMP_Attendance". I want to have the parameter to display and Run the report with values Parameter: EMP_Attendance = 100.00% …
snp.it
  • 512
  • 2
  • 10
  • 30
2
votes
2 answers

SSRS - Reference a Textbox Value from a RowGroup

I have a tablix that is using RowGroups to group instances of data. A textbox in the tablix refers to a field as it relates to everything else in that group of data. I would like to create a textbox outside the group, below the tablix, and have it…
dmedz
  • 191
  • 3
  • 5
  • 14
2
votes
1 answer

SSRS Error - tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members

I have a question regarding SSRS reports. It might be related to Grouping but not sure it will solve my problem. There is letter for customer and he might pass 2- 3 classes. So each customer can have 1, 2 or 3 classes. Now when I do it in the normal…
Akarsh Kolanu
  • 136
  • 2
  • 4
  • 13
2
votes
1 answer

Display a new page for each driver in the main report when using multi-value parameter and subr

I am working on a report that uses multiple sub-reports. I have two parameters: t_driver_pk and BatchID for the report. I have been able to display the data for each driver on a new page in the subreport using page break and repeat header options…
FutbolFan
  • 13,235
  • 3
  • 23
  • 35
2
votes
1 answer

write an expression to check if the any of the value in the group is false

want to write an expression in an SSRS 2008 textbox to check if any of the value in a field in a group is false. If false stop and change the background color of the Textbox. i am trying to do …
snp.it
  • 512
  • 2
  • 10
  • 30
2
votes
0 answers

SSRS group header shows on all but last page

I have had some trouble getting group headers to show on each page, but the steps to achieve this are well documented on here and elsewhere online, but I have a new problem. I have a group header that appears on each page except for the last one. My…
Aheinlein
  • 480
  • 2
  • 7
  • 19
1 2 3
…
27 28