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)
|