Re: ACE Report writing, I'm confused.
Posted in 1994
->From: mtiernan@world.std.com (Michael C Tiernan) ->Subject: ACE Report writing, I'm confused. ->Date: Mon, 18 Jul 1994 16:54:56 GMT ->Reply-To: mtiernan@world.std.com (Michael C Tiernan) ->Organization: The World Public Access UNIX, Brookline, MA -> ... omittedd ... ->And if I want to complex it so that the T3 entries go below the order ->they are assocated with, like this: -> "T1" info..... {Nth customer} -> "T2" #1 (No notes) -> "T2" #2 -> "T3" #1 -> "T3" #2 -> "T3" #3 -> "T3" #4 -> "T2" #3 -> "T3" #1 -> "T3" #2 -> ->I don't seem to be able to figure this out. I realize the problem I'm ->presenting here is an ACE report writer problem (as well as not perfectly ->clear in it's presentation) but I think I get the gist of the problem across. -> ->Does anyone have any recomended reading/searching/tutorials that I could ->work with to try and clear this up OR can someone out there offer me a few ->words of wisdom in pursuit of a solution to this? -> -> << MCT >> mtiernan@world.std.com -> Michael C Tiernan. GEnie: M.Tiernan -> Boston Computer Society member AOL: M Tiernan or BCS Mike -> Michael, Do your three-way join with "order by" clause. Use two "before group of ..." sections to print your T1 and T2 info. Use the "on every row" section to print your T3 info. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\