none
ReportViewer only displays 1 record even though SQL query returns 49 records, why? RRS feed

  • Question

  • ReportViewer only displays 1 record even though SQL query returns 49 records, why?

    Query as follows:

    SELECT CaseNum2 AS 'field1', DescEvid AS 'field2', CaseNum AS 'field3', CaseNum3 AS 'field4' FROM [Case]  WHERE (CaseItem < 50  )

    Even when field1 - field4 are in a ReportViwer list, only 1 record is displayed.

    If you capture the SQL before executed, and execute in New Query 49 records are returned.

    Tuesday, October 9, 2012 7:20 PM