How to get scheduled report in .csv format?

A scheduled Advanced Report will email out a CSV file.

https://support.sugarcrm.com/Documentation/Sugar_Versions/9.0/Ent/Application_Guide/Reports/Advanced_Reports/#Scheduling_Advanced_Reports

If you don't have Enterprise (hence no Advanced Reports), for Rows and Columns reports you could build something external to Sugar and use the Reports API to retrieve the data in json (I've done it using Mathematica) or create your own Scheduler to run the queries you need to get the data and generate a CSV, then use the MailerFactory to email it to the right people.

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_9.0/Integration/Web_Services/REST_API/Endpoints/Reportsrecordrecords_GET/

FrancescaS

But getting full result set instead of display columns which chosen while report creation using Report module.

But getting full result set instead of display columns which chosen while report creation using Report module.