March 23, 2015 at 12:30 pm
I am trying to put together a report, with a matrix, that will show the two test results, and the stations where those tests were performed.
The problem is coming in for some days when not all the stations were tested. For example, on 02/23/2015, I had all 7 stations that had both tests performed, but on 03/02/2015, only 4 of the 7 stations were tested (both tests), leaving Stations 5 - 7 without results for either test. The report is currently showing zeros for those Stations without test results on those certain days.
I tried to create an expression to change the value of a 0 to "", but the problem is that 0 can also be a legitimate value for the test results, so now all values of zero will not show.
Expression I Used:
=IIF((Fields!Result.Value = "0"), "", Fields!Result.Value)
I only need legitimately tested zeros to show on this report, and not one where a test was not performed.
I also tried using =IIF((IsNothing(Fields!Result.Value)) , "", Fields!Result.Value), but to no avail.
I also tried using CTE and temp tables within the SQL query to put the results into one row, but it is still creating a new line for each station that had a test, with the other station results then holding a NULL value in that same row.
The Row Grouping properties of the report is Date, Test, while the Column Grouping is done by Station.
Is there a clean way of only getting rid of the non-results for each of the test that are showing zeros, while still keeping the legitimate test results of 0?
March 23, 2015 at 12:32 pm
I tried attaching a screenshot of the report.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply