October 29, 2012 at 1:33 pm
Hi 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
October 29, 2012 at 1:53 pm
Use an expression like:
=CInt(Ceiling(RowNumber(Nothing)/4))
Then put this into a group and set your page break as you wish for that grouping.
HTH,
Rob
October 29, 2012 at 3:19 pm
Thanks 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.
Larry
October 29, 2012 at 3:23 pm
October 30, 2012 at 1:32 pm
Bump...:-D
Beuler...Beuler?
November 29, 2012 at 12:05 pm
Got it...thanks!
Was putting it in the wrong place. 🙂
December 10, 2012 at 12:09 pm
Only 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!
larry
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply