× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Doesn't crystal reports use SQL for its access? It would seem you could
use
a union in the SQL statement or at least a left outer join combined
with an
exception join. If that seems reasonable, I could post a statement
based
on your DDS.

David Morris

>>> dbathke@Quintrex.com 04/18/02 07:09AM >>>
Good Morning All, I have to create a logical file (UNION over two PF's
with
different record formats.) The PF's that this is to be built over have
only
one record format apiece. My problem is that crystal reports is having
a
hard time seeing this file and the file itself doesnt seem to have the
total
records of BOTH based on PF's. I created the file as follows; Does
anyone
have any insights on this matter. I know I cant create a Union LF that
has
only one rec format, at least I think thats the case, LOL. Gads its
earlyyyy. Thanks all, code is below.

  * SUBSCRIBER (MAIN) FILE
 A          R TIFSUBS                   PFILE(TIPSUBS)
 A            SBSUB#
 A            SBNPA
 A            SBNXX
 A            SBLIN
 A            SBDISD
 A            SBTERM
 A            SBLIST
 A            SBPMTD
 A            SBMTYP
  *
 A          K SBSUB#
 A          K SBNPA
 A          K SBNXX
 A          K SBLIN
  *
  * +-------------------------------------------------------------
  *
  * ADDITIONAL NUMBER FILE
  *
 A          R TIFADD#                   PFILE(TIPADD#)
 A            ADSUB#
 A            ADNPA
  A            ADNXX
  A            ADLINE
  A            ADDISD
  A            ADTERM
  A            ADLIST
  A            ADPMTD
  A            ADMTYP
   *
  A          K ADSUB#
  A          K ADNPA
  A          K ADNXX
  A          K ADLINE


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.