Display records horizontally in tabular form
374142Jun 26 2007 — edited Jun 27 2007I need to create a tabular form that have total 6 columns (Year, Qtr1_Qty, Qtr2_Qty, Qtr3_Qty, Qtr4_Qty, Total). In the database, there is one record for each quarter. So that I have to read 4 records in the database and display them in 1 row. then, I need to sum them up to display the total for that year.
FY Qtr1 Qtr2 Qtr3 Qtr4 Total
-------------------------------------------------------------
2007 3 2 1 4 10
2008 4 1 1 1 7
.. and so on
Please give me some suggestions of how to accomplish this.
Best regards.
Stacy