If this is not possible, I understand, but…
I have an SSRS BAQ report containing a matrix with several column groups, all grouped on a particular field returned from the BAQ, and then filtered based on the value of that field.
The images are from the actual report: the column is grouping on the BAQ field “Calculated_LaborCodeALT” and filtered for rows where the value is “Warranty.” Other columns filter for other values of that field, like “Production” or “Training.”
When I run this report, there are currently no rows that would fall into the “Warranty” category, and therefore, the entire column vanishes, instead of showing a “0.00” in the textbox for the associated labor hours.
The expression I have in the textbox is:
IIF(IsNothing(Sum(Fields!Calculated_Calc_Labor_Hrs.Value)),0,Sum(Fields!Calculated_Calc_Labor_Hrs.Value))
which I thought would default to 0 if there was a null being returned.
Is it possible to keep the column visible when there is no pertinent data coming from the BAQ?