Question
4
Replies
215
Views
HKEX
Posted: Aug 8, 2022
Last activity: Aug 19, 2022
Closed
The Chart in Report definition
Hi there,
I have a report definition with subreports. And I have select the "Do not display group headings",but when I run this report definition, it always display the "All" in the chart.
So how can I remove the "All" items from legend?
***Edited by Moderator Marije to add Capability tags***
Posted: 2 years ago
I have recreated the joins and do not see the same issue.
Are you sure the output of the SQL function IF used for calculating ProcessName_Label in the subreport is not returning [All] in some scenarios?
Posted: 2 years ago
Yes, I executed the Report query directly in the database, and the ProcessName_Label column won't be [ALL], but it might be empty if the team doesn't have relevant data. Please check the second column in the attached screenshots.
Will this cause it to appear [ALL]? Is there any way to avoid it？Thank you.