convert report data to csv format and send attachment in mail using apex

Question

Please find below code,I am getting attachment in html format. But i need attachment in csv format. Let me know what changes I have to do ?

global class MonthlyScheduler implements System.Schedulable,Database.AllowsCallouts 
    {
        global String ReportId;
        global MonthlyScheduler(String ReportId){
            this.ReportId = ReportId;
        }
        global void execute(SchedulableContext sc) {

            sendNow(this.ReportId);

        }
    @future(callout=true)
    global static void sendNow(String ReportId){

        ApexPages.PageReference report = new ApexPages.PageReference('/'+ReportId+'?csv=1');
        Messaging.EmailFileAttachment attachment = new Messaging.EmailFileAttachment();        
       attachment.setFileName('report.csv');
       attachment.setBody(report.getContent());
       attachment.setContentType('text/csv');
       Messaging.SingleEmailMessage message = new Messaging.SingleEmailMessage();

        message.setFileAttachments(new Messaging.EmailFileAttachment[] { attachment } );

        message.setSubject('Report');

        message.setPlainTextBody('The report is attached.');

        message.setToAddresses( new String[] { '[email protected]' } );

        Messaging.sendEmail( new Messaging.SingleEmailMessage[] { message } );
    }
}

Answer 1

i did it this way and it works just fine

String instanceName = URL.getSalesforceBaseUrl().toExternalForm();
string url=instanceName+'/servlet/PrintableViewDownloadServlet?isdtp=p1&reportId='+reportId;
ApexPages.PageReference objPage = new ApexPages.PageReference(url);

the only limitation is that i couldn't add filters dynamicaly

Answer 2

You need ApexPages.PageReference report = new ApexPages.PageReference('/'+ReportId+'?csv=1&isdtp=p1');

Instead of ApexPages.PageReference report = new ApexPages.PageReference('/'+ReportId+'?csv=1');

I don't know the exact details, but the extra code helps parse the report correctly.