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

How to show 2 rows as 1 row in ssrs table?

I get data as below from dataset Year custname custnum Jan feb Mar Apr May Jun 2013 ABC Ability 000104 199145 9299 1496 0 0 0 2012 ABC Ability …
user2721874
1
vote
2 answers

SSRS Report - Specific Format

I have a table Project. ProjID Proj_task 1 NIT 2.0 2 SSRS I have table called Project_Task. ProjID Task_DS User 1 task1 User1 1 task2 User2 1 task3 User3 2 task4 …
sk7730
  • 636
  • 3
  • 9
  • 32
1
vote
1 answer

SSRS 2008 R2 split column /into 3 valuesd

In an SSRS 2008 existing report, I have one column that I need to separate the values. I am not allowed to change the database. I am told that I need to work with the data as it is. The values in the column look like the following 099 11-12 Midwest…
user1816979
  • 511
  • 4
  • 13
  • 25
1
vote
1 answer

How to display data for individual days in SSRS

In my database, I have the data in the below format: and in my SSRS (2010) report, I need too show the data in the below format. My question is: We have data in the database for each bussiness date. In the report the data is shown horizontally…
Feroz
  • 351
  • 1
  • 5
  • 20
1
vote
2 answers

SSRS How to Compare Columns to First Column in Group

I'm trying to create what seems like should be a pretty simple matrix report and I'm hoping someone can help. I have dataset that returns sales region, Date, and sales amount. The requirement is to compare sales for the various time periods to the…
user1630894
1
vote
1 answer

SSRS Switch function to fill background colour

I need to use the SSRS Switch function to fill background colour =switch(Fields!Ref_No.Value="AAA","Green",Fields!Ref_No.Value= not like "AAA","RED" How do I say if first 3 letters not like AAA then fill background Red?
Nite Cat
  • 533
  • 2
  • 8
  • 12
1
vote
1 answer

How to select Top 10 in SSRS using SharePoint List as Data Source

I am trying to build a SSRS report that includes 2 sub reports. Each sub report uses a single data set with a SharePoint List as it's data source. Usually when trying to control the length of SP queries I use the following group by…
Robert Pulido
  • 81
  • 1
  • 8
1
vote
1 answer

To calculate sum of the fields in a matrix with column grouping

I am working on a ssrs report with column grouping. the followin is my scenario. Matrix 1: ID 2012 2013 1 20 40 1 30 50 Total 50 90 Matrix 2: ID 2012 2013 1 60 70 1 60 80 Total 120 150 I need the…
user2395176
  • 195
  • 1
  • 1
  • 11
1
vote
1 answer

SSRS Hide group conditionally

I have SSRS report with 3 groups in Tablix -- Group A ----Group B ------Group C If group C has 0 records then I do not want to show any of Group A, B and C. I tried to set the visibility property for Group A and Group…
TD2013
  • 97
  • 1
  • 3
  • 13
1
vote
1 answer

SSRS rows grouping - front end or back end

On hand is a requirement for a report that needs to perform a substring operation and grouping on the chopped strings in a column. For example, consider my over-simplified scenario: Among others, I have a column called FileName, which may have…
FMFF
  • 1,652
  • 4
  • 32
  • 62
1
vote
1 answer

SSRS matrix with subtotals on rows

I have a matrix with months as the column and the following fields for the rows: rep team customer category The category field has the following: Fct, Act, Var, Cum, Prev I would like to add subtotals for the category row field by each of the…
maverick07281975
  • 53
  • 2
  • 10
1
vote
1 answer

SSRS Show data in horizontal layout

I new to SSRS, need to develop SSRS report to show data in horizontal layout inline as shown below is pix and data, Please guide with your help: ID Type ID 1 Drawings True 2 Shop Drawing False 3 Samples False 4 …
SAM
  • 179
  • 1
  • 3
  • 14
1
vote
0 answers

SSRS to excel export alignment issue of grouping plus icon

I have a multi-level groupings in my SSRS report. When I export the report to excel the expand icon (+) in excel is not aligned correctly. How do I fix this?
superartsy
  • 489
  • 1
  • 11
  • 27
1
vote
2 answers

SSRS format rows on report

I have a simple report that groups rows on PERSON then on DATE. I have these two groups in the grouping pane with the DETAILS GROUP below. The trouble with this is that I end up with PERSON AND DATE appearing at the top of the first 2 columns on…
user1022772
  • 651
  • 3
  • 14
  • 29
1
vote
3 answers

manually Aggregate or Sum data fields in groups in SSRS

I have a Sales Table and a Discounts table. The main dataset is a Sales table has sales per person. Every person is associated under only one project and every project has only one supervisor. The second dataset - discounts table has the discount…
superartsy
  • 489
  • 1
  • 11
  • 27
1 2 3
…
27 28