Getting "Account Name" to display in Lead report

[yizzung]

Seems like pretty basic functionality for CRM but I can't seem to figure this out. Whenever I include 'account name' in a lead report I get something like this:

Error executing query Query Failed:SELECT leads.id primaryid ,leads.converted leads_converted ,leads.date_entered leads_date_entered ,leads.lead_source leads_lead_source ,leads.status leads_status ,leads_cstm.ce_download_c leads_cstm_ce_download_c ,leads_cstm.web_activity_c leads_cstm_web_activity_c ,CONCAT(CONCAT(IFNULL(leads.first_name,''),' '),leads.last_name) leads_full_name ,accounts_leads.account_name accounts_leads_account_name FROM leads LEFT JOIN leads_cstm leads_cstm ON leads.id = leads_cstm.id_c WHERE (1=1) AND leads.deleted=0 LIMIT 0,100::MySQL error 1054: Unknown column 'accounts_leads.account_name' in 'field list'

I obviously can't select records from a related table because these are leads that have not yet been converted (so there is no related Account table yet).

This is very, very basic functionality. All I want is a lead report that includes the names of the companies. Can this not be done in sugar? (We're on enterprise, 5.1.0b, if that matters.)

[sugarcane]

Hello yizzung,

this was a known bug for 5.10b, #26006. You can view it here. Because you have the Ent version of Sugar, you should be able to log a case with Sugar support. Ask them if they have a patch fix for this bug that they can apply to your instance. If not, they will probably suggest that you upgrade to a more recent version where this problem is fixed.

[yizzung]

Great! Thank you so much. I've been scratching my head on this one for some time now...

Cheers