Jason,

You are most welcome.

Jan
 


-----Original Message-----
From: Jason Kramer <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Tue, 29 Jun 2010 14:10:45 -0400
Subject: [RBASE-L] - Re: Sub-Report problem

Jan,
    Thank you.  That was it.  Each table had a column named title.  As soon 
as I changed the RG.title column to be RG.rgtitle, the sub-report generated.
                                                        Thanks,
                                                        Jason

Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)

On 6/29/2010 2:04 PM, jan johansen wrote: 
Jason,
 
Just a thought.
Are there any duplicated columns?
Sub-Reports follow the same protocol as Tables in Forms.
Any duplicated columns make the whole row disappear.
 
Jan
 

 
-----Original Message-----
From: Jason Kramer <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Tue, 29 Jun 2010 13:57:48 -0400
Subject: [RBASE-L] - Sub-Report problem

I am trying to setup a sub-report, but I having some trouble.  The 
sub-report does not generate.
There are two tables involved, RG and SC.  RG is the main table in the 
report and SC is the slave table.

RG has a primary key of rg#
rg# appears in SC as a foreign key.
SC has a primary key of sc#.

Every sc# has a rg#.
Not every rg# has a sc#.
A rg# may have more than one sc#.

The sub-report is a child sub-report, appears in the detail band, and is set 
to SC.

the detail bands in both the report and the sub-report are set to dynamic 
height.

    I am sure that I am missing a basic step, but I have read the help, 
looked at the example in RRBYW14, and read the FTE article, but I still 
can't see what I am missing.

                                        Thanks,
                                        Jason

-- 
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)

Reply via email to