title: BLANK VALUE IN SSRS BUT DATA IN SQL QUERY
body: <p>I'm working in a solution in SSRS that it's driving me crazy, I will explain it a bit before shows you my problem:</p>
  
  <p>Select 25 data values from a table with analog input data (from current, voltage, pressure, etc. tags) using parameters @startDate = yeterday 6am and @EndDate = today 6am. Now we have a table with 25 values from 6am to 6am from different tagID's. </p>
  
  <p>My problem starts when just one tagId of 16, it's showing me in the SSRS presentation values 0.0000 when in the Sql output shows me -0.00548...
  For practical purpouses I will just use 2 tagIds (MSF_PDI_003, MSF_PDI_004)</p>
  
  <p>Here the SQL Query:</p>
  
  <pre><code>declare @startDate  datetime2 = '2017-04-19 11:00',
          @endDate    datetime2 = '2017-04-20 11:00';
  
  SELECT InstaTime,
      MSF_PDI_003,
      MSF_PDI_004
  FROM (
      SELECT 
          DATEADD(HH,-5,H.time) AS InstaTime,
          SUM(
              CASE
                  WHEN t.tagName = 'analog.MSF_PDI_003.curval'
                      Then H.value
                  ELSE 0
              END) as MSF_PDI_003,
          SUM(
              CASE
                  WHEN t.tagName = 'analog.MSF_PDI_004.curval'
                      Then H.value
                  ELSE 0
              END) as MSF_PDI_004
      FROM hour H
      INNER JOIN tag T 
          ON T.tagId = H.tagId 
      WHERE T.tagName IN 
          ('analog.MSF_PDI_003.curval', 'analog.MSF_PDI_004.curval')
          AND H.time &gt;= @startDate
          And H.time &lt;= @endDate
  
    GROUP BY time
      ) QueryData
  
  order by InstaTime desc
  </code></pre>
  
  <p>And this the result of the query:</p>
  
  <p><a href="https://i.imgur.com/GET2Y0N.png" rel="nofollow noreferrer">SQL QUERY RESULT IN SQL-SERVER</a></p>
  
  <p>And these are the expressions that I'm using in the textboxes of the tablix in the SSRS (I used a test dataset for this query: summary_prueba)</p>
  
  <pre><code>=Fields!InstaTime.Value         
  =Fields!MSF_PDI_003.Value           
  =Fields!MSF_PDI_004.Value
  </code></pre>
  
  <p>And here the results of the table in SSRS:</p>
  
  <p><a href="https://i.imgur.com/GbY992s.png" rel="nofollow noreferrer">CLICK IMAGE: SAMPLE2 SRSS</a></p>
  
  <p>What could be the problem around here? 
   * Is the Only one with negative values, could be forcing a round? Something about a different format I should use?</p>
  
  <p>Driving me nuts and can't find what's wrong. I tried to change the format and is the same, can you guys please help me? Because this thing doesn't let me sleep at night, I'm starting to have nightmares lol.</p>
  
  <p>I'm using SQL Server 2012, and for the report MS Visual Studio Shell 2010.</p>