In RRBYW14 the report with sub reports show a common column between the parent and slave tables?
James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, January 04, 2011 11:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Sub reports Jim, Make sure that there are not any displayed common columns between the master and the slave. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 4 Jan 2011 10:51:30 -0600 Subject: [RBASE-L] - Re: Sub reports What I have done is created a view as a slave table that contains the information I want to print in the sub-report. Now I have the original view which includes the sortone field (product line) and the model# field. The slave view contains the model# and assembly# field WHERE partnum = assembly# The breaks in the parent report are: 0 Control# 1 Model# D Partnum I have placed the sub-report in the Model# footer. The settings are child, keep together, parent width, and visible. It will not allow me to select stretch. When I run the report, nothing prints. Can anyone tell me what I need to change? James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, January 04, 2011 9:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Sub reports Jim, If I understand you correctly, you are misunderstanding a sub-report. I don't think you can fire a secondary report from inside another but I may be mistaken. I use sub-reports and our main document contains three. But they are one document. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 4 Jan 2011 08:52:40 -0600 Subject: [RBASE-L] - Sub reports I would like to attempt a sup report in my 7.6 database. We create packing lists for the product we ship out. Here are the details: The present report is based on a temp view with five tables. These tables are Orderheader, Orderrows, Prodpart, partinfo, & Material The Orderrows table has the model# field, which is a break point. This table also has a field Sortone that tells what product line the model belongs to. Here are the breaks: Detail section Partnum Break 0 Control# (some would call this an Order number) Break 1 Model# What I want to accomplish is this: If the sortone field = 'BL' then I want the sub report to print an extra detail packing list for certain kits based in a table ASSY_PART. The ASSY_PART table has a field Assembly# that has the same data as the Partnum field in the Partinfo table (part of the view above). In essence I would have IF sortone = 'BL' then based on the model# and partnum the sub report prints WHERE the Assembly# = Partnum. James Belisle
