want to get a message as "data not found"

[raghavsurya]

Hi,

We have built Strainght line tables for displaying the Profit and Loss account for a client. For few years we do not have data and hence the value appears as zero for those fields.

how can we get a message pop out as "Data not Found". For example.... we are depicting a comparision across years and for a specific year say 2007 we do not have any data and hence when I select the year as 2007 I should get a error message as "Data not found"

Can you please suggest how to do it.

Regards,

Raghav

[#2]

In the General Tab of the Chart Properties - put

GetSelectedCount([year])='2007' in the calculated condition expression box, and then click on Error Messages at the bottom and enter your custom message.

[raghavsurya]

Hi Graeme,

Thanks for your suggestion. But I am not able to include this in the chart box. I am trying a work around wherein I have inserted a text box to provide this error message. The expression I have put in the text box is

No receipt available for this transaction

= if(GetSelectedCount(Year)='2008', 'The Budget and Actual Data for 2008 is not available')

but its not working...... can you please let me know if I am missing anything in the expression.

Thanks and Regards,

Raghav

[#4]

The only thing I can think of is to put

IF(Year='2008',0,1) into the Calculated Condition Expression, with the relevant Error Message ?