Page Break with more then one category values

[raja1718]

Hello All,

I have some requirements with page break and Page Sets. I have 3 levels of groupings and 1. State , 2.Team 3. Category.

I already have a page break for [State] ,but user wants to see the 2 Teams per page if i add the Page Break in page set for team its accepting the 1 Team per page, am not sure how can i do that to display the 2 [Teams] per page. :(

Guys need you help on this ...Thanks in Advance

Raja

 

[BigChris]

No idea if this will work, but it might give you something to start with. You could try int(count(distinct [Team])/2)

[raja1718]

Thanks BigChris !

Formula is good Can you please describe me, How do i connect the Data Item with this formula with Page Break ????

I tried Hard coding by giving common name for each pair of team, I am using Page Break according to that and i am hiding the New Grouping date item on the report, But here is the problem i am facing still. I am not able to display the State wise total.Its repeating every page with State total.Really confusing.

Honestly i don't like to hard code because if any teams come in future then we may need to update the coding again for each and every new Team we add.

Thanks,
Raja