I need to create a report in statement format (e.g. bank statement). The report would look like the following. Question 1: how can I do page break based on company name? Question 2: How should I show the company name on the statement? For now, I have it in a text box with the expression of First(Fields!Company.Value, "Dataset"). Obviously, it is incorrect because it would only show the same company for every statement. Any idea on how I can show the correct company associated with its statement? thx, Mitch --------------------------------------------------------------------------------------------- Company Name 1 Address, City, State and Zip Transaction Transaction Date Transaction Amount txn 1 txn 1 date txn 2 amount txn 2 txn 2 date txn 2 amount Page 1 of 1 --------------------------------------------------------------------------------------------- Company Name 2 Address, City, State and Zip Transaction Transaction Date Transaction Amount txn 1 txn 1 date txn 2 amount txn 2 txn 2 date txn 2 amount Page 1 of 2 Transaction Transaction Date Transaction Amount txn 3 txn 3 date txn 3 amount txn 4 txn 4 date txn 4 amount Page 2 of 2 Mitch Cheung

Hi Mitch, You can ask SSRS question into "SQL Server Reporting Service" forum to get answers quickly. You can perform below setps, this will take care both of your problem.. 1) Drag a list into report design surface 2) Delete a details group from the list 3) Add a group over CustomreCode ( CustomerName will also work, but there will be an ambiguty in case of same name) 4) In group properties, go to page break tab, select "between each instance of group" 5) Drag a table control into List 6) In table control map columns ( Transaction, date and amount) 7) Drag a textbox into list control and put on top of tablix and put column Customer Name 8) Darg next three textbox and put it between table and customer textbox and map it to fields Kindly revert if you need any information.- Chintak (My Blog)

Hi Mitch, You can ask SSRS question into "SQL Server Reporting Service" forum to get answers quickly. You can perform below setps, this will take care both of your problem.. 1) Drag a list into report design surface 2) Delete a details group from the list 3) Add a group over CustomreCode ( CustomerName will also work, but there will be an ambiguty in case of same name) 4) In group properties, go to page break tab, select "between each instance of group" 5) Drag a table control into List 6) In table control map columns ( Transaction, date and amount) 7) Drag a textbox into list control and put on top of tablix and put column Customer Name 8) Darg next three textbox and put it between table and customer textbox and map it to fields Kindly revert if you need any information.- Chintak (My Blog)

Great, this helps a lot. Just another quick question, how can I make the page # appear in the footer but then page break as part of the list? thx, MitchMitch Cheung

Hi, Have a look at below link to see how to add PageNumber.. http://technet.microsoft.com/en-us/library/dd239335(v=sql.105) Not completely understood your question, but looks like you do not want page break between each company name. For this just undo the set 3 from above. Please revert if this is not the same you want.- Chintak (My Blog)

Hi, If you are using SQL server 2008 R2, you can do this as suggested below http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx- Chintak (My Blog)

My apologies. Let me rephrase my question. If you look at my orginal post, Company Name 1 has two txns with page 1 of 1 in the footer. Company Name 2 has four txns with page 1 of 2 and page 2 of 2 in the footer. This is the page numbering I was looking for. Hope you can shed some light. thx, Mitch P.S. the link from your last post does not work.Mitch Cheung

Hi, If you are using SQL server 2008 R2, you can do this as suggested below http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx- Chintak (My Blog)

Awesome. It works. Thanks so much! MitchMitch Cheung