Many thanks Dave and Peter
I am now making progress on this ...
I now have a single table with the data and a field (source) indicating
P(arent) or C(hild)
Two report variables PCount and CCount (initially 0)
Values to store are
IIF(Source='P',pcount+1,0)
IIF(Source='C',ccount+1,0)
My detail band has four lines
1. Parent headers (Print only when source = 'P' and pcount = 1, remove
if blank)
2. Parent records (print only when source = 'P', remove if blank)
1. Child headers (Print only when source = 'C' and scount = 1, remove
if blank)
2. Child records (print only when source = 'C', remove if blank)
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of [email protected]
Sent: 02 December 2011 12:46
To: [email protected]
Subject: Re: Report design problem
You could create your own cursor
Create cursor myrep (parent C20),child C(20))
then go through your files in the correct order and insert them into the
cursor. When you reach then end of a parent group, insert the children into
the cursor, then move to next group. Then the report layout is very simple.
HTH
* Peter Cushing *
IT development and support
Signature
Paul Newton wrote:
> Yes, exactly ...
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Dave Crozier
> Sent: 02 December 2011 12:05
> To: [email protected]
> Subject: RE: Report design problem
>
> So you only want to attach the children to the last Parent of a group?
>
> Is that what your problem is?
>
> Dave
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On
> Behalf Of Paul Newton
> Sent: 02 December 2011 11:57
> To: [email protected]
> Subject: RE: Report design problem
>
> OK Let me re-post with what the data might really look like:
>
> I have two tables with the following records:
>
> parent.p_id parent.p_desc
> 1 Fred
> 1 Mary
> 2 Jonathan
> 2 David
>
> child.c_id child.c_county
> 1 Essex
> 1 Surry
> 2 Devon
> 2 Cornwall
>
> I need a report that looks like this:
>
> Parent Heading
> Fred
> Mary
> Child Heading
> Essex
> Surry
> Parent Heading
> Jonathan
> David
> Child Heading
> Devon
> Cornwall
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
