Re: ACE Report writing, I'm confused.

Michael, Look at the BEFORE GROUP clause in the ACE programs. You will need a ORDER BY T1.f1, T1.f2 statement in your SELECT clause. Then in the FORMAT section add a BEFORE GROUP statement to print out the header info in T1 and a BEFORE GROUP statement to print out T2. Then in your EVERY ROW section print T3. Regards - Lester > Michael C Tiernan asked: > Let me ask a hypothetical question here. Using Informix 2.10, I've got > three tables, they way they connect can best be described as one of the > sales examples in the manual. .. example stuff deleted .. > 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 > > 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? Regards - lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # #############################################################################