Reports

hi haritha raghavan 

The advanced report method is explained here:

https://support.sugarcrm.com/knowledge_base/reports/reporting_on_records_change_log_via_advanced_reports/

or you can create the BPM method as explained here:

https://support.sugarcrm.com/knowledge_base/sugarbpm/capturing_how_long_a_record_spends_in_each_status_using_sugarbpm/

hi haritha raghavan 

The advanced report method is explained here:

https://support.sugarcrm.com/knowledge_base/reports/reporting_on_records_change_log_via_advanced_reports/

or you can create the BPM method as explained here:

https://support.sugarcrm.com/knowledge_base/sugarbpm/capturing_how_long_a_record_spends_in_each_status_using_sugarbpm/

Thank you. I've created both But I was wondering if I can create a custom query where there can be custom field created to show the date when the opp came to a stage and when it left the stage?