Warren - You need to think about linking (i.e.. Same-named) columns in the tables you are referencing in this report.
So, following Claudine's advice, I'd make a view and use an alias name on the SysId to be Recong so it will match the correct column in the driving table of the report. Then use the view as the driving table of the sub-report. Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Warren Glass Sent: Sunday, August 14, 2005 12:08 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Sub Report Help Needed? Hi Claudine, Table is: Dollars Columns: Donor Int, Recong Int, AmtDon Currency, UseFor Text, DateRec Date Report Breaks on: Recong where Donor eq donor's SysID. The report opens or is created for only one person: Donor There is a table: persons with a column: SysID Int which is eq to Dollars, Donor and Recong If a person donates to them selves then both the Donor and Recong columns will eq the persons SysID If a person donates to someone else then Donor will eq the donors SysID and the recipients SysID will eq Recong This part of the report works and does list the Donor when the donor donates to themselves. But, when someone else donates to the donor it is not listed in the present report and is OK as we would not want amounts from other to be listed fro each person this person has donated to. What they want is to have listed at the top of the report where the donor's lookup information is shown a listed of all amounts from anyone including the donor that were for the donor. So we want to list all columns where Recong eq donor's SysID. (Sub-report) Is this helpful? Warren -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Claudine Robbins Sent: Saturday, August 13, 2005 9:34 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Sub Report Help Needed? Warren, I am trying to understand your post. Can you give an example of the desired output? Perhaps if you listed the columns in the table in question, it would be clearer. DonorId is the break field? Without understanding exactly what you're trying to do, would basing the sub-report on a view of the table help? Claudine > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Warren Glass > Sent: Saturday, August 13, 2005 9:06 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: 7.5 Sub Report Help Needed? > > 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. > ================================================
