Solved

ssrs grouping details header

Posted on 2009-07-13
2
1,027 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 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