HTML REPORT GENERATION USING VB.NET

See more:

VB

Hi Developers,
I am Raveesh am Developing a HTML Report in VB.NET So here am using SQL DB and Visual studio 2005.am developing in vb.net. My task is to create a html report.To create a html report i taken data from table to dataset now i have data in the below format.

<TABLE>
<TR><TD>orderid</td>
<TD>ipono  </td>
<TD>orderno</td>
<TD>WO QTY</td>
<TD>TYPE ID</td>
<TD>TYPE Name</td>
<TD>Type Desc</td>
<TD>Qty</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>2</td>
<TD>Fusing</td>
<TD>6622 fusing</td>
<TD>25</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>2</td>
<TD>Fusing</td>
<TD>6655 fusing</td>
<TD>26</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>3</td>
<TD>FIXING</td>
<TD>6622 Fixing</td>
<TD>27</td>
</tr>

<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>3</td>
<TD>Fixing</td>
<TD>6655 Fixing</td>
<TD>28</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>3</td>
<TD>Fixing</td>
<TD>6657 Fixing</td>
<TD>29</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>5</td>
<TD>Mixture</td>
<TD>6657 Mixture</td>
<TD>30</td>
</tr>
</table>

and i want to get the result like below one

<TABLE>
<TR><TD>orderid</td>
<TD>ipono  </td>
<TD>orderno</td>
<TD>WO QTY</td>
<TD>Fusing</td>
<TD>Qty</td>
<TD>FIXING</td>
<TD>Qty</td>
<TD>Mixture</td>
<TD>Qty</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>6622 fusing</td>
<TD>25</td>
<TD>6622 Fixing</td>
<TD>27</td>
<TD>6657 Mixture</td>
<TD>30</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>6655 fusing</td>
<TD>26</td>
<TD>6655 Fixing</td>
<TD>28</td>
<TD>--</td>
<TD>--</td>
</tr>
<TR><TD>2253</td>
<TD>246 </td>
<TD>1</td>
<TD>376</td>
<TD>--</td>
<TD>--</td>
<TD>6657 Fixing</td>
<TD>29</td>
<TD>--</td>
<TD>--</td>
</tr>
</table>