Question

1
Replies
173
Views
Arunk138 Member since 2013 13 posts
HCL Technologies
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed

Report Definition_(Display value across column option) Count with zero

Hi,

A Report definition is designed to display the list of SLA deadline cases for next 7 days. It's achieved by using Display value across column option. The output of the report is displaying the no of deadline cases for next 7 days fine. The issue is if no deadline cases available for anyone of the next 7 days the column for that date is not displaying but expecting to be display with the count as 0.

Current behaviour (Report output):

Workbasket ------9/16/2017-------9/17/2017 ------ 9/19/2017

A ----------------------5 -------------------2 --------------------4

B ----------------------1-------------------- 5 ------------------- 1

Expecting Behavior:

Workbasket -------- 9/16/2017 ---------- 9/17/2017 ----------- 9/18/2017 ---------- 9/19/2017

A ------------------------5 ------------------------2--------------------------0------------------------4

B------------------------1--------------------------4--------------------------0------------------------ 1

(its eliminating the space after save the query so added - between every column to show like report, pls dont confuse)

Reporting
Moderation Team has archived post
Share this page LinkedIn