You can make an array of the resulting ARGS, then use the ARGS array in a
direct DB action to create a new list of just the selected clincs and then
print it.
SO the ARRAY='a_re400PAgroup' is the ARGS array.
By assigning to a VAR you can use Witango IF statements, date functions
etc. When you use the VAR in the direct DB action the DB action just has to
deal the values that the VAR returns.
<@! COMMENT="This Var below creates the array used by SQL that returns the
Last note for each intervention sacheduled/pending">
<@! COMMENT="refer to the DDB action that follows">
<@ASSIGN NAME="sql_listlastNotes" VALUE="SELECT id_pa100authztn,
id_re400order, id_re150recert, id_ct100cont, id_pp300intvntn,
id_re450statustype, id_rp350profileid, re400startdate,re400startdate_year,
re400startdate_month, re400startdate_day, re400start_time, re400SumMins
FROM physio.re400
WHERE
<@ROWS START=1 STEP=1 STOP=<@NUMROWS ARRAY='a_re400PAgroup'>
ARRAY='a_re400PAgroup'>
(id_pa100authztn = <@COL NUM='1'>) AND (re400startdate =
CONVERT(DATETIME, '<@COL NUM="2">', 102))
<@IF EXPR='(<@CURROW> <<@NUMROWS ARRAY="a_re400PAgroup">)' TRUE='OR'
FALSE=''>
</@ROWS>
ORDER BY id_pa100authztn" SCOPE="Request">
_____
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Monday, May 19, 2008 3:43 PM
To: [email protected]
Subject: Re: Witango-Talk: Printing from a checked list
you can do this thru CSS and JS.
here is a quick example of just masking the print option from showing up in
the print
<pre>
place this in the header
==========================
<style type="text/css" media="print">
.printlink {display:none;}
</style>
and this is the body
===============
<div class="printlink">
<a href="javascript:window.print()" >Click to Print This Page</a>
</div>
</pre>
Ben
On May 19, 2008, at 5:17 AM, Dan Stein wrote:
I want to make it possible for users to check the boxes on this page then
press a button that will print a list of those clinics without the page
menu, just the header image.
Can someone point me in the right direction?
http://nm.dss-demo.com/free_clinics.taf?_function=list
<http://nm.dss-demo.com/free_clinics.taf?_function=list&state=pa> &state=pa
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 215-799-0192 ( Call 1st)
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
'I wonder why we say that people are of different "races". It seems to me,
we're all running at the same speed and heading towards the same
destination. The only "winners" are the ones who've made the world a better
place for having been here.'
>From for Better or Worse 2/28/2006
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
