Re: Witango-Talk: Help with <@ROWS> or <@For>

[Jose Kuhn]

Title: Re: Witango-Talk:  Help with <@ROWS> or <@For>

I have done something like this But in a nutshell You would order your search by the Location_ID then you must do something like the following.

The “Table Header” information is only displayed when CompanyCode != CompanyCode-1. Within the “Table Header” the Company Name is Displayed


                  <@For STOP=<@NUMROWS Array=BOArray Scope=Local>> <@IF EXPR="<@VAR Name=BOArray[<@CURROW>,CompanyCode] Scope=Local>!=<@VAR Name=BOArray[<@CALC EXPR="<@CURROW>-1">,CompanyCode] Scope=Local>" >
                  <tr>
                    <td colspan="4"><font face="Arial, Helvetica, sans-serif"><@var name=BOArray[<@currow>,CompanyName] scope=Local></font></td>
                    <td width="20%">&nbsp;</td>
                    <td width="9%">&nbsp;</td>
                    <td width="11%">&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="7%"><font face="Arial, Helvetica, sans-serif" size="-1">Status</font></td>
                    <td width="17%"><font face="Arial, Helvetica, sans-serif" size="-1">WO
                      Number </font></td>
                    <td width="18%"><font face="Arial, Helvetica, sans-serif" size="-1">Date
                      &amp; Time</font></td>
                    <td width="18%"><font face="Arial, Helvetica, sans-serif" size="-1">Repai
                      r Category</font></td>
                    <td width="20%"><font face="Arial, Helvetica, sans-serif" size="-1">Department
                      Name </font></td>
                    <td width="9%"><font face="Arial, Helvetica, sans-serif" size="-1">Final
                      Cost</font></td>
                    <td width="11%">
                      <div align="center"><font face="Arial, Helvetica, sans-serif" size="-1">Detail</font></div>
                    </td>
                  </tr>
                </@IF>
                  <tr>
                    <td width="7%">
                      <div align="center"><@IF EXPR="<@VAR BOArray[<@CURROW>,WOStatus] Scope=Local>='Complete'"><img src=""../../Images/CircleYellow.gif"" width="15" height="15"><@ELSE><img src=""../../Images/CircleGreen.gif"" width="15" height="15"></@IF></div>
                    </td>
                    <td width="17%"><font face="Arial, Helvetica, sans-serif" size="-1"><@var name=BOArray[1,FacilitatorCode] scope=Local>-<@var name=BOArray[<@currow>,WorkOrderNumber]
                      scope=Local></font></td>
                    <td width="18%"><font face="Arial, Helvetica, sans-serif" size="-1"><@var name=BOArray[<@currow>,TimeInitiated]
                      scope=Local></font></td>
                    <td width="18%"><font face="Arial, Helvetica, sans-serif" size="-1"><@var name=BOArray[<@currow>,RepairCategory] scope=Local></font></td>
                    <td width="20%"><font face="Arial, Helvetica, sans-serif" size="-1"><@var name=BOArray[<@currow>,DepartmentName] scope=Local></font></td>
                    <td width="9%"><font face="Arial, Helvetica, sans-serif" size="-1"><@var name=BOArray[<@currow>,BilledCost] scope=Local></font></td>
                    <td width="11%">
                      <div align="center"><font face="Arial, Helvetica, sans-serif" size="-1"><a href=""<@CGI><@APPFILE>?_function=DetailInvoice&WONumber=<@var" name=BOArray[<@Currow>,WorkOrderNumber] scope=Local>&<@USERREFERENCEARGUMENT>"><img src=""../../Images/ButtonGoSM.gif"" width="40" height="20" border="0"></a></font></div>
                    </td>
                  </tr>
                  </@for>


on 8/27/2002 11:19 AM, Dan Stein at [EMAIL PROTECTED] wrote:

> I have a search action that returns a list of courses that teachers have
> taken
>
> The values
> Staff_ID
> Course_ID
> Title
> First_Name
> Last_Name
> Location_ID
> Location
> Compensation
>
> I would like to return a report that looks like this
>
>
> Building ( location)
>
>
> Teacher
>       Course Number       Course name     Compensation
>
> Teacher
>       Course Number       Course name     Compensation
>
>
> Etc.
>
> For now I can have them do one building at a time but the list would look
> best if teacher names only showed when there was a new teacher in the list.
>
> I've attached what I have so far. I think I am close but just can't grasp
> the logic for the teacher loop.
>
>   


--
Webologies
150 Robinette Drive
Waynesville, NC 28786
828.627.1994

http://www.webologies.com


----------------------------------------------------------------------------
Rocket J Squirrel "Captain Peachfuzz has suddenly turned stupid"
Bullwinkle J Moose  "That wasn't a turn, it was more of a slight veer"
----------------------------------------------------------------------------