locked
COUNT(*) in SSRS RRS feed

  • Question

  • User-2048571045 posted

    I am building an SSRS report.

    I want to get a COUNT(*) of the amount of records returned in this query:

    SELECT        a.Id, a.Forename, a.Surname, b.Location, a.No, a.date

     FROM            main As a INNER JOIN
                             local As b ON local.Loc_ID = main.loc_id
    WHERE (a.date BETWEEN @FromDate AND @ToDate)

    Wednesday, October 26, 2011 8:54 AM

Answers

  • User-60558687 posted

    Question is not clear but SSRS has functions to count rows.

    You can use for example in a textfield =COUNT(Fields!Id.Value)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 26, 2011 9:45 AM

All replies

  • User-60558687 posted

    Question is not clear but SSRS has functions to count rows.

    You can use for example in a textfield =COUNT(Fields!Id.Value)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 26, 2011 9:45 AM
  • User-2048571045 posted

    Thanks that worked.

    Wednesday, October 26, 2011 10:01 AM