Re: Tricky ACE report problem

Kate, Do the dates HAVE to be along the top of the output ? If not, a simple select where date >= (today -7) and then an "after group of date" in the format section, could give you the information you need with each date as a separate row. There may be a way to get the dates as columns with ACE, but it would probably be messy and need tons of variables to be defined. I'd need to have a bit more of a think about that one.:-) HTH. Cheers, Richard. ----------------------------------------------------------------- | _ /\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | ----------------------------------------------------------------- ----- Begin Included Message ----- From ilist@rmy.emory.edu Sat Jul 29 16:34:24 1995 From: kcj@netcom.com (Kate Juliff) Subject: Tricky ACE report problem Date: Sat, 29 Jul 1995 13:53:47 GMT To: informix-list@rmy.emory.edu X-Informix-List-To: rt10hp@csl.gov.uk X-Informix-List-Id: <news.15843> 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 ----- End Included Message -----