Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1031
  • Last Modified:

ssrs grouping details header

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
Angela4eva
Asked:
Angela4eva
1 Solution
 
EmesCommented:
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
 
random141Commented:
sa
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now