Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculated expression from two expression
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01158307
Message ID:
01158367
Views:
21
>Hi All,
>i've two field on detail band and has a below codes
>
>* for debit field
>
>IIF(crsresult.fischcode $ " '101','104','105','108','112','303','114','306','002','004','006','012','014','016','019','020',;
>                            '026','028','037','039','040','044','202','309','310','007','008','023','024'",;
>                            crsresult.amount,0)
>
>
>* for credit field
>
>IIF(crsresult.fischcode $ " '102','103','106','109','113','115','001','003','005','011','013','015',; 
'017','018','025','027','036','038','041','045','201','301','302','311',; '312','009','010','021','022'",crsresult.amount,0)
>
>
>it works fine for my need. i wantto also show at 3rd field debit-credit action,
>expressions is too long for this :(
>
>how can i do this ?
>
>any suggestion will be very appreciated
>
>TIA

I see you use crsResult. Is this means that you use cursor in that report? If so you could prepare your cursor the way you want. Add two fields, Debit and Credit and during the preparation of the cursor fill these fields the way you want. Then in report just print both fields.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform