To generate a custom report in TimeCamp, you can specify the data range and use an API token from your profile settings. The report is generated in an Excel file format, which allows for further analysis and customization. Currently, TimeCamp is working on improving the report structure for more professional output options.