i have a query which i run in the database and generate the report in Excel, i need to automate it using crystal report with date prompt so that every time i don't need to run the query in the database.But there are almost 70 columns in that report. the requirement is to automate the report using crystal report and export it to Excel. Even if i somehow adjust the columns in the designer of crystal report, how can i deploy the report or do the settings in crystal or anywhere else so that the report is generated in the Excel Format.