How to display multiple repeating records and groupng of that record in HTML Reports

[Nupur Rai]

What is the way of displaying repeating multiple records and also grouping of that repeating records in HTML reports. Earlier i was using Crystal reports and there was not at all any problem but due to some restrictions i am supposed to use HTML reports. These multiple rows are saved in the database just i have to display it. Help me as i am in a critical situation :(

[Shyam K Pananghat]

Tooo Basic .. Get familiar or atleast go through some Sql basic stuff.. I believe you have to use "GroupBy" and "Orderby" clauses Properly in your query

Shyam.. My Blog dotnetscoups.blogspot.com

[Nupur Rai]

I think u did'nt get my question. The best example to explain the issue is u go to any garment shop and purchased 4 different kind of shirts and atleast 2 sizes of each kind of shirt from that same shop.The shopkeeper gives u itemized bill. In the database of that particular shop there would a normalized Item table to avoid repeat entries(as 1 CustomerID contains more than 1 record and that 1 record contains more than 1 sizes). That cash memo that u get is a kind of report. In the same way i need to display in that bill all the 4 shirts purchased with customerID which is not repeating and also "groupby" by each item to display each one's sizes respectively purchased and i.e in a HTML reports. This is it. Please give solutions for that