Pulling data from lookup fields

Pulling data from lookup fields

If I try to pull in CRM data from a lookup field, it only shows a number and not the actual name. Is there a way to get around this? It impossible to do reports using lookup field data.