Hide chart in reporting on 'no data'

Goodday everybody,

Could anybody help me with the following:
I am creating a report with some basic graphs, now for some situations there would be no data on that graph so it would display “No Data” (default message).
I would like to toggle the visibility of the graph on this message, so if there is no data to display hide the complete graph.

I think this could be done by creating a script function on this graph but i don’t have the any idea what parameters to call in this script, any help would be highly appreciated!

You could drive the ‘Visible’ property of the chart off of the count of data in the datasource. Right click the ‘Visible’ property, select ‘Use Dynamic Data Key’, then populate the data_key field with count. This will toggle the visibility of the entire chart whenever the datasource has no result rows.

1 Like

Thanks Paul,
that is one quick and easy way to do it!

I had no idea this was even possible!