FMPRO-L Archives

November 2014, Week 2

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Mikhail Edoshin <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Thu, 13 Nov 2014 13:55:24 +0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (3463 bytes) , text/html (15 kB)
Hmm. Well, I think it's possible too: make a list from the found set, 
thengrab the master value list and filter:

FilterValues(
ValueListItems( "" /* current file */; "Regions" );
GetSummary( Job::List of Regions; Job::List of Regions ) )

Kind regards,
Mikhail

On 13.11.2014 13:42, Peter Buchanan wrote:
>
> Hi Mikhail
>
> Yes, that makes sense.
>
> Just another question -- related to this issue.
>
> How to create a value list of regions, from only the found set. I 
> thought the List function would do that, but it creates a list off all 
> the values in each and every record, whereas I want something like a 
> value list, one entry for each occurrence of a region?
>
> Regards
>
> Peter
>
> *From:*FileMaker Pro Discussions 
> [mailto:[log in to unmask]] *On Behalf Of *Mikhail Edoshin
> *Sent:* 13 November 2014 11:28
> *To:* [log in to unmask]
> *Subject:* Re: saving grouped records to individual PDF files
>
> Hi Peter,
>
> You need to name an object to be able to read its value in preview 
> mode; there's no other way (no easy one at least; it's possible to set 
> up a field that would modify a variable when rendered, but all this is 
> convoluted and unreliable). But now when you've asked I'm not sure 
> anymore, because whatever tests I've run I run long time ago. On the 
> other hand if I ended up with this idea then there were reasons, I 
> guess :) From what I vaguely remember if you try to read a value in 
> preview mode, it will return the value from the first record, 
> regardless of the page you're on; but an object on a layout will 
> return the real value from whichever record happens to be on that page.
>
> Kind regards,
>
>
> -- 
> Mikhail Edoshin
> [log in to unmask]  <mailto:[log in to unmask]>
> Skype: mikhail_edoshin
>
> On 13.11.2014 13:19, Peter Buchanan wrote:
>
> Thanks Mikhail
>
> Similar to Richard's solution.
>
> Just one question -- the need to give an object name?
>
> Regards
>
> Peter
>
> *From:*FileMaker Pro Discussions 
> [mailto:[log in to unmask]] *On Behalf Of *Mikhail Edoshin
> *Sent:* 13 November 2014 08:08
> *To:* [log in to unmask] 
> <mailto:[log in to unmask]>
> *Subject:* Re: saving grouped records to individual PDF files
>
> Hi Peter,
>
> It may be possible to add a subsummary part, set it to break the page 
> before each occurrence, put the region name into it and give it an 
> object name. Then loop over the pages in Preview mode and on each page 
> read the current region. If it's different from the previous, you got 
> a new group; remember the page number and continue to loop until you 
> get another region or there's no more pages. This way you can 
> calculate the pages for each region and save only those pages.
>
> Kind regards,
>
>
> -- 
> Mikhail Edoshin
> [log in to unmask]  <mailto:[log in to unmask]>
> Skype: mikhail_edoshin
>
>
> On 11.11.2014 21:54, Peter Buchanan wrote:
>
>
> Hi
>
> Maybe someone can just point me in the right direction :
>
> (Windows, FM Pro 13)
>
> I have a found set, say 30 records, all having the same job number ID.
>
> Within this set, the records each have a value in the Region field.
>
> The number of records will vary, and the regions are also variable.
>
> I sort the records by Region, then I want to save the records to PDF, 
> creating one PDF file for each region.
>
> I was thinking along the lines of creating a value list of the 
> regions, and then looping through each value etc.
>
> Any ideas?
>
> Many thanks
>
> Peter
>

-- 
Mikhail Edoshin
[log in to unmask]
Skype: mikhail_edoshin



ATOM RSS1 RSS2