Last post Oct 26, 2011 10:01 AM by macca
Oct 26, 2011 08:54 AM|macca|LINK
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)
Oct 26, 2011 09:45 AM|FileFoundException|LINK
Question is not clear but SSRS has functions to count rows.
You can use for example in a textfield =COUNT(Fields!Id.Value)
Oct 26, 2011 10:01 AM|macca|LINK
Thanks that worked.