Display the current value or if it is null then previous value
Posted on 2009-03-31
If the field value is not null show me the value but if it is null then show me the previous value.
The way it works ,the report is built on Crystal Console and then put on Crystal RAS server where it is taken by third party application, which has the provision of drop down or selection list where the user can pick any one value or leave it blank.
So the client wants show me the value if the user selects a value.
But if the user does not select any value and leave it blank show me the previous value and if that field has never filled and left blank for show me an error message "No Data".