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. I use ISQL as well, and there's no easy (or even not-difficult) way to to this. For a lot of reports, I've used ACE to extract the data, and awk (we're on a Unix box) to format it. The REPORT TO PIPE option makes it pretty seamless. Good luck. -- Mark Rafn dagon@halcyon.com http://www.halcyon.com/dagon/