Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a striaght table and when I am clicking on any selection based on selection the data is changing and when there is no relevant data it is showing 'No Data to Display'. My user wants to see 'No Employees' instead of 'No Data to Display'.
Could anyone help me how to set this as I am not aware of this earlier.
Thanks in advance.
PFA my solution.
I have changed the expressions, becuase you were trying to SUM references that could contain characters.
I have chaned the SUM by COUNT.
Let me know if this helps.
Amelia D
On the General tab of you Straight Table click on the Error Message button and you can adjust the default QV error messages.
Also on the same tab you can add a Calculation Condition to fine tune things to get want you need.
Best Regards, Bill
Hi,
In the General tab of the Chart properties, there is "error Messages" button. You could try setting a custom error message instead of the one you are receiving.
Hth.
Thanks and I set Default(Override for all error messages) as No Employees but it's not changing stiil it's showing 'No Data to Display' do I need to change anything?
Please help me.
Amelia
In the Calculation Condition add an expression like:
count(Employees) = 0
Then put your message text in Error Message instead of Calculation Condition Unfulfilled
Best Regards, Bill
Thanks and I did the same thing and it's showing completely No Employees even if there is data
Please help me am I missing anything?
Amelia
Can you reply & paste your Calculation Condition expression into it for us to look at.
Best Regards, Bill
The expession is
Count(Employees)=0 under Calculated Condition in general tab
Amelia
Ooops !! Sorry my bad :
I should have said
count(Employees) > 0
Amelia
Put the message on "unfullfilled calculation condition"
best regards
chris