Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Matrix report - a column showing more than once Expand / Collapse
Author
Message
Posted Thursday, August 15, 2013 4:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:25 AM
Points: 74, Visits: 344
Hello
in a matrix report I've got column grouping, in each group there are 4 columns, now one of the columns(date column) I want it to show once but its showing 4 times. I do understand its because on the database its written 5 times , but is there a way to remove or hide away the other dates?


e.g on the database

date | seq | Name | amount

13/01/2013 1 marketing 100
13/01/2013 2 Progr 200
13/01/2013 3 Client 500
13/01/2013 4 Lead 700



Now the output must be

date |marketing | Progr | Client | Lead

13/01/2013 100 200 500 700

but it shows the date like this

date |marketing | date | Progr |date | Client | Lead
13/01/2013 100 13/01/2013 200 13/01/2013 500 700


How can I do this?




some help will be much appreciated.
Regards
Post #1484676
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse