• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 439
  • Last Modified:

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".
0
bodeveloper17
Asked:
bodeveloper17
  • 4
  • 4
1 Solution
 
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
 
mlmccCommented:
How can you tell the difference between a new record and one that has had data?

Is that value saved somewhere?

mlmcc
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
mlmccCommented:
Something like

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

mlmcc
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now