I have the SQL code for one of the select list columns as shown below in the SSRS Data set query level.
Example : Select IsNUll(max(ET.[# Utilizations by Utilization Method]),0) as [Employee Period Total]
SQL Result Set Output :
The above code when run in SQL displays correctly with zeroes if NULL values are available from the Source tables.
Now at the SSRS Report level design I have grouped with more than one values.
Even at the expression I have given =Fields!Employee_YTD_Total.Value but report output displays blank
In order to evaluate 0 from the SQL result set I even tried equating the values to 0 like
= Iif(Fields!Employee_YTD_Total.Value = 0 ,0,Fields!Employee_YTD_Total.Value) but still the report outputs is blank.
Issue/Query : Why it displays blank and I should have this as 0 in the report output to eliminate blank as this would be not appropriate to the end users to validate. What has to be changed either at the SSRS level or at the SQL level
Thanks in Advance