Hi for allI appreciate all of the activities performedon this active forum as I benefit alot from it but I have the following two questions about Matrix control and any helpreally appreciated I have a Matrix control like this one Fixed Col 1 Fixed Col 2 Month 1 Month 2 Month n Group1 Group2 Total and what I need simply is to split the whole (Total) row - which is generated automatically byright-click and select sub-total-into two diferent values according to specific creteria from my DataSet, How can I do this??? The second question is about hiding specific column group accoding to specfific parameterI tried alot with the textbox visibility and the group visibility but at the end it really disappears but the Matrix control does not merge and e.g. Group2 space is left empty with white background.How can I hide it??Thanks in advanceMohamed Window7_Is_MyLove

You might want to take a look at this related discussion thread:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7b1ebaef-b1a2-4bd4-9896-47c2b2a6fc9fRobert Bruckner; http://blogs.msdn.com/robertbruckner; This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Robert BrucknerFirst of all thank you alot for your active response and your reply, the posts are really usefulbut Please I need you to share with me my actual problem,your idea of two text boxes in the subtotal cell is very coooooool rightbut, I need to split the Total Cell in the left bottom corner HORIZONTALLY ok and I will put two textboxes in the subtotal cellon top of each other also HORIZONTALLY and I will show them at the last cell, Is this right ? all of this sure in RS 2005I haveone main problem with the Report Designer now:When I make a group and set its initial visibility to be hidden, the Matrix is rendered without merging this empty space for the unvisible group?? Why this happens ?? andI try to set the visiblity of the textbox of the added group to be hidden nothing happens also ?How I can put a group use itbut make it unvisible and the matrix rendered correctly ??Thanks Robert for reading MohamedWindows7_Is_MyLove

Hi Mohamed, In a matrix, it is unlikely to remove any placeholders when hiding the column. To work around the issue, Id like to suggest you a couple of solutions: Solution1: You could create two matrixes. One is with two row header columns and the other is only with one row header column. You need two kinds of reports, so you have to create two matrixesshownor hidden according to parameters. Try the following settings for the two matrixes: Matirx One: Hidden:iif(parameters!parameter.value=true,false,true) Matrix Two: Hidden:iif(parameters!parameter.value=false,false,true) Solution2: Create three Data Regions Textbox, Matrix, List. Matrix1 without any row group (set the smallest size of row), one list includes your matrix2 and some textboxes, using matrix2 as detail and row group, using Textbox as group header or Subtotal. This is good for controlling the visibility of items and details by toggled or parameter. However you need to pay more efforts. This will require more effort and time, here is a similar thread for reference: http://social.technet.microsoft.com/forums/en-US/sqlreportingservices/thread/d38995a3-e2c1-4c0d-b6c3-f54bed60c23f Hope this helps, Raymond

Hi Raymond-Lee Thanks alot for your kindly reply I really appreciate this Please I neeeeeeeeeed your help with my report , I really need your help My company still work on SSRS 2005 and still not upgraded to 2008 :( , which contains I think the solutions for all of my problems and manay people problems really appreciate RS 2008 and RS team effort regarding my report, I successfully work around my problems and put two text boxes in the Data region in the matrix and show and hide them conditionally very cooool only one appears in the cell and the two text boxes appears at the subtotal really coool. in myreport there are two columns(row groups -in the matrix- ) that need to be shown and hidden according to parameters values the matrix behaves very differently and strangely, one time leave blank space in place of the second column and another time hide two columns after thinking very long and researching alot, I decide to put three matrices and show or hide any one of them completely conditionally, but how I can prevent this matrix from being processed according to specific parameter to improve report performance ?? I really appreciate any help or any guidelines this will be very valuable in my current project Thanks alot MohamedWindows7_Is_MyLove

Hi Mohamed, If you are using the same dataset on all 3 matrices then use case statements in your sql query and execute it only when the condition is satisfied. Let me know if it helps you. Reagards, Bharath