Hiding chart if no data

[AnnetteB1305]

Hello,

I have a report which shows a chart On change of @logdate and @Thirdparty then show values being a distinct count of @callref

@logdate is date(tablename.logdate)

@Thirdparty is If {tablename.suppgroup}='_THIRDPARTY' then {tablename.owner} else
If {tablename.groupid}='_THIRDPARTY' then {tablename.aid} else
if left({tablename.updatetxt},50) startswith "Call assigned to third party contract 'CCV Ned"
then "NL-CCV" else
if left({tablename.updatetxt},50) startswith "Call assigned to third party contract 'Mcdonalds"
then "NL-MCD" else
if left({tablename.updatetxt},50) startswith "Call assigned to third party contract 'Havi"
then "NL-HAVI" else
if left({tablename.updatetxt},50) startswith "Call assigned to third party contract 'Flucon"
then "NL-Flucon" else {@null}

@callref is If {tablename.suppgroup}='_THIRDPARTY' or
{tablename.groupid}='_THIRDPARTY' or
left({tablename.updatetxt},50) startswith "Call assigned to third party contract"
then
{tablename.callref} else
tonumber({@null})

I need to hide the chart if there is no information but it is currently showing the frame and the legend frame even if there is no information. I also want to show a message
"No Third Party Calls Logged in Last Week" if there is no information.
I have tried the formula if isnull({@THIRDPARTY}) then
"No Third Party Calls Logged in Last Week" and formatting the frame to suppress on condition isnull({@THIRDPARTY}). This works if there is no information to show however it also does the same if there IS information, i.e. it is hiding the chart and showing the message even though there is information to show which shows in a cross tab that I have on the report.

 

[AnnetteB1305]

Please ignore...I have resolved this

 

[lbass]

Please show your resolution so that this thread becomes meaningful to others. Did you test the maximum of the formula for null status?

-LB

 

[AnnetteB1305]

I used the following if distinctcount({@CallRef})=0 then
"No Third Party Calls Logged in Last Week" for the message and distinctcount ({@CallRef})=0 for the suppression of the chart.

Thanks,

Annette