Tricky ACE report problem

I have a table that amongth other columns has order_no line_item_no due_date and I've been asked to do a report with the following layout For the 7 days prior to today date1 date2 date3 ... date7 order_no, line order_no, line order_no, line such that there are 7 columns, with the date headings and below each date a list of all items that fall due on that date. I can't see an easy way of doing this. I have ISQL. Can any one help????? --Kate r