How to set message instead of no data to display

[#1]

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.

[Anonymous]

Amelia

If you create a Text Box and put this it you'll be able to see the value as per your selections

     = count(Employees)

[#3]

Thanks and if I want to show the No Failures instaed of No data to Display for

% of Failures 

Then how can I set please help me

The % of Failures is calculating like below in expression tab

Sum({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference))

[rajeshvaswani77]

HI Amelia,

Seems the Dimension and Expression being used are not able to relate. Therefore there is no data to display.

thanks,

Rajesh Vaswani

[Anonymous]

Amelia

Glad you are on the road there, sorry about my typo.

Both Calculation Condition and Error Message are expressions so you should be to code whatever Condition or Message you require.

Best Regards,     Bill

[#6]

Thanks and I used

Count(Reference)>0 under Calculeted Condition in general tab

In Error Messages I set Default(Override all error messages) as No Failures

Still it's showing No Data to Display

I am not getting where I am doing mistake. Please help me

[Anonymous]

Amelia

For this No Failures message on what criteria do what it displayed ?

You mentioned earlier :

     Sum({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference))

But your post above above says

     Count(Reference)>0

Sorry if I am being stupid here but I am confused, so could you do a simple statement of requirements as in something like:

     If [This condition] met

          display This Text

     else

     if [Another condition] met

          display Another text

     else

          display nothing

Best Regards,     Bill

[#8]

Thanks and sorry I couldn't understand of after something like in above says. Please help me as I have to set this very urgent please.

[Anonymous]

Amelia

To summarise:

This bit now works ok for you:

With  Calculated Condition of      Count(Reference)>0

Display Error message No Employees if no customer selected

+++++++++++++++++++++++++++++++++++++++

You next mentioned

Additional message No Failures

Expression     Sum({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference))

Would you ever want both expressions displayed or just one of them ?

If just one of them and both conditions are met, which message should be displayed.

Best Regards,     Bill

[#10]

Thanks and I just want only one i,e 'No Failures' so int this how to set it

Please help me.

[#11]

Please help me how to set this as I need this very urgent please.