Page numbering

[John Valean Baily]

Hi listers,

I have a license document, of which the text is too long to fit on one  
layout. Also, the user wants to be able to print out various parts of  
the license, necessitating 6 layouts with the appropriate text on each  
layout.

Five of the layouts come from the parent file, the final layout comes  
from a child (line) file layout, but actually prints # 3 in the  
sequence.

This third layout (because it's a line files) is the only variable  
length document and may be one, two or more pages long, the remaining  
files are all fixed length.

I can figure out the total number of pages for the print job page. I  
can start the numbering sequence 1 of 21 etc, I can figure how to  
number correctly the page start numbers on the first three layouts -  
it's the subsequent page numbers on layout three which is the problem,  
I cannot figure how to enumerate page two or three on the 3rd layout,  
and then correctly number the remaining three pages on layouts 4, 5 &  
6, so that they number Page n of 21 etc.

Any thoughts ?

--
Regards

John Valean (Val) Baily

FileMaker Pro Database Development.
FileMaker Business Alliance & TechNet
SyncDek Developers Alliance

http://www.electronic-type.com
Tel: [phone]
Cel: [phone]

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Darren Terry-3]

On Aug 22, 2008, at 2:12 PM, John Valean Baily wrote:

> I have a license document, of which the text is too long to fit on  
> one layout. Also, the user wants to be able to print out various  
> parts of the license, necessitating 6 layouts with the appropriate  
> text on each layout.
>
> Five of the layouts come from the parent file, the final layout  
> comes from a child (line) file layout, but actually prints # 3 in  
> the sequence.
>
> This third layout (because it's a line files) is the only variable  
> length document and may be one, two or more pages long, the  
> remaining files are all fixed length.
>
> I can figure out the total number of pages for the print job page.  
> I can start the numbering sequence 1 of 21 etc, I can figure how to  
> number correctly the page start numbers on the first three layouts  
> - it's the subsequent page numbers on layout three which is the  
> problem, I cannot figure how to enumerate page two or three on the  
> 3rd layout, and then correctly number the remaining three pages on  
> layouts 4, 5 & 6, so that they number Page n of 21 etc.
>
> Any thoughts ?

Hi John:

GTRR to the line table, in a new window.  Enter Preview mode and Go  
to Record/Request/Page (Last).  Set $n to Get ( PageNumber ).  This  
is the number of pages of #3 in the sequence.

Now set $n to $n + 3, and that's your starting page number for #4 in  
the sequence.

regards,
Darren

******************************
  Darren Terry                               darren_terry@...
  Pacific Data Management, Inc.              http://www.pdm-inc.com/
  111 W. St. John St.                      Phone: [phone] x303
  Suite 404                                  Fax:   [phone]
  San Jose, CA 95113
***** FileMaker 9 Certified Developer *****



_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[John Valean Baily]

On 22-Aug-08, at 5:34 PM, Darren Terry wrote:

> Now set $n to $n + 3, and that's your starting page number for #4 in  
> the sequence.

Yes, of course, thank you Darren

--
Regards

John Valean (Val) Baily

FileMaker Pro Database Development.
FileMaker Business Alliance & TechNet
SyncDek Developers Alliance

http://www.electronic-type.com
Tel: [phone]
Cel: [phone]

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[John Valean Baily]

Hi Darren,

On 22-Aug-08, at 5:34 PM, Darren Terry wrote:

> GTRR to the line table, in a new window.  Enter Preview mode and Go  
> to Record/Request/Page (Last).  Set $n to Get ( PageNumber ).  This  
> is the number of pages of #3 in the sequence.
>
> Now set $n to $n + 3, and that's your starting page number for #4 in  
> the sequence.

After re-reading the above, I realised I had already got to that stage  
(figuring out the length of the varying page lengths) for layout three  
and subsequent layouts and their page numbers.

What I'm then trying to do is set the first page of layout three to  
the sequential start, (taking into account that the first two layouts,  
were page numbered 1 and 2 - 7 (that bit I figured)  What I need to  
then do is set the start page # (on layout 3) as 8 , 9 and 10  
(assuming there are three pages to this layout).

How do I start layout 3 at the number 8... and then number pages 9 and  
10 accordingly (within that layout)...

also

Looking at m.rauch@..., calc's solution, of Get (PageNumber)  
+ 2 will - using my page sequences of in fact Get (PageNumber) + 8  
start the layout 3 sequence with the correct number... but how does  
the numbering sequence continue for the 2nd and 3rd pages in layout 3.  
The number of pages on layout is a summary and the page numbers will  
vary and I can' figure how to insure the correct number sequence ?

I suspect I need a Get(StartPageNumber) calculation... ;)

Thanks for your help.

--
Regards

John Valean (Val) Baily

FileMaker Pro Database Development.
FileMaker Business Alliance & TechNet
SyncDek Developers Alliance

http://www.electronic-type.com
Tel: [phone]
Cel: [phone]

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Winfried Huslik]

John, Darren,

There is no reasonable solution to the problem, because you would  
have to modify the Print settings for FileMaker Pro at "Number pages  
from: $x", but you can't use a variable here, only fix numbers.

One approach would be to define say 10 different Print steps, each  
starting at a different page number, but this would fail if you have  
more preceding pages than are predefined.

In FileMaker 6 times I used a Preview Copy (without page numbers) to  
be put into a different table with a container field, one page per  
record, and do the Printing and page numbering there. This might be  
viable in FM 9 on a Mac, but I doubt it would look as good on Windows.


My personal solution would be to split those pages in two sections  
and use a numbering like
1 - 1 or A 1
1 - 2 or A 2
2 - 1 or B 1
2 - 2 or B 2
2 - 3 or B 3
2 - 4 or B 4


Winfried

FMDiff is currently featured on the FileMaker web site
at <http://developer.filemaker.com/solutions/>



On 24.08.2008, at 01:48, John Valean Baily wrote:

> Hi Darren,
>
> On 22-Aug-08, at 5:34 PM, Darren Terry wrote:
>
>> GTRR to the line table, in a new window.  Enter Preview mode and  
>> Go to Record/Request/Page (Last).  Set $n to Get ( PageNumber ).  
>> This is the number of pages of #3 in the sequence.
>>
>> Now set $n to $n + 3, and that's your starting page number for #4  
>> in the sequence.
>
> After re-reading the above, I realised I had already got to that  
> stage (figuring out the length of the varying page lengths) for  
> layout three and subsequent layouts and their page numbers.
>
> What I'm then trying to do is set the first page of layout three to  
> the sequential start, (taking into account that the first two  
> layouts, were page numbered 1 and 2 - 7 (that bit I figured)  What  
> I need to then do is set the start page # (on layout 3) as 8 , 9  
> and 10 (assuming there are three pages to this layout).
>
> How do I start layout 3 at the number 8... and then number pages 9  
> and 10 accordingly (within that layout)...
>
> also
>
> Looking at m.rauch@..., calc's solution, of Get  
> (PageNumber) + 2 will - using my page sequences of in fact Get  
> (PageNumber) + 8 start the layout 3 sequence with the correct  
> number... but how does the numbering sequence continue for the 2nd  
> and 3rd pages in layout 3. The number of pages on layout is a  
> summary and the page numbers will vary and I can' figure how to  
> insure the correct number sequence ?
>
> I suspect I need a Get(StartPageNumber) calculation... ;)
>
> Thanks for your help.
>
> --
> Regards
>
> John Valean (Val) Baily

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[John Valean Baily]

Hi Winfried,

On 24-Aug-08, at 10:52 AM, Winfried Huslik wrote:

> There is no reasonable solution to the problem, because you would  
> have to modify the Print settings for FileMaker Pro at "Number pages  
> from: $x", but you can't use a variable here, only fix numbers.

I hope you're wrong, but I don't think you are  ;(

I came to the same conclusion last night...

--
Regards

John Valean (Val) Baily

FileMaker Pro Database Development.
FileMaker Business Alliance & TechNet
SyncDek Developers Alliance

http://www.electronic-type.com
Tel: [phone]
Cel: [phone]

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Winfried Huslik]

John,

Please see my post on TechNet for a better solution.


Winfried



On 24.08.2008, at 17:37, John Valean Baily wrote:

> Hi Winfried,
>
> On 24-Aug-08, at 10:52 AM, Winfried Huslik wrote:
>
>> There is no reasonable solution to the problem, because you would  
>> have to modify the Print settings for FileMaker Pro at "Number  
>> pages from: $x", but you can't use a variable here, only fix numbers.
>
> I hope you're wrong, but I don't think you are  ;(
>
> I came to the same conclusion last night...
>
> --
> Regards
>
> John Valean (Val) Baily

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Hgumbert]

Alex Brophy and I solved this problem just this week. The solution  
involved these items...

Create a field:
- We created a global variable, something like $$ReportBasePageNumber  
and then created a calculated unstored field in the table that we are  
printing from called zzReportPage = Get ( PageNumber ) + $
$ReportBasePageNumber - 1. If you are printing from several tables,  
you need this on each table as it will be used to print the page  
numbers.
- In the table that we are printing from we added the field  
zzReportPage to the layout on the right and left sides. We used  
conditional formatting to make the page number white so the page  
numbers would show on the left or right appropriately.

In the report script you:
- Start off by initializing $$ReportBasePageNumber to 1.
- Setup the first portion of the print job, go to Preview Mode. The  
page numbers should be correct.
- Go to the last Page while in preview mode, and set $
$ReportBasePageNumber = Get ( PageNumber ) + 1. This is the starting  
page number for the next print job.
- Setup the second portion of the print job, go to Preview Mode. The  
page numbers should be correct.
- Repeat.

It worked out perfectly for us.
--
Hal Gumbert     hal@... or hal@... or hal@...
CampSoftware   http://www.CampSoftware.com

Office 407-282-5585    Cell 407-230-4862    Fax [phone]


FileMaker Pro Database Development & Consulting
Holding Certifications in FileMaker Pro 9, 8, and 7

On Aug 23, 2008, at 7:48 PM, John Valean Baily wrote:

> Hi Darren,
>
> On 22-Aug-08, at 5:34 PM, Darren Terry wrote:
>
>> GTRR to the line table, in a new window.  Enter Preview mode and Go  
>> to Record/Request/Page (Last).  Set $n to Get ( PageNumber ).  This  
>> is the number of pages of #3 in the sequence.
>>
>> Now set $n to $n + 3, and that's your starting page number for #4  
>> in the sequence.
>
> After re-reading the above, I realised I had already got to that  
> stage (figuring out the length of the varying page lengths) for  
> layout three and subsequent layouts and their page numbers.
>
> What I'm then trying to do is set the first page of layout three to  
> the sequential start, (taking into account that the first two  
> layouts, were page numbered 1 and 2 - 7 (that bit I figured)  What I  
> need to then do is set the start page # (on layout 3) as 8 , 9 and  
> 10 (assuming there are three pages to this layout).
>
> How do I start layout 3 at the number 8... and then number pages 9  
> and 10 accordingly (within that layout)...
>
> also
>
> Looking at m.rauch@..., calc's solution, of Get  
> (PageNumber) + 2 will - using my page sequences of in fact Get  
> (PageNumber) + 8 start the layout 3 sequence with the correct  
> number... but how does the numbering sequence continue for the 2nd  
> and 3rd pages in layout 3. The number of pages on layout is a  
> summary and the page numbers will vary and I can' figure how to  
> insure the correct number sequence ?
>
> I suspect I need a Get(StartPageNumber) calculation... ;)
>
> Thanks for your help.
>
> --
> Regards
>
> John Valean (Val) Baily
>
> FileMaker Pro Database Development.
> FileMaker Business Alliance & TechNet
> SyncDek Developers Alliance
>
> http://www.electronic-type.com
> Tel: [phone]
> Cel: [phone]
>
> _______________________________________________
> FMPexperts mailing list
> FMPexperts@...
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[John Valean Baily]

On 24-Aug-08, at 11:53 AM, Hal Gumbert wrote:

> Alex Brophy and I solved this problem just this week. The solution  
> involved these items

Thanks Hal,

Looks promising.

--
Regards

John Valean (Val) Baily

FileMaker Pro Database Development.
FileMaker Business Alliance & TechNet
SyncDek Developers Alliance

http://www.electronic-type.com
Tel: [phone]
Cel: [phone]

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au