Service list between 2 dates

I would like to create a list of all service within year and to see the parity related data as birth location, wean date, total weaned, days lactating, service date, service male and service result.

Use Query report designer. The setup screen is shown below:

Or you can use SQL directly:

SELECT ID, PARITY, BIRTHLOCATION, ENDLACDATE, TOTALWEANED, ENDLACDATE-BIRTHINGDATE AS DAYS_LAC, SERVDATE, SERVMALE, SERVRESULT
FROM SERVICEEX
WHERE SERVDATE BETWEEN '2005-1-1' AND '2005-12-31'
ORDER BY SERVDATE, ID