Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
&pcoderate in report
Message
 
To
11/02/2006 11:51:32
Mk Sharma
Shrishti Solutions
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01095652
Message ID:
01095657
Views:
11
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform