Hi i am new to SSRS reporting services.
I am unable to get the values in my column even the column has the values i need a clarification on Expression calculation filed
so which i am able to get the values on my column but for the columns which does not have a data it is not generating a tab itsef in my Excel sheet
This is my Cube Calculations where i am passing last parameter as null
*
IIF
(
[Measures].[AI HANDLED INBOUND] > 0,
([Measures].[AI TALK TIME] + [Measures].[AI HOLD TIME] + [Measures].[AI WRAP TIME]) / [Measures].[AI HANDLED INBOUND],
NULL
)
BRIVETTE, MONIQUE WILLIAMS, KIMBERLY PATRICIA 906.79
BRIVETTE, MONIQUE WILLIAMS, KIMBERLY PATRICIA 863.81
JHUN, SHANIQUE WILLIAMS, KIMBERLY PATRICIA 791.39
JHUN, SHANIQUE WILLIAMS, KIMBERLY PATRICIA 1717.64
If i pass 0 as my third parameter in my calculations i am getting the column field as 0 values but tabs are generating n Excel sheet.
EX: Supervisor Operations Manager Avg Handle Time
ARSCOTT-CHAMBERS, KHADINE NATOYA WILLIAMS, KIMBERLY PATRICIA 0.00
ARSCOTT-CHAMBERS, KHADINE NATOYA WILLIAMS, KIMBERLY PATRICIA 0.00
ARSCOTT-CHAMBERS, KHADINE NATOYA WILLIAMS, KIMBERLY PATRICIA 0.00
ARSCOTT-CHAMBERS, KHADINE NATOYA WILLIAMS, KIMBERLY PATRICIA 0.00
Pls find any solution..