locked
SQL query returns 2 records in SQL Query but ReportViewer only displays the last record? RRS feed

  • Question

  • SQL query returns 2 records in SQL Query but report only displays the last record?

    The following returns 2 records, but report only displays last?

    SELECT * FROM [Case] Where (CaseItem IN (4,5)) ORDER BY CaseItem

    CaseItem is an Integer

    Seems like reportviewer does not execute simple SQL correctly.

    • Moved by Lisa Zhu Monday, October 8, 2012 5:39 AM report control related (From:Visual C# Express Edition)
    Thursday, October 4, 2012 4:10 PM

All replies

  • Hi fishinlog,

    From your description , I ‘d like to move this post to  the most related forum .

    There has more  experts in this aspect  , so you will get  better support and  may have more luck getting answers .

    Thanks for your understanding .

    Regards ,


    Lisa Zhu [MSFT]
    MSDN Community Support | Feedback to us

    Monday, October 8, 2012 5:29 AM