Display the current value or if it is null then previous value

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".
bodeveloper17Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Something like

If IsNull({TheField}) then
    If IsNull({ThePreviousField}) then
        "No Data"
    else
         {ThePreviousField}
else
   {TheField}

mlmcc
0
 
mlmccCommented:
WHere is the user selecting values?

Is this in the parameter prompting screen?

Is this a database field?

Does the report pull all data or is there filtering?

mlmcc
0
 
bodeveloper17Author Commented:
User is selecting the value in a third party application. But the data gets updated in Database.
This is not a parameter.It is a field value
Yes this is a database field.
Right now the report is pulling the value if it is there for that PR.ID, if there is no value then display "No Data"
But the record will have only one value at a time.It can be left blank also.
So show me data if there is value, if there it is empty then show me the previous filled value.
If the record is new, user has not filled any value show me "No data"
Report is grouped by PR.ID and has a selection criteria based on Process Name.
Let me know if you need more info.Thanks for you help.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mlmccCommented:
How can you tell the difference between a new record and one that has had data?

Is that value saved somewhere?

mlmcc
0
 
bodeveloper17Author Commented:
Yes it is saved in another table.
0
 
mlmccCommented:
Is that table included in the report?

mlmcc
0
 
bodeveloper17Author Commented:
Yes i have included that table.
0
 
bodeveloper17Author Commented:
Thanks a lot mlmcc.I changed the formula and it worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.