Wonder if anyone could help. I have set up a simple report in Microsoft SQL Server Report Builder with a list of jobs from a data source and a basic bar chart with the "Job_Number" as the value (count) and the "Error_Number" as the category.
Easy enough right? Unfortunately I only just noticed that some of the records in the "Error No" column contain multiple values as in the example table below.
I thought I had found a work around using the code below, however it appears it only counts the first error code from the records with multiple values. So in the bar chart the total number of errors was 10 instead of 13.
I have done a few searches on Google to find a solution but could not find anything similar to this situation.
Does anyone have any idea how I could resolve this? Any help would be greatly appreciated.
=SUM(IIF(Fields!erromsg.Value LIKE "3.2","3.2",
IIf(Fields!erromsg.Value LIKE "3.3","3.3",
IIf(Fields!erromsg.Value LIKE "3.4","3.4",
IIf(Fields!erromsg.Value LIKE "3.5","3.5","Other")