Hi Joy
Thank you for your feed back.
Yes, I used the expression "=Int((RunningValue(Fields!Category.Value,CountDistinct, "T1")-1)/10)" in the parent group of Category group. I created group G1 for Category grouping (and set visible row only Category row example Category A, Category B - and hide Item rows example Item 001, Item 002, and so on). And then I created parent group G2 containing the expression "=Int((RunningValue(Fields!Category.Value,CountDistinct, "T1")-1)/10)" to limit one page should contain 10 category rows maximum.
In first page number, I want maximum 10 rows printed (Category A until Category J) - Not 10 rows of Item (because Item is hidden already).
Category A Qty 20 Category row 1
Category B Qty 30 Category row 2
Category C Qty 20 Category row 3
Category D Qty 30 Category row 4
Category E Qty 20 Category row 5
Category F Qty 30 Category row 6
Category G Qty 20 Category row 7
Category H Qty 30 Category row 8
Category I Qty 20 Category row 9
Category J Qty 30 Category row 10
In second page number and next page number, I want other category printed with maximum 10 Category rows (not 10 Item rows).
Category K Qty 20 Category row 11
Category L Qty 30 Category row 12
Category M Qty 20 Category row 13
Category N Qty 30 Category row 14
Category O Qty 20 Category row 15
Category P Qty 30 Category row 16
If I use "RowNumber" function in G2 group expression, I cannot control 10 rows of Category rows as above. Because RowNumber count by Record 1, Record 2 and so on - or as my previous post example (Item 001, Item 002, and so on). Row number does not count by Category (Group G1).
Record 1 Item 001 Qty 10 Category A ==>> RowNumber function return 1 ==>> I want for Group G2 expression to return 1
Record 2 Item 002 Qty 10 Category A ==>> RowNumber function return 2 ==>> I want for Group G2 expression to return 1
Record 3 Item 003 Qty 10 Category B ==>> RowNumber function return 3 ==>> I want for Group G2 expression to return 2
Record 4 Item 004 Qty 10 Category B ==>> Row Number function return 4 ==>> I want for Group G2 expression to return 2
Record 5 Item 005 Qty 10 Category B ==>> Row Number function return 5 ==>> I want for Group G2 expression to return 2
And so on...
Because my final report hides Item 001, Item 002 and only display visible row of Category A (line 1), Category B (line 2), and so on. So I need to control maximum rows per page by Category, not by Item. And I cannot use RowNumber function in Group G2.
I hope you can get what I expected.
Thank you.