Howdy all!
So, my scenario: I have a standard form with data coming from an XML document supplied at run time. This form has a lot of options on it, and not all of them are relevant all the time, so it's typical for not all XML nodes to be supplied.
For example, an employee can choose donate to charity as part of their paycheck. When the XML is generated for this report, if they're not donating to the charity, it will not send over 'CharityAmount'. With our old reporting program, if it didn't find a field, it just left the textbox blank, which is what we wanted.
However, if I put in Value property the expression '=CharityAmount', I now get a big ugly box telling me that 'The expression contains object 'CharityAmount' that is not defined in the current context'.
This is a great tool if I'm always expecting CharityAmount - but I'm not. I tried '=ISNULL(CharityAmount,"")' as the expression, but that didn't work. Is there a way to turn off the error messages, or at least just certain ones? If not, is there another way of doing what I need (being flexible if something's not found) other than 'Ensure all XML nodes a report expects is supplied'?
Thanks all!
So, my scenario: I have a standard form with data coming from an XML document supplied at run time. This form has a lot of options on it, and not all of them are relevant all the time, so it's typical for not all XML nodes to be supplied.
For example, an employee can choose donate to charity as part of their paycheck. When the XML is generated for this report, if they're not donating to the charity, it will not send over 'CharityAmount'. With our old reporting program, if it didn't find a field, it just left the textbox blank, which is what we wanted.
However, if I put in Value property the expression '=CharityAmount', I now get a big ugly box telling me that 'The expression contains object 'CharityAmount' that is not defined in the current context'.
This is a great tool if I'm always expecting CharityAmount - but I'm not. I tried '=ISNULL(CharityAmount,"")' as the expression, but that didn't work. Is there a way to turn off the error messages, or at least just certain ones? If not, is there another way of doing what I need (being flexible if something's not found) other than 'Ensure all XML nodes a report expects is supplied'?
Thanks all!