Hi,

I was wondering, is it possible to group a report by the pages spanned by groups in the report. For example, say the first group spans 1 page (page 1 of 1), second group spans 4 pages (page 1 of 4) etc. I want to group all the items that only have one page together and all the items with more than one page together. Is this possible?

Thanks in advance.

You can get close to it.

For instance, in section expert you can say you want a new page after each group footer. I think that's all it means to be "grouped by pages" really.

You can also "reset page number after" each group footer, so that will further make it appear that you are grouping by pages.

However I don't think you'll be able to determine the total number of pages a group spans and have the same number print on every page in the group, unless you found a clever way to use arrays. I'm thinking something like:

1: whilereadingrecords, on change of group, push the total number of pages into the array. This way you will have an array of "total page numbers" where the first index represents total pages for group 1, second index for group 2, etc.

2: whileprintingrecords, print the corresponding page number into the group footer, where you have a variable that will increment by one on change of group.

I'll see if my theory actually works. I'm actually interested in how much I can squeeze into the three-step passing system.

Edited by Keikoku - 04 Apr 2011 at 4:53am

Hi Keikoku, thanks for your detailed reply. I am not entirely sure you understood what I was trying to acheive though (unless I've misunderstood your post).

I can group by a field and insert a page break after each field. Using the special field "Page N of M" I can easily display the page numbers. What I actually want to do is group items that fit unto one page together and items that span more than one page together. So I can display print off the items with only one page or items which span more than one page.

I've tried a few things. I have gone as far as grouping my a field, inserting a page break, using the "Page N of M" special field. I also created a formula field which basically stores the "total page count" (from the special field). This gives me the page count for each group.

But I have tried to group on using this formula field but it doesn't appear on the section expert (probably because it is a calculated field). Does this make sense?

Thanks.

Hi,

For example: if I have a 100 pages in total, comprised of a 20 items spanning one page (20 x 1), 10 items spanning 5 pages (10 x 5) and 2 items spanning 15 pages (5 x 6).

Basically 10: Page 1 of 1
          20: Page 1 of 5, Page 2 of 5, Page 3 of 5, Page                      4 of 5, Page 5 of 5
          2 : Page 1 of 15, Page 2 of 15, Page 3 of 15... etc

I want the first 10 to follow each other sequentially, and the next 20 to follow sequentially and the next 2 to follow sequentially. I don't want them overlapping. Does that make sense? I want to know the the groups spanning one page are the first 10 items or pages.