Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report expression more than 255 characters
Message
De
04/09/2007 04:46:09
 
 
À
04/09/2007 03:04:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01252084
Message ID:
01252091
Vues:
13
>Dear Experts
>
>How to display characters more than 255 in report expression.
>
>I want to display followings in a report expression
>
>("Please debit our Account No.") +allt(year.bacc) +space(2)+("through cheque No. __________")+space(2)+allt("a sum of")+space(2)+allt("Rs.")+allt(str(sal2))+space(2)+("(")+("Rupees")+allt(sal3)+(")")+("and transfer credit above amount to the accounts as under as soon as possible")
>
>Please help

Get rid of all the parentheses except those you really need like allt(str(sal2))

You don't need parens for ("Please debit our Account No.") and you especially have no need of trimming string literals like this allt("Rs.") it serves no purpose.

It should look more like this:
"Please debit our Account No."+allt(year.bacc)+" through cheque No. __________  a sum of  Rs. "+allt(str(sal2))+"(Rupees "+allt(sal3)+") and transfer credit above amount to the accounts as under as soon as possible"
If your expression is still to long, you can use memory variables or report variables to hold longer constants. Or, create a UDF to create the string.

It's not the output that is too long, it is the expression itself.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform