Hi Larry, Thank you for the reply. I do have several reports with sub-reports that are working nicely. This one is different for me. It is the same table as the main report and the sub-report needs to sit in the header section of the main report. RBTI has not indicated that this can't be done so I am trying. The main reports' detail section sorts and breaks the data for the different donations the person made with dates, amounts, use, etc. I am trying with the sub-report to sort the data on who gave how much to this person. I really want to get this to work as I am trying to get a nice accounts away from MS Access and its vendor and with Rbase and me as the vendor. They are able to make this report with Access sub-reports.
Warren -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Larry Wilson Sent: Saturday, August 13, 2005 12:48 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Sub Report Help Needed? Hello Warren: As I understand sub-reports the object allows you combine detail data from several tables into one 1 report. I have designed several reports using the sub-report object and I love them. It took a while to figure it out so I will share with what I have done. In order for me to get the correct data from each sub-report object I created a break point on the table the sub-report was based on and I located the sub-report object in a detail band on the main table. I have included detail data from 3 tables on a complex insurance form and it works great. In your email it you said that you want to put the sub-report in a header band, I have never tried that because a header band is only going to give you the header and no detail. If you are only using one table why don't you create a break point and use the detail band to put the detail data or if you have multiple break points use the break footer. Larry -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Warren Glass Sent: Friday, August 12, 2005 9:25 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Sub Report Help Needed? I have not been able to get the sub report to show the rows I want selected. How do I get the sub report to select only the rows I want? Warren -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Thursday, August 11, 2005 10:18 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Sub Report Help Needed? At 11:55 PM 8/11/2005, Warren Glass wrote: >... I want to use a sub-report to list in the main report header >the rows of data that make up the total donated to him. The data >comes from the same table. I just have not been able to get the >sub-report to do the needed selection using the DonorID which is >a column value used for lookups in the main report header. Warren, You can certainly achieve that goal by placing a "DB Calc" Control with the "LookAhead" option set to true. Take a look at the sample "CustContInvoices" report included with the Running R:BASE Your Way! (Part 10). Database: RRBYW10 Report/Sub-Report: CustContInvoices Associated Tables/Views : . NewCustomer . NewInvoiceHeader . NewInvoiceDetails . NewContact Hope that helps! Very Best R:egards, Razzak. --- RBG7-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
