SSRS 2008 R2 page break after every 4th person in group

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSRS 2008 R2 page break after every 4th...

SSRS 2008 R2 page break after every 4th person in group

Rate Topic

Display Mode

Topic Options

Author

Message

lazyeye08

Posted Monday, October 29, 2012 1:33 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 2:03 PM
Points: 7, Visits: 59

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

Post #1378442

robert.gerald.taylor

Posted Monday, October 29, 2012 1:53 PM

Right there with Babe

Group: General Forum Members
Last Login: Monday, June 17, 2013 6:44 AM
Points: 759, Visits: 802

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

Post #1378447

lazyeye08

Posted Monday, October 29, 2012 3:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 2:03 PM
Points: 7, Visits: 59

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

Post #1378483

lazyeye08

Posted Monday, October 29, 2012 3:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 2:03 PM
Points: 7, Visits: 59

Post #1378484

lazyeye08

Posted Tuesday, October 30, 2012 1:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 2:03 PM
Points: 7, Visits: 59

Bump...

Beuler...Beuler?

Post #1378994

lazyeye08

Posted Thursday, November 29, 2012 12:05 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 2:03 PM
Points: 7, Visits: 59

Got it...thanks!

Was putting it in the wrong place. :)

Post #1390761

lazyeye08

Posted Monday, December 10, 2012 12:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2012 2:03 PM
Points: 7, Visits: 59

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

Post Attachments

TestGrouping.zip (8 views, 2.65 KB)

Post #1394742

« Prev Topic | Next Topic »

Permissions