bodeveloper17
asked on
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".
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".
ASKER
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.
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.
How can you tell the difference between a new record and one that has had data?
Is that value saved somewhere?
mlmcc
Is that value saved somewhere?
mlmcc
ASKER
Yes it is saved in another table.
Is that table included in the report?
mlmcc
mlmcc
ASKER
Yes i have included that table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot mlmcc.I changed the formula and it worked.
Is this in the parameter prompting screen?
Is this a database field?
Does the report pull all data or is there filtering?
mlmcc