Currently I have a report program, when user click, it will generate select records from MS SQL Server and a crystal report refers to the table to get the records.

Is it possible to do that automatically?

example:
every morning, execute the select record query, but how to display the report automatically?