Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2008 R2 page break after every 4th person in group Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 1:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, October 29, 2012 1:53 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:47 PM
Points: 1,163, Visits: 1,187
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
Posted Monday, October 29, 2012 3:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, October 29, 2012 3:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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


Post #1378484
Posted Tuesday, October 30, 2012 1:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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

Beuler...Beuler?
Post #1378994
Posted Thursday, November 29, 2012 12:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, December 10, 2012 12:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 (10 views, 2.65 KB)
Post #1394742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse