You need to sign in to do that
Don't have an account?
Arash Teimoupoor
email larg report as csv attachment
I'm using the following to email my report as CSV but it just includes the first 2000 rowes in the csv file while my report has more than 50000 rowes. how can I solve this? thanks in advance:
global class Report implements System.Schedulable {
global void execute(SchedulableContext sc) {
ApexPages.PageReference report = new ApexPages.PageReference('/00O60000003XpO6?csv=1');
Messaging.EmailFileAttachment attachment = new Messaging.EmailFileAttachment();
attachment.setFileName('testcsv');
attachment.setBody(report.getContent());
attachment.setContentType('text/csv');
Messaging.SingleEmailMessage message = new Messaging.SingleEmailMessage();
message.setFileAttachments(new Messaging.EmailFileAttachment[] { attachment } );
message.setSubject('test');
message.setPlainTextBody('test is attached.');
message.setToAddresses( new String[] { 'test@test.com' } );
Messaging.sendEmail( new Messaging.SingleEmailMessage[] { message } );
}
}
global class Report implements System.Schedulable {
global void execute(SchedulableContext sc) {
ApexPages.PageReference report = new ApexPages.PageReference('/00O60000003XpO6?csv=1');
Messaging.EmailFileAttachment attachment = new Messaging.EmailFileAttachment();
attachment.setFileName('testcsv');
attachment.setBody(report.getContent());
attachment.setContentType('text/csv');
Messaging.SingleEmailMessage message = new Messaging.SingleEmailMessage();
message.setFileAttachments(new Messaging.EmailFileAttachment[] { attachment } );
message.setSubject('test');
message.setPlainTextBody('test is attached.');
message.setToAddresses( new String[] { 'test@test.com' } );
Messaging.sendEmail( new Messaging.SingleEmailMessage[] { message } );
}
}
https://www.salesforce.com/us/developer/docs/apexcode/Content/apex_analytics_intro.htm
i tried your code, how do i invoke the code from the anonymous window, and how do i check if its working properly or not