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
 

Reply via email to