× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WEB400
  3. February 2008

Re: net.data - using data fields in a headingatthevery top of a table

Thanks, Craig, I will give it a try in a bit.

Don

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Craig Jacobsen
Sent: Thursday, February 28, 2008 11:27 AM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] net.data - using data fields in a headingatthevery
top of a table

Now that I see what you are trying to accomplish for sure:

Move it to the %Row section.

You haven't read a record yet in the %Report section.
Plus your table isn't set yet.

Now
%IF ($(Break)!= $(V4))
@DTW_ASSIGN(Break, $(V4))
Put out the table stuff
%ENDIF

HTH,

Craig

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Thursday, February 28, 2008 10:51 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] net.data - using data fields in a heading
atthevery top of a table

Craig,

That's what I originally tried, but it does not show up?? I'm all of
whack here! Going to a funeral, be back later.

Thanks,
Don
--------------
%Report{

%if ($(V4) == "07YTD EARLY")
<TR>
<TH align = center><font color="#FF0000">Vendor Score Card</TH> </TR>

<TR>
<TD align = center>Vend#, $(V1), Name, $(V2), City, $(V3)</TD> </TR>
%endif

%{ Comments go here %}

<HTML>
<body bgcolor="d0d0d0">

<TABLE BORDER = "1">
%Row{
<TR>
%if ($(V4) == "07YTD EARLY")
<TH align = left><font color="#0066CC">Period</TH> <TH align =
left><font color="#0066CC">#POs</TH> <TH>QyTOT</TH> <TH>QyAVG</TH>
<TH>QyMIN</TH> <TH>QyMAX</TH> <TH>DysTOT</TH> <TH>DysAVG</TH>
<TH>DysMIN</TH> <TH>DysMAX</TH> </TR> %endif

<TR>
<TD align = left>$(V4)</TD>
<TD align = right>$(V5)</TD>
<TD align = right>$(V6)</TD>
<TD align = right>$(V7)</TD>
<TD align = right>$(V8)</TD>
<TD align = right>$(V9)</TD>
<TD align = right>$(V10)</TD>
<TD align = right>$(V11)</TD>
<TD align = right>$(V12)</TD>
<TD align = right>$(V13)</TD>

</TR>
%}
</TABLE>
%}

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Craig Jacobsen
Sent: Thursday, February 28, 2008 9:30 AM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] net.data - using data fields in a heading at
thevery top of a table

Do it before you start your table in the %Report section if you want it
outside the Table. If in the table, do it in the %Row but condition it
for one time only.

HTH,

Craig

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Haas, Matt (CL Tech Sv)
Sent: Thursday, February 28, 2008 9:55 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] net.data - using data fields in a heading at the
very top of a table

Ummm, write it our first?

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Thursday, February 28, 2008 9:51 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] net.data - using data fields in a heading at the
very top of a table

Ok, Matt, I think I can figure that out, but how do I get that TOP
heading line to appear ABOVE the table heading line?

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Haas, Matt (CL Tech Sv)
Sent: Thursday, February 28, 2008 8:45 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] net.data - using data fields in a heading at the
very top of a table

Don,

You can do this but you'll have to write the header from within the
%ROWS loop and use break logic to determine when to write them.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Thursday, February 28, 2008 9:24 AM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] net.data - using data fields in a heading at the very
top of a table

Vend# 11888 Your company USA Your City

Period #-POs QyTOT QyAVG QyMIN QyMAX DysTOT DysAVG DysMIN
DysMAX
07YTD EARLY 17 3231 190 10 850 430 25.3 1 98
07YTD LATE 52 16773 323 11 2000 -2426 -46.7 -321 -1
07YTD ONTIME 47 17565 374 4 2000 0 0 0 0
08YTD EARLY 1 25 25 25 25 3 3 3 3
08YTD LATE 2 500 250 100 400 -20 -10 -19 -1
08YTD ONTIME 34 13048 384 10 1800 0 0 0 0

The above copied in a bit scrambled, but I'm trying to get the
highlighted top line, which is also data coming out of each record in
the table showing below, to show only once, and to contain the actual
variable data for this vendor (just one time as a heading).

TIA,
Don

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman



--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.


--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.


--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.


--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.