hi, I have created 2 matrix reports.below like this General Matrix report 1: Column Group Row Group Data General Matrix report 2: Column Group Row Group Data in matrix report 1 dragged into column group data then below like this Name Appt Basic DA HRA Null in this report i can put column visibility Expression like this: IIF(Fields!DA_HRA.Value="",true,false) then gap space is coming. In Matrix Report 2 drag the data into Row Group then below like this. Gross Salary Basic+DA but i have created these 2 matrix reports beside to beside in between these 2 matrix reports gap is coming like this: Name APpt Basic DA HRA (Gap Space) Gross Salary Basic+DA i want How to combine these 2 matrix reports like this: Name Appt Basic DA HRA Gross salary Basic+DA please tel me How to do it.Reply Immediately Thank You

Hello Narendra This is the TSQL forum, I am afraid that you may not get much help from us here... please post your question in the SSRS forum.. below link will guide there http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads Nothing is Permanent... even Knowledge.... My Blog

Hi narendrayenni, Thanks for posting your question here. If Matrix1 and Matrix2 uses the same Dataset, Adjacent Group can help us achieve the target, detail steps as below. 1. Right-click the Data textbox of Matrix1, Add Group, Column Group, Adjacent Right. 2. Assuming the field name of the Column Group in Matrix2 is ColumnName, the field name of the Data zone in Matrix2 is DataName. Drag ColumnName into the first row of the new column, drag DataName into the second row of the new column. Hope it helps you. If the issue still exists, please let me know. Thanks, Sharp Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

hi, I have created 2 matrix reports.below like this General Matrix report 1: Column Group Row Group Data General Matrix report 2: Column Group Row Group Data in matrix report 1 dragged into column group data then below like this Name Appt Basic DA HRA Null in this report i can put column visibility Expression like this: IIF(Fields!DA_HRA.Value="",true,false) then gap space is coming. In Matrix Report 2 drag the data into Row Group then below like this. Gross Salary Basic+DA but i have created these 2 matrix reports beside to beside in between these 2 matrix reports gap is coming like this: Name APpt Basic DA HRA (Gap Space) Gross Salary Basic+DA i want How to combine these 2 matrix reports like this: Name Appt Basic DA HRA Gross salary Basic+DA please tel me How to do it.Reply Immediately Thank You