Tom, I think you need either page mode or a reporting table for this arrangement, if you want to keep it properly indented. If I read your post correctly, you do not want header/footer to show where there are no grandchildren, just the single line, but where there are grandchildren, you want them indented less/more with the child total showing where the child should appear.
It would probably be easier to use a reporting table for this. Give me a shout if my message is unclear. "Javier Valencia" <[EMAIL PROTECTED]> wrote: >G'day Tom, >You should be able to use break point in your report to differentiate >between groups of data, even if they are in a parent child view. The report >will sort by that criteria (break points); however if you want to do further >sorting, just specify it in your PRINT USING statement > >Javier Valencia, PE >President >Valencia Technology Group, L.L.C. >14315 S. Twilight Ln., Suite #14 >Olathe, KS �66062-4571 >(913)829-0888 >(913)649-2904 FAX > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On >Behalf Of Tom Grimshaw >Sent: Monday, November 11, 2002 5:37 AM >To: [EMAIL PROTECTED] >Subject: Indented Accounting Reports > >G'day, > >I have three columns in a table. � ParentID, ChildID, Description. > >How do I indent successive lines of child accounts in an >accounting report in R:BASE for Windows when it is unknown >as to how many children levels exist in the table? > >To give this sort of result: > >Total Income > � US Sales > � � East US Sales > � � West US Sales > � Canadian Sales > � Other Sales > � � African Sales > � � Asian Sales > � � � Chinese Sales > � � � Japanese Sales > � � � Other Asian Sales > � � ANZO Sales > � � European Sales > � Other Income > > >Warmest regards, > > >Tom Grimshaw >coy: � �Just For You Software >tel: � �612 9552 3311 >fax: � �612 9566 2164 >mobile: 0414 675 903 > >post: � PO Box 470 �Glebe �NSW �2037 �Australia >street: 3/66 Wentworth Park Rd �Glebe �NSW �2037 > >email: �[EMAIL PROTECTED] >web: www.just4usoftware.com.au > >"... the control of impulse -- is the first principle of civilization."-- >Will Durant, >Pulitzer Prize winning philosopher, writer and historian > >the most needed product in the world can be found at >www.thewaytohappiness.org > >This email and any files transmitted with it are confidential to the >intended recipient and may be privileged. If you have received this email >inadvertently or you are not the intended recipient, you may not >disseminate, distribute, copy or in any way rely on it. Further, you should >notify the sender immediately and delete the email from your computer. >Whilst we have taken precautions to alert us to the presence of computer >viruses, we cannot guarantee that this email and any files transmitted with >it are free from such viruses. > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
