This issue occurs because CSV outputs do not support clickable hyperlinks—they only display plain text. Even if a report contains valid URLs, they will not appear as clickable links when delivered as a CSV or HTML attachment. Additionally, Salesforce HYPERLINK() formula fields and Rich Text fields are not supported in Apsona scheduled outputs.
The recommended approach is to first generate the record URLs using a Calculated Step in the Multi-Step Report by constructing links with record IDs (e.g., "https://yourdomain.my.salesforce.com/" + {!Opportunity.Id}). This ensures the report contains the correct URLs for each record.
To make these links clickable, configure the scheduler to send the report using HTML Inline delivery instead of CSV or attachment formats. Email clients like Outlook or Gmail automatically convert URLs in HTML emails into clickable links.
CSV outputs will always show links as plain text due to format limitations, so for any use case requiring clickable hyperlinks in scheduled reports, HTML Inline delivery should be used.