Monkeybread Software - MBS FileMaker Plugin: Report

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

Report

All examples are included with download of MBS FileMaker Plugin.

Report.fmp12

Overview
Tables	2
Relationships	2
Layouts	2
Scripts	2
Value Lists	0
Custom Functions	0
Custom Menus	33

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Result	1 field defined, 1 record	Result
Articles	12 fields defined, 3 records	Articles

Fields

Table Name: Result - 1 Fields

Auto-Enter:

Allow editing

Validation:

Only during data entry

Storage:

Repetitions: 1

Result

Create Table

Table Name: Articles - 12 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
ID	Normal, Number	Auto-Enter: Allow editing Serial: Generate: On creation, Next value: 8, Increment: 1 Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Articles	Options=Articles Articles=Images
Position Anzeige	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Bauteil	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Status	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Material Number	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Street	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
City	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Result	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Location	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Comment	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Articles		Create Table
Picture 1	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Articles		Create Table
Picture 2	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Articles		Create Table

Relationship: Articles=Images

Table Occurrence	Articles		Images
Field	ID	=	<Missing Field>
Source Table	Articles		<Missing Base Table>
Source File	Report.fmp12		Report.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Layout Hierarchy

Save record changes automatically

Show field frames when record is active

Show field frames only on current record

Show current record indicator in List View

1 Regular Fields
1 Group Buttons

Result

Off

Create Table

[File Default]

Articles

Yes

12 Regular Fields

Articles

Off

Create Table

[File Default]

Layout Objects: Result

Regular Fields

Field Name: Result::OutputPDF

Layout Name:

Result

Top: 6 pt
Left: 138 pt
Bottom: 867 pt
Right: 850 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Type:

Text: Create Report

Layout Name:

Result

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 39 pt
Left: 1 pt
Bottom: 64 pt
Right: 127 pt

Anchoring: Left, Top

Perform Script [ “Create Table” ]

Scripts:

Create Table

Layout Objects: Articles

Regular Fields

Field Name: Articles::ID

Layout Name:

Articles

Top: 24 pt
Left: 135 pt
Bottom: 38 pt
Right: 214 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Articles::Position Anzeige

Layout Name:

Articles

Top: 96 pt
Left: 140 pt
Bottom: 113 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Bauteil

Layout Name:

Articles

Top: 117 pt
Left: 140 pt
Bottom: 134 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Status

Layout Name:

Articles

Top: 138 pt
Left: 140 pt
Bottom: 155 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Material Number

Layout Name:

Articles

Top: 159 pt
Left: 140 pt
Bottom: 176 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Street

Layout Name:

Articles

Top: 180 pt
Left: 140 pt
Bottom: 197 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::City

Layout Name:

Articles

Top: 201 pt
Left: 140 pt
Bottom: 218 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Result

Layout Name:

Articles

Top: 222 pt
Left: 140 pt
Bottom: 239 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Location

Layout Name:

Articles

Top: 243 pt
Left: 140 pt
Bottom: 260 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Comment

Layout Name:

Articles

Top: 264 pt
Left: 140 pt
Bottom: 281 pt
Right: 393 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Articles::Picture 1

Layout Name:

Articles

Top: 84 pt
Left: 567 pt
Bottom: 209 pt
Right: 820 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Field Name: Articles::Picture 2

Layout Name:

Articles

Top: 213 pt
Left: 567 pt
Bottom: 338 pt
Right: 820 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Script Hierarchy

Create Table

InitDynaPDF

Next Script: [InitDynaPDF]

Script Name	Create Table
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Result
Scripts that use this script
Script Definition
Script Steps	Set Error Capture [ On ] #Initialize DynaPDF if needed If [ MBS("DynaPDF.IsInitialized") ≠ 1 ] Perform Script [ “InitDynaPDF” ] End If #Clear current PDF document Set Variable [ $r; Value:MBS("Trace.ErrorsOnly") ] Set Variable [ $r; Value:MBS("Plugin.SetPreviewSize"; 1200) ] Set Variable [ $pdf; Value:MBS("DynaPDF.New") ] Set Variable [ $r; Value:MBS("DynaPDF.SetPageCoords"; $pdf; "TopDown") ] Set Variable [ $i; Value:0 ] Set Variable [ $pageCount; Value:0 ] Set Variable [ $RowCount; Value:0 ] #Create outer Table #One row for each item, so they are not split on two pages Set Variable [ $table; Value:MBS("DynaPDF.Table.Create"; $pdf; 10; /* could be 10 rows / 1; / 1 column / 500; / width in points / 10) / default font point / ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetBorderWidth"; $table; -1; -1; 0; 0; 0; 0) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetCellPadding"; $table; -1; -1; 0; 0; 0; 10) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $table; -1; -1; "BorderColor"; 0; 0; 0) ] // Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $table; -1; -1; "GridHorzColor"; 200; 200; 200) ] // Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $table; -1; -1; "GridVertColor"; 200; 200; 200) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $table; -1; -1; "TextColor"; 0; 0; 0) ] // Set Variable [ $r; Value:MBS("DynaPDF.Table.SetGridWidth"; $table; 1; 1) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFont"; $table; -1; -1; "Helvetica"; 0; 1; "unicode") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFontSize"; $table; -1; -1; 10) ] #Add Rows Go to Layout [ “Articles” (Articles) ] Go to Record/Request/Page [ First ] Loop #Create inner Table #One table to keep the stuff for one item together Set Variable [ $iTable; Value:MBS("DynaPDF.Table.Create"; $pdf; 1; 1; 500; 10) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetBorderWidth"; $iTable; -1; -1; 1; 1; 1; 1) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetCellPadding"; $iTable; -1; -1; 2; 2; 2; 2) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $iTable; -1; -1; "BorderColor"; 0; 0; 0) ] // Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $iTable; -1; -1; "GridHorzColor"; 200; 200; 200) ] // Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $iTable; -1; -1; "GridVertColor"; 200; 200; 200) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $iTable; -1; -1; "TextColor"; 0; 0; 0) ] // Set Variable [ $r; Value:MBS("DynaPDF.Table.SetGridWidth"; $iTable; 1; 1) ] #Texts on top Set Variable [ $row; Value:MBS("DynaPDF.Table.AddRow"; $iTable) ] Set Variable [ $subtable; Value:MBS("DynaPDF.Table.Create"; $pdf; 10; 3; 500; 1) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetColWidth"; $subtable; 0; 120; 0 ) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetColWidth"; $subtable; 1; 240; 0 ) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetColWidth"; $subtable; 2; 120; 0) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; -1; -1; "BackColor"; 200; 200; 200) ] Set Variable [ $subrow; Value:MBS("DynaPDF.Table.AddRow"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 0; "left"; "top"; "Position") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 1; "left"; "top"; "Item") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 2; "center"; "top"; GetValue(Articles::Status; 1)) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFont"; $subtable; $subrow; 2; "Arial"; 2; 1; "unicode") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; $subrow; 2; "TextColor"; 255; 255; 255) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; $subrow; 2; "BackColor"; 255; 0; 0) ] Set Variable [ $subrow; Value:MBS("DynaPDF.Table.AddRow"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 0; "left"; "top"; Articles::Position Anzeige) ] #The item is split and left part is written bold, so we show you how to change font within text Set Variable [ $bauteil; Value:Articles::Bauteil ] Set Variable [ $pos; Value:Position ( $bauteil; ","; 1; 1) ] If [ $pos > 0 ] Set Variable [ $bauteil1; Value:Left ( $bauteil; $pos-1) ] Set Variable [ $bauteil2; Value:Middle ( $bauteil; $pos; Length($bauteil)) ] Set Variable [ $bauteil; Value:"\FT[Arial-BoldMT]" & $bauteil1 & "\FT[ArialMT]" & $bauteil2 ] End If Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 1; "left"; "top"; $bauteil) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 2; "center"; "top"; GetValue(Articles::Status; 2)) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFont"; $subtable; $subrow; 0; "Arial"; 2; 1; "unicode") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFont"; $subtable; $subrow; 2; "Arial"; 2; 1; "unicode") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; $subrow; 2; "TextColor"; 255; 255; 255) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; $subrow; 2; "BackColor"; 255; 0; 0) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFontSize"; $subtable; $subrow; -1; 13) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellTable"; $iTable; $row; 0; "left"; "top"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.Release"; $subtable) ] #Pictures Set Variable [ $row; Value:MBS("DynaPDF.Table.AddRow"; $iTable) ] Set Variable [ $subtable; Value:MBS("DynaPDF.Table.Create"; $pdf; 10; 2; 500; 10) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetGridWidth"; $subtable; 10; 10) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; -1; -1; "BorderColor"; 255; 255; 255) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; -1; -1; "GridHorzColor"; 255; 255; 255) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetRGBColor"; $subtable; -1; -1; "GridVertColor"; 255; 255; 255) ] Set Variable [ $subrow; Value:MBS("DynaPDF.Table.AddRow"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellImageEx"; $subtable; $subrow; / row / 0; / column / 1; / foreground / "left"; / alignment horizontal / "top"; / vertical alignment / 0; / width / 200; / height / Articles::Picture 1) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellImageEx"; $subtable; $subrow; / row / 1; / column / 1; / foreground / "left"; / alignment horizontal / "top"; / vertical alignment / 0; / width / 200; / height / Articles::Picture 2) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellTable"; $iTable; $row; 0; "left"; "top"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.Release"; $subtable) ] #Texts below pictures Set Variable [ $row; Value:MBS("DynaPDF.Table.AddRow"; $iTable) ] Set Variable [ $subtable; Value:MBS("DynaPDF.Table.Create"; $pdf; 10; 4; 500; 1) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetColWidth"; $subtable; 0; 120; 0 ) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetColWidth"; $subtable; 1; 125; 0 ) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetColWidth"; $subtable; 2; 120; 0 ) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetColWidth"; $subtable; 3; 125; 0) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetCellSpacing"; $subtable; -1; 1; 0; 5; 0; 0) ] Set Variable [ $r; Value:MBS( "DynaPDF.Table.SetCellSpacing"; $subtable; -1; 2; 5; 0; 0; 0) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFont"; $table; / Table / -1; / all rows / -1; / all columns / "Arial"; / font / 0; / normal font style / 1; / embed on / "unicode") / character mapping */ ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetFontSize"; $subtable; -1; -1; 8) ] Set Variable [ $subrow; Value:MBS("DynaPDF.Table.AddRow"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 0; "left"; "top"; "Material ID") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 1; "left"; "top"; Articles::Material Number) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 2; "left"; "top"; "Location") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 3; "left"; "top"; Articles::Location) ] Set Variable [ $subrow; Value:MBS("DynaPDF.Table.AddRow"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 0; "left"; "top"; "Street") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 1; "left"; "top"; Articles::Street) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 2; "left"; "top"; "Comment") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 3; "left"; "top"; Articles::Comment) ] Set Variable [ $subrow; Value:MBS("DynaPDF.Table.AddRow"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 0; "left"; "top"; "City") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 1; "left"; "top"; Articles::City) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 2; "left"; "top"; "Result") ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellText"; $subtable; $subrow; 3; "left"; "top"; Articles::Result) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellTable"; $iTable; $row; 0; "left"; "top"; $subtable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.Release"; $subtable) ] Set Variable [ $row; Value:MBS("DynaPDF.Table.AddRow"; $table) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.SetCellTable"; $table; $row; 0; "left"; "top"; $iTable) ] Set Variable [ $r; Value:MBS("DynaPDF.Table.Release"; $iTable) ] #Next item Go to Related Record [ From table: “Articles”; Using layout: “Articles” (Articles) ] Go to Record/Request/Page [ Next; Exit after last ] End Loop #Draw Table Set Variable [ $PageNumber; Value:1 ] Set Variable [ $pageWidth; Value:MBS("DynaPDF.GetPageWidth"; $pdf) ] Set Variable [ $pageHeight; Value:MBS("DynaPDF.GetPageHeight"; $pdf) ] Loop Set Variable [ $r; Value:MBS("DynaPDF.AppendPage"; $pdf) ] If [ Mod ( $PageNumber; 2 ) = 0 ] #even Set Variable [ $r; Value:MBS( "DynaPDF.SetFont"; $pdf; "Helvetica"; 0; 20) ] Set Variable [ $r; Value:MBS( "DynaPDF.WriteFTextEx"; $pdf; 50; 30; $pageWidth-100; 30; "right"; "Our Catalog") ] Set Variable [ $r; Value:MBS( "DynaPDF.SetFont"; $pdf; "Helvetica"; 0; 12) ] Set Variable [ $r; Value:MBS( "DynaPDF.WriteFTextEx"; $pdf; 50; $pageHeight - 30; $pageWidth-100; 30; "right"; GetAsText($PageNumber)) ] Else #odd Set Variable [ $r; Value:MBS( "DynaPDF.SetFont"; $pdf; "Helvetica"; 0; 20) ] Set Variable [ $r; Value:MBS( "DynaPDF.WriteFTextEx"; $pdf; 50; 30; $pageWidth-100; 30; "left"; "Our Catalog") ] Set Variable [ $r; Value:MBS( "DynaPDF.SetFont"; $pdf; "Helvetica"; 0; 12) ] Set Variable [ $r; Value:MBS( "DynaPDF.WriteFTextEx"; $pdf; 50; $pageHeight - 30; $pageWidth-100; 30; "left"; GetAsText($PageNumber)) ] End If Set Variable [ $r; Value:MBS("DynaPDF.Table.Draw"; $table; 50; 70; 742) ] Set Variable [ $r; Value:MBS("DynaPDF.EndPage"; $pdf) ] Exit Loop If [ MBS("DynaPDF.Table.HaveMore"; $table) ≠ 1 ] Set Variable [ $PageNumber; Value:$PageNumber +1 ] Exit Loop If [ $PageNumber > 10 ] End Loop #Cleanup Go to Layout [ “Result” (Result) ] Set Field [ Result::OutputPDF; MBS("DynaPDF.Save"; $pdf) ] Export Field Contents [ Result::OutputPDF; “file:test.pdf”; Create directories:No ] Set Variable [ $r; Value:MBS("DynaPDF.Table.Release"; $table) ] Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ]
Fields used in this script	Articles::Status Articles::Position Anzeige Articles::Bauteil Articles::Picture 1 Articles::Picture 2 Articles::Material Number Articles::Location Articles::Street Articles::Comment Articles::City Articles::Result Result::OutputPDF
Scripts used in this script	InitDynaPDF
Layouts used in this script	Articles Result
Tables used in this script	Articles Result
Table occurrences used by this script	Articles Result
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Create Table]

Script Name	InitDynaPDF
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script	Create Table
Script Definition
Script Steps	#Locate DynaPDF library #you can have libraries in container and export at runtime to folder of your choice. #Or install library somewhere and pass path. #If library is in same folder as plugin, you can only pass only file name. If [ MBS("IsServer") ] #Put the path you use for your server here: If [ Get(SystemPlatform) = -2 ] #Server on Windows Set Variable [ $path; Value:"C:\Programs\FileMaker Server\dynapdf.dll" ] Else If [ MBS("IsLinux") ] #Server on Linux for FileMaker Cloud Set Variable [ $path; Value:"/opt/FileMaker/FileMaker Server/dynapdf.linux.so" ] Else #Server on Mac Set Variable [ $path; Value: "/Library/FileMaker Server/dynapdf.dylib" ] End If Else #For desktop and our examples we look in same folder as database: Set Variable [ $databasePath; Value:Get(FilePath) ] Set Variable [ $databasePath; Value:MBS("Path.FilemakerPathToNativePath"; $databasePath) ] Set Variable [ $databasePath; Value:Substitute ( $databasePath ; ".fp7" ; ".fmp12") ] Set Variable [ $databaseName; Value:Get(FileName) & ".fmp12" ] If [ Get(SystemPlatform) = -2 ] Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dll" ) ] #plugin will look for dynapdf.dll and if not found also for dynapdf.dll (64-bit) and dynapdf32.dll (32-bit). Else Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dylib" ) ] #Mac dylib is usually 32 and 64 bit together. End If End If #You can test for free. #If you like to get a dynapdf license, please follow links on our pricing page: #https://www.monkeybreadsoftware.de/filemaker/pricing.shtml Set Variable [ $LicenseKey; Value:"" // put your key here or leave empty for demo. // Use e.g. "Lite", "Pro" or "Starter" to use demo mode for just that mode. ] Set Variable [ $r; Value:MBS( "DynaPDF.Initialize"; $path; $LicenseKey) ] If [ $r ≠ "OK" ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Cancel”, Commit: “No” ] Halt Script End If
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Download example: Report

Used functions: