Re: Tricky ACE report problem

>Kate Juliff <kcj@netcom.com> wrote: >>I have a table that among 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. If I were you I would try to persuade my masters that they don't really want the seven columns going across the page at all. After all, what happens when someone decides that they need the past 14 days rather than the past seven? - the paper won't be wide enough to accomodate this. Or if they decide that in each column they want additional information (order number, line number, and something else)- again, it isn't going to fit. How much better, how much wiser, how much more enlightened to format the output like this: Date Ord # Line # ---- ----- ------ date1 3856 - 12 3954 - 02 3868 - 03 date2 3979 - 01 5496 - 02 3763 - 04 date3 4865 - 11 3956 - 12 - plenty of room to grow. I think it is possible to do what you originally asked in ACE, but it would be quite convoluted. - Paul