Solved

ssrs grouping details header

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS cant open report builder - authentication error 13 923
SSRS keeping tablix together 13 404
CRM 2011 User, email and phone number for SSRS 4 71
Montis monitoring 3 34
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 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