Witango-Talk: Reports help part 2 <@Rows> <@For>

Thu, 25 Jul 2002 13:16:05 -0700 

Part two.
I have the page breaks working. Thanks to all.

No problem when they select single course roster.

But now I have to display all the courses where the count is greater than
Zero and then course information followed by all the people who signed up.

I am doing two searches in the else if action. The 1st finds all the courses
with count greater than zero. The second finds everyone who signed up for a
course so far.

I've fooled around wit this for a hour or so but can't get a fix on how to
display a course and then the roster and then the next course etc.



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>


    <TITLE>Course Roster By Name</TITLE>
</HEAD>

<BODY></P>
<@ROWS ARRAY=local$courses START="<@CURROW>">
 <DIV STYLE="page-break-after:always">
<h2 align="center"><font face="Arial, Helvetica, sans-serif"><@COL
NUM=1>&nbsp;</font></h2>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Dates: <@COL
NUM=2 FORMAT="datetime:@@dateFormat">&nbsp;
<@IF EXPR='<@COL NUM=2 FORMAT="datetime:@@dateFormat">=<@COL NUM=3
FORMAT="datetime:@@dateFormat">'
<@ELSE>
<@COL NUM=3 FORMAT="datetime:@@dateFormat">
  </font></h4>
</@IF>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Times: <@COL
NUM=4 FORMAT='datetime:%I:%M %p'>&nbsp; <@COL NUM=5 FORMAT='datetime:%I:%M
%p'>
  </font></h4>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Location: <@COL
NUM=6>&nbsp; <@COL NUM=7>
  </font></h4>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Sorted by
Registration Date
  </font></h4>

<table width="75%" border="1">
  <tr> 
    <td><strong><font size="2" face="Arial, Helvetica,
sans-serif">Name</font></strong></td>
    <td><strong><font size="2" face="Arial, Helvetica,
sans-serif">Phone</font></strong></td>
  </tr>
<@COMMENT>
<@ASSIGN NAME="local$reg" VALUE="<@FILTER ARRAY='@@resultset'
EXPR='#1=local$course[*,8]'>">
</@COMMENT>

 <@ROWS <@FILTER ARRAY='@@resultset' EXPR='#1=local$course[*,8]'>>
  <tr> 
    <td><font size="2" face="Arial, Helvetica, sans-serif"><@COLUMN
"Registration.FName">&nbsp;<@COLUMN "Registration.LName"></font></td>
    <td><font size="2" face="Arial, Helvetica, sans-serif"><@COLUMN
"Registration.PhoneArea">-<@COLUMN "Registration.PhonePrefix">-<@COLUMN
"Registration.PhoneSuffix"></font></td>
  </tr>
</@ROWS>
</table> </DIV> 
</@ROWS>
<p>&nbsp;</p>
</BODY>
</HTML>

-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>


        <TITLE>Course Roster By Name</TITLE>
</HEAD>

<BODY></P>
<@ROWS ARRAY=local$courses START="<@CURROW>">
 <DIV STYLE="page-break-after:always">
<h2 align="center"><font face="Arial, Helvetica, sans-serif"><@COL 
NUM=1>&nbsp;</font></h2>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Dates: <@COL NUM=2 
FORMAT="datetime:@@dateFormat">&nbsp; 
<@IF EXPR='<@COL NUM=2 FORMAT="datetime:@@dateFormat">=<@COL NUM=3 
FORMAT="datetime:@@dateFormat">'
<@ELSE>
<@COL NUM=3 FORMAT="datetime:@@dateFormat">
  </font></h4>
</@IF>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Times: <@COL NUM=4 
FORMAT='datetime:%I:%M %p'>&nbsp; <@COL NUM=5 FORMAT='datetime:%I:%M %p'>
  </font></h4>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Location: <@COL 
NUM=6>&nbsp; <@COL NUM=7>
  </font></h4>
<h4 align="center"><font face="Arial, Helvetica, sans-serif">Sorted by Registration 
Date
  </font></h4>

<table width="75%" border="1">
  <tr> 
    <td><strong><font size="2" face="Arial, Helvetica, 
sans-serif">Name</font></strong></td>
    <td><strong><font size="2" face="Arial, Helvetica, 
sans-serif">Phone</font></strong></td>
  </tr>
<@COMMENT>
<@ASSIGN NAME="local$reg" VALUE="<@FILTER ARRAY='@@resultset' 
EXPR='#1=local$course[*,8]'>">
</@COMMENT>

 <@ROWS <@FILTER ARRAY='@@resultset' EXPR='#1=local$course[*,8]'>>
  <tr> 
    <td><font size="2" face="Arial, Helvetica, sans-serif"><@COLUMN 
"Registration.FName">&nbsp;<@COLUMN "Registration.LName"></font></td>
    <td><font size="2" face="Arial, Helvetica, sans-serif"><@COLUMN 
"Registration.PhoneArea">-<@COLUMN "Registration.PhonePrefix">-<@COLUMN 
"Registration.PhoneSuffix"></font></td>
  </tr>
</@ROWS>
</table> </DIV> 
</@ROWS>
<p>&nbsp;</p>
</BODY>
</HTML>

Reply via email to