Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Suppressing individual fields
Message
De
20/03/2006 14:06:15
 
 
À
20/03/2006 09:35:40
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Crystal Reports
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Divers
Thread ID:
01105803
Message ID:
01105952
Vues:
23
>I made 6 detail sections and put each line in a separate section, and then I am suppressing the section if blank. However, there are 3 general information lines that I need to display to the right of the address, like so:
>
>
>DET-A|JOHN DOE                       |INFO1
>DET-B|1234 5TH ST                    |INFO2
>DET-C|APT. 3                         |INFO3
>DET-D|ANYWHERE, IA 12345             |
>DET-E|(123) 456-7890                 |
>DET-F|JOHNDOE@HOTMAIL.COM            |
>
>
>The problem now is that if the 2nd address line is not available, the section would still be displayed because INFO3 might not be blank. Is there an easy way to handle this, or do I need to re-think the report design?
>
>Thanks,
>Mike

I admit what I'm offering is quite kludgy, but maybe you can improve on the basic idea???
In the past I've wound up preparing the report cursor with ADDR1,2,...6. I then filled an array with the appropriate field values. Then I compress out the blank lines by
FOR I = 6 TO 1 STEP -1
   IF EMPTY(myArray[i])
      =ADEL(myArray,i)
   ENDIF
ENDFOR
which yields
BEFORE                            AFTER
JOHN DOE                          JOHN DOE
1234 5TH ST                       1234 5TH ST
                                  ANYWHERE, IA 12345
ANYWHERE, IA 12345                JOHNDOE@HOTMAIL.COM
                                  .F.
JOHNDOE@HOTMAIL.COM               .F.
and you can then populate ADDR1,2..6 etc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform