Click here to Skip to main content
15,886,258 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
*
VB
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.

VB
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..
Posted
Updated 21-Jul-14 4:23am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900