SSRS Displaying Records

  • I am generating a report which has 9 fields to be displayed. I am trying to group the records. Out of 9 fields first five will have same data, only remaining four changes. I want to display one line of first 5 fields and then remaining four. for example:

    1 2 3 4 5 a b c d

    d r f g

    d g g w

    2 3 4 5 6 a g d g

    a d f g

    Any body has any suggestion??

  • just checkin whether i got the quetion rite..

    1 2 3 4 5

    a b c d

    d r f g

    d g g w

    2 3 4 5 6

    a g d g

    a d f g

    do u want something of the above format? it is very much possible. just reply back to the threAD if my understanding is correct n then i will paste the solution

    (i am assuming the input lines are

    1 2 3 4 5 a b c d

    1 2 3 4 5 d r f g

    1 2 3 4 5 d g g w

    2 3 4 5 6 a g d g

    2 3 4 5 6 a d f g )

  • yes this is the exact input. i m sorry it was mismatched earlier. The output should have only one row for common fields..

    thanx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply