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 > An option I have not seen float across yet: read it all into arrays. print the arrays sideways. Of course 'array' is a misnomer. But if you look at the maillabel examples under SQL you can see a method to fake them. I'm not saying this is a better method, just one I haven't seen float by yet. It would certainly NOT work if you had a large amount of data to process. Otherwise Kathy's suggestion of reading into a temp table and doing the rotation there seems better. You could do a seven way select statement using UNIONs and then choose your location to print on the page based on the value in the date field. Nasty. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Discover America, get lost on a rally. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________