Columns are Hiding when there is no data in CrossTab

[Pratap Reddy]

Hi,

Date            EMPID   Pay Type   Hrs
10/12/2017   100                A            1
10/11/2017   100                A            2
10/12/2017   101                B            5
10/12/2017   102                C            9
10/12/2017   103                D            13
10/12/2017   105                E            17
10/1/2018           100                A   
10/1/2018           101                B            21
10/1/2018           102                C   
10/1/2018           103                D            27
10/1/2018           105                E            31


I used date prompt has Date and Column - Paytype, row - EMPID and Measures - Hrs

when i trying to run I'm getting the output which have values and without values are displayed and when my client is trying is displaying values which has hrs and rest of columns are hiding.

If the give the Date prompt 10/1/2018

i'm getting A-E Pay types but for my client B,D,E.

Please let me know do i need to chance any properties.

Thank you in Advance.