variable in report designer

[R17]

i have cvl as variable in my report,

 IIF(dtrupcode="VL",1,0)

it works fine if i put a text box and write in expression "cvl".

if i want to only print the cvl when cvl>0 i do,

IIF(cvl>0,cvl,0)

but say cvl=4, i want it to display "VL: 4" so i do it like this,

IIF(cvl>0,"VL: "+trim(str(cvl)),0)

it only prints "4".

what's wrong, any help pls?

 

[ramani]

HI

The syntax seems correct. But the copilation may not have taken effect and may be showing you the results of your earlier values.

1. When you compile the project, make sure that you are including Regenerate all components option.
2. Open the report again, do a mock movement of any one control, one point rigt and then back. Then save it. Recopile that.




ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[jerry1117]

It should be either:
IIF(cvl>0,"VL: "+alltrim(str(cvl)),0) or
IIF(cvl>0,"VL: "+ltrim(str(cvl)),0).
I would also code it this way with a string 0.
IIF(cvl>0,"VL: "+alltrim(str(cvl)),"0&quot

Trim only removes trailing blanks. What was actually returned by IIF(cvl>0,"VL: "+trim(str(cvl)),0) was something like "VL: 4". The report field was not big enough to hold the whole string.

Jerry1117

 

[tesar]

R17,
as str(cvl) is default str(cvl,10,0), reduce it to
str(cvl,1)
Tesar

 

[ramani]

Hi R17,

Just check the width of the report variable. Probably that is only one character long in the report.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[R17]

hi all thanks for your replies,

the space for the field is indeed wider in the report.

if i try using iif(cvl>0,"VL: "+alltrim(str(cvl)),"0&quot it only gives me ****.

iif(cvl>0,"VL: "+alltrim(str(cvl)),0) gives me only the value of cvl.

i wonder what's wrong here, any more help pls?

 

[R17]

i noticed that when i try alltrim(str(cvl)) only, it gives me ****.

this is the same with all other variables i have in my report.

using str(cvl,1), still doesn't solve the problem.

 

[torturedmind]

pls. check the picture format property of your textbox. it maybe set to numeric when you are actually returning character data.

kilroy

 

[R17]

torturedmind,

tried that but still it gives me the ***.

weird, huh?

 

[jimstarr]

The only way I've been able to reproduce the asterisk behavior is by setting the variable to something invalid like:

cvl = 3/0


Jim

 

[DSummZZZ]

As torturedmind said, be sure and check the picture clause to make sure it is something other than '9999'. Even if the box appears wide enough to display the entire string, if it is limited to 4 characters, you will get '****'.
Also, since you are trying to display either character or numeric in you IIF(), make sure the IIF() reads like this:
iif(cvl>0,"VL: "+alltrim(str(cvl)),"0")
-instead of-
iif(cvl>0,"VL: "+alltrim(str(cvl)),0)

-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[R17]

hi everyone,

i used sum in the calculate for the iif(dtr.upcode="V",1,0) and it worked just fine!

though i don't get it why, =)