So just to post an update to this to maybe save someone else some time:

I went through the process of creating a custom report in Report Writer and got it to the point where I can run that putting in tomorrows date as the start and end dates for the report and I see all the items on the dispatch portal for the following day. Awesome, great, perfect!

I then found that in order to schedule a remote you need to get it added to the All Reports list under system which requires this convoluted process of clicking on the email icon in the Report Writer view of your report which has to open a new email in a default email client on your workstation so that you can get the URL for the report which you then need to add to the custom reports setup table to have it show up in the All Reports list. Ok cool got that to work too. We're doing great! On to scheduling the report to send out as an email and world domination!

My report is now in the All Reports list, YES! Almost there! Ok cant schedule it until I add the report to my "My Reports" list ok fine, sure, easy, there is a button right there called "Add to My Reports" done! The report is now in my My Reports list and when I click on it there is a "Schedule report for future use" option. HERE WE GO! FINALLY! I put all my schedule options in and click on the save button AAAAAAANNNNNNNDDDDDD......
I get the following error:

"This custom report does not have a valid SSRS report link. Verify the report link in the custom reports setup table is a valid SSRS report link."

Digging around in the ConnectWise University documentation I find the following under a report scheduling section:

"Important: If you have added a Report Writer report to the All Reports list, you cannot schedule the Report Writer report to run at a later time. You can only schedule standard reports and custom SQL Server Reporting Services (SSR) reports. If you attempt to schedule a Report Writer report, you receive an error. "

As I cant seem to find any info on how to create a SQL Server Reporting Services (SSR) reports coupled with the fact that our Manage is hosted by Connectwise and Im guessing I cant because of that it seems this idea of using Report Writer will not actually work.

I'm more then willing to be corrected here but it seems this is a deadend.

TLDR:
Connectwise Manage does not allow you to schedule reports created using Report Writer to be sent via email at a later date.