Query results and SSRS Report not displaying the same?

• steven_enk

  SSC Enthusiast

  Points: 143

  More actions

  April 11, 2017 at 3:24 pm

  #322955

  Hello all,

  I have a very curious issue, and am wondering if anybody would have an idea of where to else to look.

  The report I am producing is a two level grouped report, showing transactions and errors that may occur on transactions. When I run the query (Mapics DB2) that supports the report independently, I get the following values for the Potential Duplicate Scan transactions.

  

  When the report is run, the following is displayed.

  Formula for Potential Duplicate Scans column: =Iif(Fields!POTENTIAL_DUPLICATE_SCAN.Value > 0, "YES",  "")

  

  Things I have tried (with no change in view):

  1) Ran the report with the same query from my query engine (eliminating the query parameters from causation).

  2) Validated grouping.

  3) Validate formula.

  4) Cleared sorting and validated values.

  Does anyone have any other ideas as to how to resolve this issue?

  Thanks,

  Steve

• April 12, 2017 at 6:35 am

  This was removed by the editor as SPAM

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  April 12, 2017 at 6:39 am

  #1937822

  Please don't post duplicates  - refer to answers here:
  Query results and SSRS Report not displaying the same?

  Sue