Better option would be to have them as related report. and link them on filters (Link not necessary).
We have many reports which display both Incidents and work orders together in one.
To do this, create an incident report and work order report . Make sure you check the co display box while creating both reports. (If you have no user filters)
Then go back to the incident report edit mode >> Go to the Related Items tab >> And then search and link the work order report , to display below or on top as per your requirements and save.
You will now see the reports as you require.
If you have user filters like dates , you can link them together , so the user only needs to apply the filter once.
Create a custom view with this below form, it has different types of records (Incidents, Work orders etc.) all in single form out of the box.
The missing link for that view you were trying to create might be SRM:Request and SRID, if your system is setup to always create Service Requests; such view could even handle grouping different applications used by the same PDT, but you'd either end up with multiple columns for application-specific variants of (essentially) identical attributes or be forced to merge each set of such attributes into common columns manually.