Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
&pcoderate in report
Message
 
À
11/02/2006 11:51:32
Mk Sharma
Shrishti Solutions
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01095652
Message ID:
01095657
Vues:
13
Other way to do this:
Other aproach:

**myrepo.prg
LPARAMETERS myrate
LOCAL pcoderate
m.pcoderate = ICASE(m.myrate=1,"Pcode1.Crate",m.myrate=2,"pcode1.Brate", m.myrate=3,"pcode1.Mrp",[0])
SELECT ItStk.*, NVL(&pcoderate,000000000000.00) AS PCodeFieldToPrint; && Put as many zeroes as length of the PCode field you want to use in report.
       FROM ItStk;
       LEFT JOIN PCode1 ON ItStk.PCode == PCode1.PCode;
INTO CURSOR crsReport
Put the report to use default data session and base the report on crsReport.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform