Add Matrix Columns - SSRS

hello there,

please have a look at the snapshot.i want to be able to add some of the columns together.i mean combine them into one.for example column Problem and Out of Service column i want to add their values together and have them under one column.please help i need this badly.

http://good-times.webshots.com/album/560907322SMsknK

cheers
zolf
zolfAsked:
Who is Participating?
 
Jai STech ArchCommented:
the option is
"group heading should remain visible while scrolling"
when you right click on a group you will get edit group and you will see this option
0
 
Jai STech ArchCommented:
in the datasource that you are assigning, is it possible to club these two columns ?

assuming that you are using column group i think that can be done...
0
 
zolfAuthor Commented:

what do you mean.

in the matrix column i put dbo.Bookht_Portal_State.ENG_NAME
in the matrix row i use grouping like this dbo.Bookht_Terminal_Ports_Snapshot.date  - then dbo.City.City - then dbo.bookht_TelCenter.Name
and in the matrix data i put the dbo.Bookht_Terminal_Ports_Snapshot.cnt

my query is like this.

SELECT     dbo.Bookht_Terminal_Ports_Snapshot.cnt, dbo.Bookht_Portal_State.ENG_NAME, dbo.City.City, dbo.bookht_TelCenter.Name,
                      dbo.Bookht_Terminal_Ports_Snapshot.date
FROM         dbo.Bookht_Terminal_Ports_Snapshot INNER JOIN
                      dbo.Bookht_Portal_State ON dbo.Bookht_Terminal_Ports_Snapshot.STATE_ID = dbo.Bookht_Portal_State.STATE_ID INNER JOIN
                      dbo.bookht_TelCenter ON dbo.Bookht_Terminal_Ports_Snapshot.TelCenterID = dbo.bookht_TelCenter.pkid INNER JOIN
                      dbo.City ON dbo.Bookht_Terminal_Ports_Snapshot.CityID = dbo.City.pkid
WHERE     (dbo.Bookht_Terminal_Ports_Snapshot.date BETWEEN @startdate AND @enddate)
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Jai STech ArchCommented:
change you query like
(assuming that ENG_NAME is having the DESCRTION "Problem" Outofservice etc)

if it is someother field let me know which field holds that value

SELECT     dbo.Bookht_Terminal_Ports_Snapshot.cnt, case when dbo.Bookht_Portal_State.ENG_NAME = 'Out Of Service' then 'Problem' else dbo.Bookht_Portal_State.ENG_NAME end as ENG_NAME, dbo.City.City, dbo.bookht_TelCenter.Name,
                      dbo.Bookht_Terminal_Ports_Snapshot.date
FROM         dbo.Bookht_Terminal_Ports_Snapshot INNER JOIN
                      dbo.Bookht_Portal_State ON dbo.Bookht_Terminal_Ports_Snapshot.STATE_ID = dbo.Bookht_Portal_State.STATE_ID INNER JOIN
                      dbo.bookht_TelCenter ON dbo.Bookht_Terminal_Ports_Snapshot.TelCenterID = dbo.bookht_TelCenter.pkid INNER JOIN
                      dbo.City ON dbo.Bookht_Terminal_Ports_Snapshot.CityID = dbo.City.pkid
WHERE     (dbo.Bookht_Terminal_Ports_Snapshot.date BETWEEN @startdate AND @enddate)
0
 
zolfAuthor Commented:

thanks mate that worked by manipulating the sql server.can i do this directly in the Visual studio.

Also I want to know how can i show the column header when i scroll down the page.this feature we have in table.but i dont see this in matrix.how can i do this.please help.

thanks once again mate.
0
 
Jai STech ArchCommented:
right click on the group --> Edit group -> there is an option(checkbox) which will say display column header while scrolling or something like that...check that out
0
 
zolfAuthor Commented:


thanks mate.your help was very helpful.I appreciate your help and time.

cheers
zolf
0
 
Jai STech ArchCommented:
glad that iam helpful...:-))cheers
0
 
zolfAuthor Commented:

jaiganeshsrinivasan

i have modifed your query to combine more columns.is it possible to change their headings


SELECT     dbo.Bookht_Terminal_Ports_Snapshot.cnt, CASE WHEN dbo.Bookht_Portal_State.ENG_NAME = 'Out Of Service' THEN 'Problem'
WHEN dbo.Bookht_Portal_State.ENG_NAME = 'Under Construction' THEN 'Active User'
WHEN dbo.Bookht_Portal_State.ENG_NAME = 'Bucht Released' THEN 'Ready To Use'
ELSE dbo.Bookht_Portal_State.ENG_NAME end as ENG_NAME, dbo.City.City, dbo.bookht_TelCenter.Name,
                      dbo.Bookht_Terminal_Ports_Snapshot.date
FROM         dbo.Bookht_Terminal_Ports_Snapshot INNER JOIN
                      dbo.Bookht_Portal_State ON dbo.Bookht_Terminal_Ports_Snapshot.STATE_ID = dbo.Bookht_Portal_State.STATE_ID INNER JOIN
                      dbo.bookht_TelCenter ON dbo.Bookht_Terminal_Ports_Snapshot.TelCenterID = dbo.bookht_TelCenter.pkid INNER JOIN
                      dbo.City ON dbo.Bookht_Terminal_Ports_Snapshot.CityID = dbo.City.pkid
WHERE     (dbo.Bookht_Terminal_Ports_Snapshot.date BETWEEN @startdate AND @enddate)
0
 
Jai STech ArchCommented:
in the query ? or in your report ? if in your report what do you want to change to ?
0
 
zolfAuthor Commented:

in my report i want to see User instead of active user in the Column header
0
 
Jai STech ArchCommented:
use this.....

SELECT     dbo.Bookht_Terminal_Ports_Snapshot.cnt,
CASE WHEN dbo.Bookht_Portal_State.ENG_NAME = 'Out Of Service' THEN 'Problem'
WHEN dbo.Bookht_Portal_State.ENG_NAME = 'Under Construction' THEN 'User'
WHEN dbo.Bookht_Portal_State.ENG_NAME = 'Bucht Released' THEN 'Ready To Use',
WHEN dbo.Bookht_Portal_State.ENG_NAME = 'Active User'  THEN 'User'
ELSE dbo.Bookht_Portal_State.ENG_NAME end as ENG_NAME, dbo.City.City, dbo.bookht_TelCenter.Name,
                      dbo.Bookht_Terminal_Ports_Snapshot.date
FROM         dbo.Bookht_Terminal_Ports_Snapshot INNER JOIN
                      dbo.Bookht_Portal_State ON dbo.Bookht_Terminal_Ports_Snapshot.STATE_ID = dbo.Bookht_Portal_State.STATE_ID INNER JOIN
                      dbo.bookht_TelCenter ON dbo.Bookht_Terminal_Ports_Snapshot.TelCenterID = dbo.bookht_TelCenter.pkid INNER JOIN
                      dbo.City ON dbo.Bookht_Terminal_Ports_Snapshot.CityID = dbo.City.pkid
WHERE     (dbo.Bookht_Terminal_Ports_Snapshot.date BETWEEN @startdate AND @enddate)
0
 
zolfAuthor Commented:

thanks mate.
0
 
Jai STech ArchCommented:
cheers...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.