Repeate group values in Matrix

Hi,

I am using matrix to make a report. I have company name in the row group and user name in the details field. When I run the report I only see the company name once and each user of that company is displayed in a separate row. Then next company name and its users... I wanted to know if there is a way to display company name next to the user name? I know it can be done by using "table" but I can't use table because in this report there are other fields can only be done in a matrix. So, please let me know if there are any settings in matrix which I can use to display my company name next to each user of that company. Please ask me any thing if the question is not clear. Thanks a lot for the help.

-Rohit

If someone have any idea about this problem please let me know. I would really appreciate that. Thanks.|||

Hi Rohit,

it sounds like you have a row group based on CompanyName, and a nested row group based on UserName. You could do the following steps:

1. Clear out the expression in the matrix header of the company group (which would display the company name) and resize that header to be relatively small
2. Modify the matrix header expression of the user name group to e.g.: =Fields!CompanyName.Value & " - " & Fields!UserName.Value

This should result in the company name being shown for every user name.

-- Robert

|||

Hi Robert,

This sounds like a solution that I had also been looking for but my users want to export to excel and do some things from there. If I merge my two values in that cell won't it create problems for them?

|||Thanks a lot Robert.|||

I figured out how to do it w/o having to concatinate the two into one column. Follow all of the directions that Robert gave us--take expression out of first column and minimize as small as possible. Only put the company name in the second grouping column expression. Then go into view datasets and drag your user id directly after the second column. It will appear in a column by itsself. That way they are still in their own columns and not concatinated-yet you still have the same results.