Service result between 2 dates

I would like to create a list of all service results within year, displaying service date, service result and to see the next parity data as parity number, birth location, birth date and total born.

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

Or you can use SQL directly:

SELECT ID, SERVDATE, SERVRESULT, SERVRESULTDAYS, BIRTHINGDATE, PARITY, BIRTHLOCATION, TOTALBORN
FROM SERVICERESULT
WHERE SERVDATE BETWEEN '2005-1-1' AND '2005-12-31'
ORDER BY SERVDATE, ID