To export a report first recreate it as a JQL in the Search issues view. Once the resulting view illustrates what you want to export use the export function on that view. In cloud that is illustrated by the box with arrow facing down. You can export all fields or those displayed.