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
No idea if this will work, but it might give you something to start with. You could try int(count(distinct [Team])/2)
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