March 3, 2009 at 1:58 pm
Hi I have a report field that's value is derived from:
="Customs Value: " + FORMAT(First(Fields!CustomsValue.Value),"#,#0.00")
I would like to hide if field does not return a value. I tried:
=IIF(Fields!CustomsValue.value = "",True,False)
When rendered this returned error:
Input string was not in a correct format
Any pointers on what I might be doing wrong?
Many Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 4, 2009 at 7:33 am
Phil,
I'm not sure which expression is causing the error.
You may want to try this for setting the visibility:
=IIF(Fields!CustomsValue.value is Nothing,True,False)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 5, 2009 at 2:07 pm
Thanks Jack I will give that a try.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply