Solved

ssrs grouping details header

Posted on 2009-07-13
2
1,029 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
How to increase the row limit in Jasper Server.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

628 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