>Hi all
>I am new to vfp and facing some problems like following;
>I want to use nested IF in a report; and
>I want to execute multiple queries in a single report.
>
>Can anybody help me?
>Anybody in Lahore if can spare some time to teach me vfp? I can pay for it
>
>regards
In the report, instead of the if command, you can use the iif() function. For example, let's say you have a logical field "Enabled", your report expression might be:
iif(Enabled, "Enabled", "Disabled")
iif() can be nested, too:
iif(x = 1, "one", iif(x = 2, "two", "more than two"))
But quite often, it is more convenient to prepare all data in the cursor, before you run the report - as Çetin explained.
With respect to the "multiple queries", I am not sure what you mean; perhaps you can give some additional explanations.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)