Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to hide the Title and Column Headers of a chart object if there's no content in chart?
We are using a number of our charts for printed reports. Some charts will have no data if certain data selections are made, and it would be great if we could hide the Title and Column Headers if there's no content.
Do we have any QV Wizz who has cracked this before?
Thank you in advance for your help.
Hi Klaus,
maybe You can hide whole object.
In conditional expression of Presentation Tab
Count(Distinct BRANCH)+Count(Distinct IDNO)+Count(Distinct FROM) > 0
Regards,
Antonio
Attached you have an example
It is possible aid you
Another example
Enrique, thank you. This is helpful.
See below example of what I am looking for, specifically:
Instead of having Chart Title, Column Headers and Total row showing blank when there are no values, I don't want to show anything at all - no title, no column headers and no total row.
Any ideas?
Hi Klaus,
maybe You can hide whole object.
In conditional expression of Presentation Tab
Count(Distinct BRANCH)+Count(Distinct IDNO)+Count(Distinct FROM) > 0
Regards,
Antonio
Thank you ANTONIO MANCINI.
The Conditional Expression on the 'Layout' tab of the object ('Show' section) works perfectly.