Mar 20, 2015; 11:50
Patrick Larkin
Lasso 8.5 and FMP Portal and PDF
I never used Lasso 8.5 to show items in a Filemaker Pro portal. (FMS 12) I have code to produce a PDF and am trying to pull portal rows into a PDF table and nothing displays. The original inline produces =91No error=92 but am I doing something wrong in my portal syntax? Should this work?
The last table column is set to display a hard coded string and that does not appear either.
–
[inline(
-inlinename='assign_fetch',
-database='staff',
-table = =91myTable',
-username=$dbu,
-password=$dbp,
'Last First MI' = =92Smith John',
-search)] [var('err') = error_currenterror]
[/inline]
[var:'MyTable'=(PDF_Table:
-Cols=4,
-Rows=(found_count),
-Spacing=0,
-Padding=2,
-Width=100,
-BorderWidth=0.0,
-ColWidth=(Array:'25.0','25.0','25.0','25.0')
)]
[records(-inlinename='assign_fetch')]
[portal('Assignments')]
[var('theText') = field('Position')]
[var:'text3'=(PDF_Text:$theText, -Type='Paragraph', -Font=$MyFont, -Leading=10)]
[$MyTable->(Add:$text3, -Col=0, -Row=1, -HorizontalAlignment='left')]
[var('theText') = field('School')]
[var:'text3'=(PDF_Text:$theText, -Type='Paragraph', -Font=$MyFont, -Leading=10)]
[$MyTable->(Add:$text3, -Col=1, -Row=1, -HorizontalAlignment='left')]
[var('theText') = field('Dis')]
[var:'text3'=(PDF_Text:$theText, -Type='Paragraph', -Font=$MyFont, -Leading=10)]
[$MyTable->(Add:$text3, -Col=2, -Row=1, -HorizontalAlignment='left')]
[var('theText') = 'DAYS']
[var:'text3'=(PDF_Text:$theText, -Type='Paragraph', -Font=$MyFont, -Leading=10)]
[$MyTable->(Add:$text3, -Col=3, -Row=1, -HorizontalAlignment='left')]
[/Portal]
[/records]
[$MyFile->(Add:$MyTable)]
––
Patrick Larkin
Application Management Group
Information Technology
Bethlehem Area School District
https://www.beth.k12.pa.us
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Mar 20, 2015; 09:15
Maxwell Klein
Re: Lasso 8.5 and FMP Portal and PDF
Mar 20, 2015; 15:18
Patrick Larkin
Re: Lasso 8.5 and FMP Portal and PDF