Matrix control

Hi all,

I'm using matrix control as my reporting tools.

But i found one trouble, how can i do my matrix become like this.

Product A

Product B

Customer

Price

Qty

Price

Qty

Customer A

10

10

140

160

Customer B

12

120

120

160

Customer C

10

10

110

140

The price and qty is the static column, and i would like to make the static row also. (show in red color) but i can't.

Please help...

Thanks

Kendy

1.

Add matrix contol

2.

in the row add Customer

3. in the columns add Product

4. Right click on Data and select add column

no you will have two column

add price to the left onw and Qty to the right onw

|||

Hi Idanle,

I have create the matrix control, for the qty and price i using static column.

For static row, i have do it also but the result will be like this

Product A

Product B

Price

Qty

Price

Qty

Customer

Customer A

10

10

140

160

Customer

Customer B

12

120

120

160

Customer

Customer C

10

10

110

140

It will repeat because is static row same as static column where repeated showing out the "Price" and "Qty".

How to make the title "customer" only showing as header.

Thanks

Kendy

|||Can you send me the RDL or upload a print screen of youe design mode|||

Hi Idanle,

I have upload the excel file.

Inside the excel file, the tab name "Defect" is the problem i facing, wherelse the tab name "Output" is what i expected.

http://download.yousendit.com/ED0492A72B6C6C66

Thanks

Kendy

|||

I can't found the problem.

Can you send me your table (data source) and the RDL or the matrix definition?

|||

Hi Idanle,

As u can see from the excel file, the tab defect page.

The "Customer" header will always display as a row detail where show in red color.

But when see the output tab, where the result i wanted. The "Customer" header will remain as header, it wouldn't same like defect tab.

My question is can matrix control done as output tab, if yes how the way to do it.

Thanks

Kendy

|||

Hi,

I see the problem and I'ts seams somthing worng with your matrix setting since this problem should not occur.

This is way I ask for thr RDL and table.

If you can just create your data table in excel I will set for you the RDL

|||

Hi Idanle,

I have upload the table, rdlc and expected output i wanted.

http://download.yousendit.com/CA8B3D95276E0341

Thanks for your help.

Regards

Kendy

|||

The table you sent me is not the same table using your Expected output.

What is the problem with the current output ? it's look fine

|||

Hi Idanle,

Actually, when you look at expected output and current output. The only different is header, in expected output there are header where mark in red color wherelse in current output is without the header.

And i have try do it with static row (just try in one column name Customer), the result i get is like this, please download from the link.

http://download.yousendit.com/BC879C5820984C1A

So can i know how to do it become expected output using matrix control provided by sql server reporting services?

Thanks

Kendy

|||For column headers, what you need to do is put a rectangle in the corner cell. In this rectangle, put your Customer label textbox.