Export Salesforce standard Report in Visualforce page




Many of us might be developing some custom code to export data to excel. You can use this simple hack to generate excel from Salesforce standard report.

String reportDeveloperName = 'Sample_Report';
reports = new List([select developername,id from report where developername= :reportDeveloperName]);  
mailLogReportUrl = URL.getSalesforceBaseUrl().toExternalForm() + '/' + reports[0].id + '?pv0=' + pv0 + '&export=1&enc=UTF-8&xf=xls';

Comments

Post a Comment

Popular posts from this blog

How to deploy Processes in Process builder using ANT?

Image
How to deploy Processes in Process builder using ANT? This post helps you learn how to deploy Processes in Process builder using ANT . Processes are stored as Flows in metadata . Use the below markup in your package.xml to deploy Process . Where FLOW_NAME  is combination of API Name and version of the process. Below screenshot explains how to give the FLOW_NAME. Note!: Even if you are deploying an active process, the process will be deployed in  in-active status in target environment. So, you have to activate the process in target environment manually once it get's deployed. Where can I notice the syntax of FLOW_NAME? You can observe the syntax of FLOW_NAME  when you upload the process using change set. To add a process to change set, select the component type as Flow Definition. After uploading the changeset, you can see a change in Type and API Name   of the component. Did you observe one more thing from the screenshot? Though there ar...
Read more

New Beta Architect Certifications by Salesforce

A very good news for Salesforce architect certification aspirants! Salesforce is going to launch two new certifications in Architect category. As a part of this, it launched beta exams which are free. Below are the details of two certification exams: 1. Salesforce Certified Integration Architecture Specialist 2. Salesforce Certified Development Lifecycle and Deployment Specialist Pre-registration for both beta exams opens March 23, 2016 in Webassessor. Space is limited so please register early. The beta testing period runs April 1 - 8, 2016. Please note, beta exams are available at testing centers only and cannot be completed through online proctoring. Beta exams contain a larger number of questions compared to our master exams, and pass/fail results are generally made available 4 - 6 weeks after the beta testing period closes. Exam results will be based only on the questions that are selected for the master exam. Once they perform beta analysis, you will receive your pass/fa...
Read more