Hi All, Right now my matrix report displays like this.. column_A column_B column_C 111234 200 1 111236 400 2 111294 250 1 111316 450 2 111432 100 3 I need to break this into multiple pages like this.. Page 1 - shud have column_c value only 1 column_A column_B column_C 111234 200 1 111294 250 1 Page 2 - shud have column_c value only 2 column_A column_B column_C 111236 400 2 111316 450 2 page 3 - shud have column_c value only 3 column_A column_B column_C 111432 100 3 How to acheive this using ssrs 2008 r2, please its very urgent. Give me some ideas on this Thanks, RHsql

Hi, You could add a group for Column C, and then add a page break between each instance of the group in Group Properties: Zach Stagers - http://www.scratchbox.co.uk Remember to Mark as Answer and Vote as Helpful

Already I did grouping on Column_A..I'm not sure whether I can do grouping again on column_C...Any ideas. Thanks, RHsql

Hi Sql9, From your description, you want to add page break to the report so that only one member is displayed in column_C on each page. To achieve your requirement, you can add a list to your report. A list data region repeats with each group or row in the report dataset. I assume the name of the field placed in the column_C is column_C, the steps below are for your reference: From the Toolbox window, drag the list control onto the design surface below the matrix.Right-click on the handle of the list, select "Tablix Properties". In the Dataset name drop-down list, select the corresponding dataset, click OK.In the Row Groups pane, right-click on Details and select "Group Properties". Click Add, and select [column_C] in the Group On drop down list.Click the "Page Breaks" tab, select Between each instance of a group check box, click OK.Drag the matrix to the list. The report looks like below: For more information about List, please see: http://msdn.microsoft.com/en-us/library/ms159121(v=sql.100).aspx If this is an urgent issue, you could contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you in a more efficient manner. Please understand that contacting phone support will be a charged call, but it will be free if this is a product issue. To obtain the phone numbers for specific technology request please take a look at the web site listed below: http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS If you have any questions, please feel free to ask. Regards, Charlie Liao

Thanks Charlie, I got the solution from your explaination. Thanks, RH sql