Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to force a report to print when there are no records
Message
 
À
11/07/2000 21:58:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00391053
Message ID:
00391062
Vues:
15
>How can I force the report to print when there are no records? The user demands a printout even if there are no records! (She files all reports every month, even if there are no records in a particular report, she needs to file it anyway) :\

Detect if there are no records (this may be done with _tally if you are using a SQL statement or using COUNT TO. If there are no records create a cursor and put 1 blank record into it. Example:
SELECT this, that, theother FROM DodiTable WHERE x = y INTO CURSOR cReport
IF _TALLY = 0  && no data, fake some data to allow report to run
   CREATE CURSOR cReport (this c(3), that n(7), theother D)
ENDIF
SELECT cReport
REPORT FORM DodiReport TO PRINTER PROMPT
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform