Arun kumar (Arunk138)
HCL Technologies

HCL Technologies
Arunk138 Member since 2013 13 posts
HCL Technologies
Posted: August 16, 2017
Last activity: August 16, 2017
Posted: 16 Aug 2017 8:53 EDT
Last activity: 16 Aug 2017 9:59 EDT

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


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)

Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.