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
0
votes
1 answer

SQL Reporting services-Master Detail report. Need to have header outside of detail report

I need to make a change to one of the report as explained below. The current report is I have used tablix in the report with PONumber as the group. Each PO can have one or more items. Now the change required is the PO number needs to be shown above…
Anirudh
  • 581
  • 5
  • 14
  • 32
0
votes
1 answer

Grouping multiple row and display at bottom

I have created a SSRS report, few record in my report as below: ID | Currency | Amount ---------------------- 1 | USD | 100.00 2 | USD | 80.00 3 | USD | 110.00 4 | EUR | 30.00 5 | EUR | 50.00 I can group the Amount…
Howard Hee
  • 909
  • 1
  • 13
  • 29
0
votes
1 answer

SSRS Report /SubReport / Multipe Tables or Datasets in Single Report

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
0
votes
1 answer

How to group column header based on multiple condition in SSRS matrix report?

I am using SSRS Reporting service for report generation as a part of my project. I am using matrix report format. I have to Group the column headers, the problem I'm facing now is that I need to group column based on two conditions (not two separate…
Samuel
  • 263
  • 3
  • 6
  • 17
0
votes
0 answers

Custom Page Break in SSRS

I have a matrix report with several columns. I am trying to limit number of rows displayed on each page by inserting a page break. Since it has row groups all the data is growing vertically down on one page. Is there a way where I can control the…
swathi
  • 346
  • 4
  • 9
0
votes
1 answer

ssrs 2012 report export to excel and be able to sort output data

In a new sql server report 2012 (ssrs 2012), I have a dashboard report where users export various pages to excel. The users want to be able to sort the data on their excel spreadsheets. However they are getting an error message about merged…
user1816979
  • 511
  • 4
  • 13
  • 25
0
votes
1 answer

Add each row in a single cell

I have a requirement in ssrs report for display data like this. I have to show 2 two rows data in one row in ssrs as shown below. Row count is unknown. Please check another example. Max two cell in one row in ssrs. I have to do this dynamically…
user1387147
  • 945
  • 4
  • 17
  • 32
0
votes
1 answer

ssrs 2008 export to cell and obtain merge cell error

I have an SSRS 2008 R2 report, where I have users that want to export the reports to excel. They are able to export the reports to excel, and they want to be able to sort the data in excel. However they are getting an error message that says there…
user1816979
  • 511
  • 4
  • 13
  • 25
0
votes
1 answer

SSRS R2 Combining two reports with alternating worksheet result

I'm trying to combine two different reports (with totally different datasources) where in the result would be to create an alternating excel worksheets via R2 pagebreaks like "Daily SS", "MTD SS", "Daily RR", "MTD RR", "Daily LL", "MTD LL"... First…
user2932155
  • 1
0
votes
0 answers

IIF expression for Count for division

I am trying to write an expression of Count Division based on price as shown in figure I am doing group column on Division but how can I get exact no. of count in Count Division Column those having price in their division. I wrote this expression…
mike juies
  • 15
  • 4
0
votes
0 answers

Rendering image field in SSRS to fill the page

I have an SSRS report that renders image field and description. When I execute the report, the data will be rendered as two columns, description and image, but I need to view more than one image column per page, i.e. I need it to be as: image1 …
Ayham Mhd
  • 13
  • 1
  • 6
0
votes
1 answer

SSRS Tablix Row Group

I have a tablix and hierarchical grouping in the tablix. For example: Gender------%count Female------ 10 Male ------- 0 My query returns all records with Female since there are no records with Male it returns nothing For Male. In the…
TD2013
  • 97
  • 1
  • 3
  • 13
0
votes
1 answer

SSRS images/ texboxes in rectangles don't display

I'm creating a simple report in SSRS 2008. I started with copying an existing report definition and modified it to fit my needs. I'm working in Visual Studio Ultimate 2012, in C# on an ASP.NET MVC project. I have two rectangles, Rectangle1 and…
kozmi
  • 25
  • 2
  • 8
0
votes
1 answer

hide column if not in current group

Store Number Store Zone In my report query, each Store Number is assigned a Store Zone. I have grouped rows by Store Zone and columns by Store Number. The report displays the columns for Store Numbers that are not in the Store Zone group. There…
devlin carnate
  • 8,309
  • 7
  • 48
  • 82
0
votes
1 answer

SSRS parameter issue for checking multiple condition

I am passing a date parameter and in SSRS Dataset Filters I am filtering the tasks whose created date is below the parameter passed date =cdate(Fields!WI_CreatedDate.Value) >= = (Parameters!SinceDate.Value) If I want to check the condition for…
usr021986
  • 3,421
  • 14
  • 53
  • 64
1 2 3
…
27 28