Question
HKEX
CN
Last activity: 19 Aug 2022 4:32 EDT
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***
Capgemini
GB
HKEX
CN
Thank you for your reply. Please check the attachment. This is the configuration of my report and subreport. If you need any more information, please let me know.
Thank you.
Capgemini
GB
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?
HKEX
CN
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.