Hi

I am using Classic ASP. I want to display a matrix report on screen from the same table. I want to display products horizontally across the top of the page and the test gear vertically down the left hand side. for each product that the test gear is using, I want to mark it, so:


                              Products
Test Gear | Part No | Equipment 1 | 2 | 3 | 4 | etc
A AA Y Y
B BB Y Y Y
C CC Y

I can display the equipment along the top, but the test gear will not display along the left side.

Code:
 While ((Repeat1__numRows <> 0) AND (NOT rsTestGear.EOF)) %>
 <td> <%=(rsTestGear.Fields.Item("EQUIPMENT").Value)%> </td> (Displays equipment on the top)

  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  rsTestGear.MoveNext()

Wend

Currently I can display:

Description | Part No | Equipment |

                               Equipment 1 2 3 etc

All equipments across the top as I wanted, but items on the left under desc and part no are not showing.

I have tried to display those records within while wend loop, display everything as a normal display three columns and loads of rows. when i tried to put it after the wend, it says asp error.
This is the code for the two columns:

<td> <%=(rsTestGear.Fields.Item("desc").Value)%> </td>
<td> <%=(rsTestGear.Fields.Item("part_no").Value)%> </td>

Any help appreciated.
Ahmed

First post your table structure and tell me which backend you are using?

urt

Help yourself by helping someone.

urt

i am using SQL Server Enterprise

Table below. Note, to display result of query for desc and part_no are not included. i have tried to put in within while loop and outside, does not work. ASP error

Thanks.

<table id="table01" width="100%" border="0" cellpadding="2" cellspacing="2">

<tr bgcolor="#DDDDDD">

<td><a>Description</a></td>
<td> <a>Part No</a></td>
<td><a>Equipment</a></td>

<tr>
 (two blank cells to line first two cells of desc and part_no in row 1)

</tr>
<tr bgcolor="#EEEEEE">
<td></td> <td></td>
<%
previous =""

While ((Repeat1__numRows <> 0) AND (NOT rsTestGear.EOF)) %>
<%
if previous = rsTestGear.Fields.Item("EQUIPMENT").Value or isnull(rsTestGear.Fields.Item("EQUIPMENT").Value) then
else
%>

<td> <%=(rsTestGear.Fields.Item("EQUIPMENT").Value)%> </td>
<%
  previous = rsTestGear.Fields.Item("EQUIPMENT").Value
end if

  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  rsTestGear.MoveNext()

Wend
%>

</tr>

   </table>

I was asking for database table structure

urt

Help yourself by helping someone.