Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using functions inside of a report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00102868
Message ID:
00102959
Views:
18
>>The cool trick I like to use for this kind of thing is to use the following in the field expression box:

>>IIF(field=value,substitute_value,field)

>>HTH
>
> Yeah, that's what I'm doing in another one of my reports. Unfortunately, this field can be one of ten different values.

Hey, first of all, there is a Print Option on Field.
Double-Click the field and click the Print Option, and fill in the condition.


Previously, I have a problem on printing 10 selected option on FIX label text.
Such as 'Need Throw Test', 'Add Client Label', .....
If I put them one by one, the figure will like below:
.........
.........

.........


.........
.........

.........
This layout will be very poor.


So, In order to shorten the IIF() statement.
I define some variables in report by: (Select Variable in Report menu)
L1 = "Need Throw Test"
L2a = ...

Finally, I make a huge rectangle field for puting multi-line.

IIF(Cond1, L1+CHR(13), [])+IIF(Cond2, L2a, L2b)+Chr(13)+.....

So, this field total character will NOT be excess 255 characters.
and the layout will be well hor. PACK!! ^_~

Hope this can help your 10 different values...
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform