InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 01:57:47 GMT20http://www.sqlservercentral.com/Forums/Topic1378442-391-1.aspxOnly works if I choose one hospital...I'm attaching a dummy table and .rdl file.If you choose "All", then the first hospital will work fine, the second hospital has 3 then 2, the 3rd hospital has the same.Could anyone help? this is the only report still on the 2005 server and we need to close it so we can move everythying to the 2008 server.Frustrating... to say the least.Any help would be great!larryMon, 10 Dec 2012 12:09:01 GMTlazyeye08http://www.sqlservercentral.com/Forums/Topic1378442-391-1.aspxGot it...thanks!Was putting it in the wrong place. :)Thu, 29 Nov 2012 12:05:18 GMTlazyeye08http://www.sqlservercentral.com/Forums/Topic1378442-391-1.aspxBump...:-DBeuler...Beuler?Tue, 30 Oct 2012 13:32:06 GMTlazyeye08http://www.sqlservercentral.com/Forums/Topic1378442-391-1.aspx[URL=http://imageshack.us/photo/my-images/23/pagebreakissue.png/][IMG]http://imageshack.us/a/img23/4232/pagebreakissue.th.png[/IMG][/URL][URL=http://imageshack.us/photo/my-images/542/pagebreakissuegrouping.png/][IMG]http://imageshack.us/a/img542/7069/pagebreakissuegrouping.th.png[/IMG][/URL]Mon, 29 Oct 2012 15:23:06 GMTlazyeye08http://www.sqlservercentral.com/Forums/Topic1378442-391-1.aspxThanks for the quick response!I had tried several of those, but none worked. I'm attaching some screen shots so hopefully that will help you to help me understand.[img]http://imageshack.us/photo/my-images/23/pagebreakissue.png/][img=http://imageshack.us/a/img23/4232/pagebreakissue.th.png][/img][img]http://imageshack.us/photo/my-images/23/pagebreakissue.png/][img=http://imageshack.us/a/img23/4232/pagebreakissue.th.png][/img]LarryMon, 29 Oct 2012 15:19:38 GMTlazyeye08http://www.sqlservercentral.com/Forums/Topic1378442-391-1.aspxUse an expression like:[code="plain"]=CInt(Ceiling(RowNumber(Nothing)/4))[/code]Then put this into a group and set your page break as you wish for that grouping.HTH,RobMon, 29 Oct 2012 13:53:46 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1378442-391-1.aspxHi Everyone,I need to add a page after the 4th Patient in a report.The report has two groups. Organization and patient.Each patient will have 7 detail rows.For the organization group I have the page break set for between each instance and the end. The second group...it will group on each patient but will put only one patient per page. that makes for a lot of pages that are grouped by Organization and then by patient.So how do I put in a page break in after every 4th patient record in the Organization group?Larry Mon, 29 Oct 2012 13:33:38 GMTlazyeye08