I am relatively new to database programming and need to know how to make a report work in FoxPro. I have a table with a date field and an amount field. My goal is to create a report that will let me select a date range and print the total number of records and a sum of the amount fields for EACH DAY within that range.

I was thinking about using a Select - SQL statement to retrieve the information into a temporary cursor and then work with it from there using report variables.

Am I on the right track?