Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
New_DeveloperNew_Developer 

help with a Report

Is there any way in the Report we can get only the latest opportunity associated to an Account? and anothet report with largest opportunity Amount ?

 

Thanks

Satish_SFDCSatish_SFDC

Hi,

I can think of two indirect ways of acheiving this.

 

1. Create a visualforce page with your custom queries and render the page as PDF.

 

2. Create two hidden checkbox fields in your opportunity object (IsLatestOpportunity__c , IsLargestAmount__c) and write an after update trigger on Opportunities to check or uncheck the fields accordingly (by checking all the Opportunities associated with that account). You can then create a standard 'Accounts with opportunities' report and filter by the checkboxes.

 

If you have already solved this by using some other way, please let us know so we could benefit.

 

Regards,

Satish Kumar