The quick answer to the question is for me to stop being an idiot.
I had written my report, I had uploaded the report, it was running fine.
I then tried to add the report into the solution, opened my solution –> reports –> adding existing
I then couldn’t find my report!
checked the reports, yep it’s there
did an advanced find, the report appears.
I then edited the report and remembered, this report is a my report, a personal report.
This is the same as creating a personal view, unless you share it everyone then no one else can see.
Reports are slightly different because you can choose an option called Make available to organisation.
To find this option you have to go to the report you created –> Edit –> Actions –> make available to organisation
Then everyone can see it and more importantly you can add to your solution
if you have a change of mind and want the report to be viewed by only you, you can in Actions choose to revert to personal report.