Francis (net) wrote:
> I've got a report with three tables ... related.
>
> I'm using two detail bands and one Group similar to
> 'employeesMD.frx'
> in "The VFP Report Writer: Pushing it to the Limit and Beyond"
> ... chapter 5 VFP 9 update.
>
> In actuality it's behaving exactly as I would expect. The
> problem is that there are
> instances that the third table has no related data.
>
> What I'd like to be able to do is 'not' print the Detail 2 Header
> when there is no data
> for that band. I suppose that I could stick Print When's in all
> the Header labels, but
> I'm wondering if there is a more preferred way ... any
> suggestions!!!
>
I've not used this VFP9 report writer but do you have a Print when
option for the whole band? If so could you put in there !eof("File3")
Another option might be to select out the data into 1 table/cursor but
use an inner join. Then you won't get any records where there is a
blank for file 3
Peter
----------------------------------------------------------------------------------------
This communication and the information it contains is intended for the person
or organisation to whom it is addressed.Its contents are confidential and may
be protected in law. Unauthorised use, copying or disclosure of any of it may
be unlawful.If you have received this message in error, please notify us
immediately by telephone or email.
While Rajan Imports has taken every reasonable precaution to minimise the risk
of virus transmission through email, we cannot accept liability for any damage
which you sustain as a result of software viruses.
It is the responsibility of the recipient to ensure that they have adequate
virus protection.
www.rajan-group.co.uk
Rajan Imports Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700
Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
_______________________________________________
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.
