+ Start a Discussion

record with approval information in vfpage

i want to run report that shows the record and the approvaldate, approval status. we cannoot achieve this by normal report. we need to create a vfpage for it. Please let me know how to achieve this by vfpage.
Shashikant SharmaShashikant Sharma
Hi Madhu,

Go to Reports => Select Ädministrative Reports" Report Type => All Pending Records 

If this does not help then you could develop your visualforce page. Approval related information is saved in following objects:

ProcessInstance An instance of a single, end-to-end approval chain.
ProcessInstanceHistory History of changes to a process instance.
ProcessInstanceStep One step in an approval workflow process instance.
ProcessInstanceWorkitem A pending approval request to a specific use

see this for more:


Madhu - You can still able to reporting on Approval process without creating visualforce page. If you like to build custom report apart from what Shashikant suggested, follow the below steps

1. Gotp > Setup > Create > Report Types
2. Click 'New CustomReport Type'
3. In the Primary object select 'Process Instances' and fill all other mandatory fields
4. In the next window select Process Instances Node
5. Save your Report Type

Then go to the Report tab and create new Report for approval process and add whatever the fields you want to include from the process instances object.

Check this link for to know about list of fields available for Approval History Reports - https://help.salesforce.com/HTViewHelpDoc?id=approval_history_reports_fields.htm&language=en_US (https://help.salesforce.com/HTViewHelpDoc?id=approval_history_reports_fields.htm&language=en_US)



Thanks for your response. i want to display approval info that is aprovername,approver date or approval status along with the record.

If i run a report type on the Proces instance how can i merge with the record