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

Group in SSRS Report

I have some issue in my sales report . I want to make a report like this, in which two columns are there.. Team TotalSales Team A 1000 a1 500 a2 500 Team B 400 Team C 800 Total 2200 here a1 and a2 are sub part of Team A.1000 is sum of a1 and a2…
user3266284
  • 1
  • 1
0
votes
1 answer

SSRS Grouping With Two DataSets

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 on the values returned by Lookup/MultiLookup/LookupSet

I have 2 datasets that come from two different data sources. DataSet1 and DataSet2. This is how DataSet1 looks like: CustomerName City State Zip Cust1 Cust1City Cust1State Cust1Zip Cust2 Cust2City …
Asdfg
  • 11,362
  • 24
  • 98
  • 175
0
votes
1 answer

1 row from DataSet A to many from DataSetB

I'm trying to create a report that display's a document that is in the DB across multiple tables. I have the querys and datasets set up fine, I'm just having issues grouping it right on the report itself. To make it clear I have one Row from…
user2312767
  • 55
  • 6
0
votes
1 answer

SSRS grouping and total sum in tablix

Kindly help me with the following query, i have my a table as below, PID ID Date Value Weight 1 1 01-01-2014 10 0.5 2 1 01-01-2014 20 0.5 3 1 01-01-2014 30 0.5 4 1 …
user3252036
  • 11
  • 2
0
votes
1 answer

How to add page break inside the DETAILS section of SSRS 2008R2 report

I am a newbie in SSRS. I want to create a report using SSRS 2008R2. Please help me. I have sql stored-procedure ready and pulls the data from the sql server database as shown in the sample below: I need to divide this data on SSRS report by…
desi
  • 466
  • 1
  • 4
  • 22
0
votes
1 answer

SSRS Chart. How to plot line to decrease totals by date

I have a chart in SSRS that has dollar totals by date. I would like a line chart that starts with the total dollars and then decreases the total by date until it gets to zero. How can I do that?
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
2 answers

Matrix to show all months of the year

I have a Web Service that I am getting data from (Not mine and I can't change it) The data is in the following format 1 ABC ABC …
AndyReilly
  • 16
  • 3
0
votes
3 answers

Group Footer to behave as Page Footer In SSRS

I'm using SSRS 2008 to create a report. My report is table based, and features nested groups - The overarching group is a 'Cover Sheet' for the Details section of the report. The details section of the report can be variable in length, from under an…
Joeyjojo Shabadoo
  • 1
  • 1
  • 1
0
votes
1 answer

How can I assign a number to each group and a total number of groups on the dataset to display

I have a dataset that is grouped by the CustomerId with multiple row information for each CustomerId. I'm trying to create a numbering for each group (customerId) that gets created sequentially and then a total of groups. So basically I am looking…
user3177949
  • 1
0
votes
1 answer

remove the empty white space in previous expression in ssrs report

What I need is, when comparing the previous record value with current field, if it is true, it must hide the field value, otherwise show the field value. All is working fine... but the empty white space is displayed when the field is hidden. I do…
soundarrajan
  • 149
  • 1
  • 3
  • 13
0
votes
2 answers

SSRS Chart. Displaying data in a different way than the dataset

Perhaps someone can point me an online resourse that can give me hints on how to accomplish the following. Scenario. I have a dataset that returns two columns. NAME and AMOUNT. See chart below. Name----------------------- Amount…
Michigan Man
  • 101
  • 1
  • 3
  • 13
0
votes
1 answer

How to add total in SSRS 2005

How to add total in ssrs report using ssrs 2005 manually without using a wizard? I can do it in ssrs 2008 by simply add total and Additional question: it seems it is hard to group records here in ssrs 2005 i cannot see row groups and column groups.
CMinor
  • 397
  • 1
  • 5
  • 14
0
votes
0 answers

SSRS - reaching outside of a group, using a variable from within the group

I have a dataset that includes details of who is providing certain services. I've been asked to provide a report that splits out how many cases each provider is working on (and the assets involved). So far so good, I've got a report that is…
Zelazny
  • 11
  • 2
0
votes
1 answer

Serial No. for rows of a table in SSRS

I have table with 3 columns . S.NO NAME AGE I need the serial number to be running as 1.1 1.2 1.3 ... etc (Till the rows end) Is this possible .?
user1699025
  • 61
  • 2
  • 7
  • 13
1 2 3
…
27 28