Show message 'No data to display'

[#1]

I've two sheets in my dashboard, called 'Sales' and 'Orders' and one of the filters named 'Status' with the filteroptions 'Invoice' and 'Order'.

When you select the filteroption 'Invoice' or another selection which doesn't include any orders, I want to see in sheet 'Sales' only the invoicerecords of the selection. In sheet 'Orders' I want to see the message 'No data to display'.

The opposite if the filteroption is 'Order' or another selection which doesn't include any salesrecords. I want to see in sheet 'Orders' only the orderrecords of the selection. In sheet 'Sales' I want to see the message 'No data to display'.

When you leave one of the sheets I want the current selections stays active.

How do I achieve this?

For example

Filter = Invoice

Sheet Sales presents:

Article     Invoicenumber     Date               Amount

Greens    1256                       1-3-2012        1.245,-

Basil        5685                       25-5-2013         500,-

When you click on sheet Orders you see the message:

No data to display

When you leave sheet 'Orders' the current selection of 'Invoice' stays active.

[Gysbert_Wassenaar]

If you're using QV11 you can use conditional display expressions. Add two textboxes with your message and set the conditional expression to if(Status='Invoice',0,1) for the textbox on the Sales sheet and if(Status='Order',0,1) for the textbox on the Orders sheet. You can find the conditional option on the Layout tab of the properties window of the object.

[#3 · Accepted solution]

Thank you very much for your helpful answer! I've used a mix of your answer.

1. In the properties of the view in sheet 'Orders', tab 'Layout' I activated the Show Conditional with

    if(Status='Invoice',0,1).

2. I've made a textbox with the text 'No data to display' and set the Show Conditional in the Layout tab to:

    if(Status='Invoice',1,0).

When I have only selected invoices and I go to sheet 'Orders' I see now the desired message!