Solved

ssrs grouping details header

Posted on 2009-07-13
2
1,025 Views
Last Modified: 2012-05-07
I have ssrs report which  has table and it looks as

Name Address   city     state zip       client/commision
jon   123blvd  memphis   TN   321111   JD Edwards
                                         3000
jon   123blvd  memphis   TN   321111   JD Edwards
                                          5000
jon   123blvd  memphis   TN   321111   JD Edwards
                                           1000
jane  11183high Chattanoga TN  36112    BCBS
                                        800

The name adress are in table header..
and rest are the details I wabt to group this so it should look like


Name Address   city     state zip       client/commision
jon   123blvd  memphis   TN   321111   JD Edwards
                                         3000
                                          5000
                                           1000

jane  11183high Chattanoga TN  36112    BCBS
                                        800



Please help I tried group by in ssrs by name address city state zip and client,but these items also appear   in the next row.. I want these to appear only once..Any help thank you
0
Comment
Question by:Angela4eva
2 Comments
 
LVL 14

Accepted Solution

by:
Emes earned 500 total points
ID: 24840922
group by is jon   123blvd  memphis   TN   321111   JD Edwards

place this in the group HEADER. then add the data that contains the

  3000
                                          5000
                                           1000

into the Detail section of the group
0
 

Expert Comment

by:random141
ID: 24957799
sa
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to increase the row limit in Jasper Server.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question