Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report expression more than 255 characters
Message
From
04/09/2007 04:46:09
 
 
To
04/09/2007 03:04:30
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01252084
Message ID:
01252091
Views:
14
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform