This topic is locked

Suppress field

4/21/2009 1:30:12 PM
ASPRunnerPro General questions
L
luic author

I have the list screen with the following columns as example
Name Type Order ID

aaaa 1 123

aaaa 2 343

bbbb 1 453
I want to suppress aaaa for the next row if the name in second row is the same as last row.
How can I do that to make it like this:
Name Type Order ID

aaaa 1 123

2 343

bbbb 1 453
Thanks.

J
Jane 4/23/2009

Chris,
you can add subheaders (Type and Order ID) manually editng HTML code on the Visual Editor tab and adding "List page: Before display" and "List page: After record processed" events on the Eventstab.
Here are some tips:

  1. Open List page in Visual Editor and switch to HTML mode
  2. Find the following code snippet
    {BEGIN grid_row}



and insert the following after this snippet

{BEGIN showheader}<TR>

<TD colSpan=10>&nbsp;&nbsp;&nbsp;&nbsp;

<H1>{$header}</H1></TD></TR>{END showheader}


3. Add"List page: Before display" event:

Session("header") = 0


4. Add "List page: After record processed" event:

if Session("header")<>rs("Type") & " " & rs("Order ID") then

Session("header")=rs("Type") & " " & rs("Order ID")

row("showheader")=True

row("header")=rs("Type") & " " & rs("Order ID")

end if

record("Type_value")=""

record("Order_ID_value")=""