Is it possible to run a sql query and auto generate a pdf or excel file?

[ashly]

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?

[Lightning]

Yes,
Put the program in the scheduled tasks in windows

[ashly]

Yes,
Put the program in the scheduled tasks in windows

So means I create an exe, which will display the crystal report automatically when form load?

Then I put the exe under window scheduled task?

[Hack]

You would create a task that would run the exe at a specific time.

The work would all be done by the exe...all the Windows Task Manager does is run it for you.

http://support.microsoft.com/kb/323527