Post reply

Set Visibility

  • March 25, 2009 at 2:35 pm

    #219425

    I would like to hide a field if no value is returned. The expression on the field is:

    ="Shipment Value: " + FORMAT(First(Fields!ShipmentValue.Value,"Shipments"),"#,#0.00")

    I added the following to the visibilty property (have tried variants):

    =IIF(Fields!ShipmentValue.Value = "",True,False)

    The report opens, I enter the parameter then hit view report. If the record does not have a value then the field is hidden. If the field should return a value a error is generated:

    The hidden expression for the textbox 'ShipmentValue' contains an error: Input string was not in a correct format?

    Any ideas?

    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 30, 2009 at 6:23 am

    #968250

    Hi ,

    Try this out:

    =IIF(Fields!ShipmentValue.Value is nothing,True,False)

    Thanks,

    Richa

  • March 30, 2009 at 2:00 pm

    #968647

    Hi. Thanks for the post. I resolved this yesterday on the train 🙂

    =IIF(Fields!MyField.value = Nothing,True,False)

    Thanks for posting.

    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